How to find the locks present in oracle database

How to find the sessions using lot of temp

How to find the sessions generating lot of logs

Query to get child table and foreign key status

scripts to monitor standby database

How to get ddl of all tablespaces in oracle

Query to check tablespace free space

How to find log gap between primary and standby db

How to find free space in UNDO tablespace

How to find the temp tablespace usage

monitor rman backup progress

How to find the wait events present in database

How to find the session using lot of undo