It's a beautiful query which only misses "FROM" clause. I'll save it for later use. Much later.
> -----Original Message----- > From: Arun Chakrapani [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 12, 2002 10:14 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: DB freezes ... no indications of any kind > > > 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 > > > > > > > -----Original Message----- > Sent: Tuesday, March 12, 2002 9:19 AM > To: Multiple recipients of list ORACLE-L > > > 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! > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Arun Chakrapani > 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: Gogala, Mladen 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).
