There are many scenarios, DBA struggling to identify the sessions running in database on sudden adhoc request. To capture the session quickly with the information what we get is really…
Read MoreStep 1 – Identify corrupt datafile The corruption may be reported at the application level, such as DBV and RMAN, or the alert.log. Step 2 Run DBV/Rman validate on affected…
Read MoreDiagnosing performance issues in old sessions is easy with an Oracle Database feature called Active Session History. Every second, Active Session History polls the database to identify the active sessions…
Read MoreWhat Is an Execution Plan? When you send a query to the database, it’s the job of the SQL optimizer to figure out how to execute it, and that process…
Read MoreRAC DATABASE Crash with ORA-03113 error Sometimes, RAC database after clone failed to start with ORA-03113 error. This is because of log_archive_config is not same across all instances of the…
Read MoreWhen 2 rac node database started, it throws ORA-19808 error as below. SQL> startup pfile=’/tmp/pfile.ora’; ORA-32006: SEC_CASE_SENSITIVE_LOGON initialization parameter has been deprecated ORACLE instance started. Total System Global…
Read More