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
[EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
