SQL Plan Management (SPM) in Oracle is a preventative mechanism that provides a level of control over the execution plans used by the Oracle optimizer. It ensures that regression due to changes in execution plans doesn’t occur, even as the database undergoes changes such as database upgrades, a gathering of new statistics, or changes to …
Sql plan Management in Oracle Read More »
In this post, we will check out how to move SQL Profiles from One Database to Another How to move the sql profiles in Oracle Suppose you have created a sql profile in System A and Now you want to transfer that sql profile to System B. Step 1On System A: Creating a staging table …
Move SQL Profiles from One Database to Another in Oracle Read More »
Sometimes you want to drop the histogram of a particular table and dont want to generate a histogram for a particular column in the table. let’s see how we can achieve it 11G and the above solution First of all, you can delete the existing histograms using the below command BEGIN dbms_stats.delete_column_stats( ownname=>’SCOTT’, tabname=>’TEST’, colname=>’UNIQ_ID’, …
How do I drop the histogram on a column and prevent to generate in future Read More »
AD online patching is a new feature in EBS R12.2. We have a different command line than adpatch for that feature. Here in this article, I have given a very common and useful 31 adop patching commands line for R12.2 Get examples of adop commands adop -examples Get help with the command line option for …
Useful adop (AD online patching ) Patching commands Read More »
ORA-03113 is quite a common error. Let us take a deep dive into it Issue ORA-03113: end-of-file on communication channelCause: The connection between the Client and Server process was broken. It may also happen if the external agent extproc crashes for some reason.Action: There was a communication error that requires further investigation. First, check for …
The concept of a “Recycle Bin” plays a crucial role in data recovery and management. This feature, introduced in Oracle 10g, is akin to the recycle bin in Windows or the trash in macOS, providing a safety net for data that has been deleted. In this article, we will discuss the recycle bin in Oracle, …
How to check recycle bin in Oracle: Purge, enable/disable Read More »
