The “library cache pin” wait event in an Oracle database occurs when a session is waiting to acquire a shared lock on an object in…
Leave a CommentCategory: Database Troubleshoot
Converting a database SID from uppercase to lowercase in the Oracle database can be needed sometimes. Below are general steps for converting a database SID…
Leave a CommentThe SCM0 background process in Oracle RAC (Real Application Clusters) is a component of the Oracle Clusterware and is responsible for managing the shared resources…
Leave a CommentThe Result Cache is a feature in Oracle 11g and later versions that allow the database to store the results of frequently executed queries in…
Leave a CommentThe “ORA-30036: unable to extend segment by 8 in undo tablespace” error message in Oracle databases indicates that the undo tablespace has run out of…
Leave a CommentWe have seen “enq: UL – contention” wait event a couple of times in our Oracle Database. It occurs when there is contention for an…
Leave a CommentHigh I/O (Input/Output) activity in an Oracle Database can indicate that the system is under heavy load and this may lead to performance issues. High…
Leave a CommentThe ORA-30036 error is a common issue that can occur in an Oracle Database when the system is unable to extend a segment by a…
Leave a CommentTracing a SQL statement, generating TKPROF of the trace and understanding it carefully are some key steps that you will have to do when faced with a tough to break performance issue. This post will describe the methodology of this process.
Tkprof is very useful for diagnosing performance issues. It essentially formats a trace file into a more readable format for performance analysis. The DBA can then identify and resolve performance issues such as poor SQL, indexing, and wait events.
2 CommentsIn one of our database where GoldenGate setup is done, RMAN process was not able to delete the archive logs. The error message that coming…
Leave a Comment