

Find current running sqls Find active sessions in oracle database Find waitevents in database Find sessions generating undo Find the temp usage of sessions Find sessions generating lot of redo Get size of the database Monitor tablespace usage Monitor undo tablespace usage Monitor TEMP tablespace usage Find blocking sessions Find long running operations Find locks present in database Find queries triggered from a procedure Get sid from os pid kill all session of a user Kill all sessions of a sql_id get parallel query detail Kill snipped session in db Top Query with high elapsed time Monitor parallel queries Find the locked objects Check open cursors Session login history from ASH Buffer Cache hit ratio Find top disk_reads by an user Get os pid from sid Get active sid of a pl/sql object Find buffer cache usage Monitor rollback transactions Find column usage statistics Get background process details oracle db is 32bit or 64 bit? oracle license usage info db optimizer processing rate expdp to asm diskgroup
