DBA Sniper

Query to Compile_dependent_objects in Oracle

Query to find Blocking Session History in Oracle

List out the database all directories with full path

Impdp example for Table Restore with specific Date Format Condition using par file

Query to Estimate Index Size before creation

To execute manual SQL Tunning Advisor

Query to Fetch RMAN Backup detail from query.

How to estimate Table size with new large data before inserting

Query to find Long running Process Name.

Query to check long running query status in oracle

Query to find RMAN Backup log from SQL query

Query to find Undo usage with SID & Username in Oracle