| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: OT : kernel using 75% of CPU
Hi, Jerry,
Next time you see top output like shown below, please provide this information:
In SQL*Plus:
select * from v$session_wait where sid = (select sid from v$session where paddr
= (select addr from v$process where spid = 2286));
may need to run it a few times. Post it to the list (or email me) unless the wait is like 'SQL*Net%' or '%timer%' or 'rdbms%'.
And also find the SQL by select * from v$sql where address = (select sql_address from v$session) once you know the SID
and
On OS:
truss -flp 2286
(the first 100 lines or so should be OK; if there's a pause in running truss,
indicate where the pause happens)
Also let us know if there's anything special in alert.log and any new file in udump.
Yong Huang
yong321_at_yahoo.com
you wrote:
PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
2286 oracle 1 0 0 1844M 1814M run 9:44 13.90% oracle 11068 oracle 1 0 0 2056K 1536K cpu0 0:02 1.53% top 11333 oracle 1 0 0 1150M 1124M cpu1 0:01 1.39% oracle __________________________________________________Do You Yahoo!?
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: yong huang INET: yong321_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Thu Aug 30 2001 - 10:06:10 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |