Many times questions are being asked about how to find the Oracle database version and version of various Oracle utilities in Linux, Solaris, AIX, and Windows. Let’s check out how is the oracle database version defined and How to find the Oracle database version Oracle Database Versions How to check Oracle database version in Linux […]
How to find the Oracle database version Read More »
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 »
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
ORA-03113: end-of-file on communication channel Read More »
Statistics can become stale when the data in the table changes substantially. Up-to-date statistics are important to generate good execution plans How does Oracle decide if the stats have become stale Stats are considered stale when #(INSERTS + UPDATES + DELETES) >= 10% of NUM_ROWS from dba_tables: The parameter setting required to Track the table
How to check Stale statistics in Oracle Database Read More »
Constraints on a table in Oracle can be found using the below viewsuser_constraints: It provides information about constraints owned by the current user.all_constraints: shows information about constraints accessible to the current user, including those owned by other users.dba_constraints: provides information about all constraints in the database and requires DBA privileges.User_cons_columns: it provides information about columns
How to check all constraints on a table in Oracle Read More »
