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…
1 CommentCategory: DATABASE
To fetch the DDL of a table: SELECT DBMS_METADATA.GET_DDL(‘TABLE’, ‘table_name’) FROM DUAL; To fetch the DDL of a view: SELECT DBMS_METADATA.GET_DDL(‘VIEW’, ‘view_name’) FROM DUAL; To…
2 CommentsMost Oracle DBA & Oracle Apps DBAs are already aware that the technology world is moving fast and that is a fact that no one…
Leave a CommentThe 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 CommentsThe below script can be utilized to find if any UNIX process has a database session linked to it and if yes, provide all the…
Leave a CommentThe below script can be used to find SQL details from AWR. set lines 155 col execs for 999,999,999 col avg_etime for 999,999.999 col avg_lio…
Leave a CommentBelow is some basic information on how database level parameters are managed between CD and PDB databases in Oracle multitenant architecture: Changing parameters for CDB…
Leave a CommentHere are a few scripts that can be used to compile invalid objects in an Oracle database: Note: Please make sure that you have the…
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 CommentConverting 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 Comment