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: Database Scripts
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 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 CommentHere 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 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 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 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 CommentBelow are some of the frequently used commands related to Transparent Data Encryption (TDE)
— TO FIND WHICH ALL TABLESPACES ARE ENCRYPTED
SQL> select * from dba_tablespaces where encrypted='YES';
OR
SQL> select * from V$ENCRYPTED_TABLESPACES;Leave a Comment
Usually we monitor the EXPDP/IMPDP jobs by monitoring the log files generated by expdp/impdp process. Also we monitor alert log too just in case some error pops up. This helps most of the time. If you have a long running expdp/impdp sessions as you are exporting/importing huge GBs then it helps to have a more detailed monitoring of the expdp/impdp jobs. Some of the useful queries which can be used to monitor the Data Pump Jobs are mentioned below.
To start with some of the important tables/views that you should refer to monitor Data Pump Jobs are:
2 Comments