And how would I interpret the output of this query?
Thanks Arun
Raj
______________________________________________________
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!
-----Original Message-----
Sent: Tuesday, March 12, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L
If you are able to login and query the session_Wait
try using the below said query
select s.INDX
SID,u.KSUUDNAM||','||u.KSUSEUNM||','||u.KSUSEMNM||'('||decode(KSUSSOPC,2,'LA
TCH FREE',12,'ENQUEUE',94,'db file sequential read',
95,'db file scattered read',144,'LIBRARY CACHE PIN',75,'buffer busy waits',
145,'library cache lock',146,'library cache load lock',91,'log file
sync',KSUSSOPC)||')' EVENT_WITH_OSUSER,
KSUSSP1R "P1RAW",KSUSSP1,KSUSSP2 P2,KSUSSP3 FROM X$KSUSECST s,x$ksuse u
WHERE KSUSSOPC IN(2,12,94,95,144,75,145,146,91) and
bitand(s.ksspaflg,1)!=0 and bitand(s.ksuseflg,1)!=0 and s.ksussseq!=0
and u.indx=s.indx
*********************************************************************2
This e-mail message is confidential, intended only for the named recipient(s) above
and may contain information that is privileged, attorney work product or exempt from
disclosure under applicable law. If you have received this message in error, or are
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000
and delete this e-mail message from your computer, Thank you.
*********************************************************************2
