RE: OT : kernel using 75% of CPU

From: Rao, Maheswara <Maheswara.Rao_at_Sungardp3.com>
Date: Thu, 30 Aug 2001 09:05:27 -0700
Message-ID: <F001.0037D2E9.20010830084151@fatcity.com>

Jerry,

Be aware that the system performance degardes drastically while truss is running.

Rao
Maheswara Rao

-----Original Message-----
Sent: Thursday, August 30, 2001 11:36 AM To: Multiple recipients of list ORACLE-L

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!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com
--

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-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Rao, Maheswara
INET: Maheswara.Rao_at_Sungardp3.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------