In Oracle Database, an invisible index is a type of index that is not used by the optimizer by default but can still be used…
Leave a CommentCategory: TUNING
The parallel hint in Oracle Database is used to specify that a particular query or operation should be executed in parallel mode, using multiple parallel…
2 CommentsHere are a few scripts that can help you find the number of executions of a specific SQL_ID in an Oracle database: Scripts based on…
Leave a CommentIn an Oracle Database, the GC buffer busy acquire wait event occurs when a session tries to acquire a buffer from the buffer cache and…
1 CommentThe below script can be used to run SQL tuning advisor manually. CREATE TUNING TASK DECLARE l_sql_tune_task_id VARCHAR2(100); BEGIN l_sql_tune_task_id := DBMS_SQLTUNE.create_tuning_task ( sql_id =>…
Leave a CommentThe “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 CommentSQL Profile and SQL Baseline are both used to optimize the performance of SQL statements in Oracle databases. However, they work in slightly different ways:…
Leave a CommentPL/SQL lock timer wait event in Oracle occurs when a session is waiting for a lock held by another session to be released. This can…
Leave a CommentOracle 19c databases support several different types of indexes, each with its own specific use cases and characteristics. An index in an Oracle database is…
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 Comment