SCRIPT

Find sessions consuming lot of CPU

Use below query to find the sessions using a lot of CPU. col progra...

Get ospid from sid

Below is the script to find the os server process id of a SID. set lines 123 col USER...

Get hourly database growth report

Below script will generate the database size for past few days(pe...

Find sessions holding library cache lock

Below are the scripts for finding the sessions holding lib...