Archive for February, 2007

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% […]

ORA-00600 [kjbrasr:pkey], [122722], [], [], [], [], [], []

Last week on wednesday  we had experienced the following error in our instance 2 of the 2 node RAC setup in the alert log.
Wed Feb 14 23:34:30 2007
Errors in file /oracle/app/oracle/admin/SSKIDB/bdump/sskidb2_lms1_6811.trc:
ORA-00600: internal error code, arguments: [kjbrasr:pkey], [122722], [], [], [], [], [], []
Wed Feb 14 23:34:31 2007
Errors in file /oracle/app/oracle/admin/SSKIDB/bdump/sskidb2_lms1_6811.trc:
ORA-00600: internal error code, arguments: [kjbrasr:pkey], [122722], […]


Close
E-mail It