How to find cpu and memory information of oracle database server

Below script is useful in getting CPU, memory and core, socket information of a database server from SQL prompt. SCRIPT: [crayon-5beb0e77ca933249304162/] OUTPUT: [crayon-5beb0e77ca93a085235253/]

Find sessions consuming lot of CPU

Use below query to find the sessions using a lot of CPU. [crayon-5beb0e77cb04f120899907/]

Get ospid from sid

Below is the script to find the os server process id of a SID. [crayon-5beb0e77cb2b7962518590/] SEE ALSO – Get sid from ospid

Get hourly database growth report

Below script will generate the database size for past few days(per hour) [crayon-5beb0e77cb525894952233/]

Find sessions holding library cache lock

Below are the scripts for finding the sessions holding libary cache lock: For standalone db: [crayon-5beb0e77cb7b2851566473/] For RAC DB: [crayon-5beb0e77cb7b8245257646/] or [crayon-5beb0e77cb7bb30124...

Skip to toolbar