Archive for the 'Database Performance' Category

How to Find top CPU consuming queries in Unix

In Unix we generally use “top” and “vmstat” commands to determine the utilisation of CPU.
The top comand usually refreshes after every 5 secs or which can be altered .
The output of top command can be similar to below
load averages:  0.71,  0.70,  0.71;                    up 2+14:47:19   11:50:45
189 processes: 188 sleeping, 1 on cpu
CPU states: 82.5% idle,  9.1% […]

SAMPLE ADDM REPORT

SAMPLE ADDM REPORT
Share This


Close
E-mail It