Ok.. it's a sort segment latch.. any way to find out why? It's been sitting around for over an hour ...
On Sat, 08 Dec 2001 14:35:18 -0800, you wrote: >oops, probably only want the events that are latch frees: > >select ln.name from v$session_wait sw, v$latchname ln where sw.p2 = >ln.latch# and sw.event = 'latch free'; > >On Saturday, December 8, 2001, at 04:50 PM, George Schlossnagle wrote: > >> Try: >> >> select ln.name from v$session_wait sw, v$latchname ln where sw.p2 = >> ln.latch#. >> >> Best, >> >> George >> >> www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN >> Smarter than adding another team member, Pythian has new services for >> supplementing DBAs: get our help with monitoring, 24x7 on-call, daily >> verifications, storage management, performance and more. >> >> >> On Saturday, December 8, 2001, at 04:05 PM, Doug C wrote: >> >>> I have a session that seems to be hung on a sql_statment. >>> >>> Here is it's session_wait entry: >>> >>> SID SEQ# >>> ---------- ---------- >>> EVENT >>> ---------------------------------------------------------------- >>> P1TEXT >>> P1 >>> ---------------------------------------------------------------- >>> ---------- >>> P1RAW P2TEXT >>> -------- >>> ---------------------------------------------------------------- >>> P2 P2RAW >>> ---------- -------- >>> P3TEXT >>> P3 >>> ---------------------------------------------------------------- >>> ---------- >>> P3RAW WAIT_TIME SECONDS_IN_WAIT STATE >>> -------- ---------- --------------- ------------------- >>> 62 1239 >>> latch free >>> address >>> 805352248 >>> 3000B338 number >>> 88 00000058 >>> tries >>> 923 >>> 0000039B 0 0 WAITING >>> >>> >>> The seq# goes up from time to time. >>> My question is how to determine what kind of latch is bothering it? >>> Does P2 (88) indicate what type of latch? Can I join with some other >>> table to >>> find out what 88 is? >>> >>> Thanks, >>> D >>> -- >>> Please see the official ORACLE-L FAQ: http://www.orafaq.com >>> -- >>> Author: Doug C >>> 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: George Schlossnagle >> 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: Doug C 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).