RE: v$session_wait event

From: Robertson Lee - lerobe <lerobe_at_acxiom.co.uk>
Date: Fri, 09 Nov 2001 08:29:36 -0800
Message-ID: <F001.003C0ED8.20011109080524@fatcity.com>

Ignore
this please. Another red herring. I give up. <SPAN
class=000260516-09112001> 
I'm
off to the countryside to grow mushrooms organically <SPAN
class=000260516-09112001> 

<FONT face=Tahoma

  size=2>-----Original Message-----From: Robertson Lee - lerobe   [mailto:lerobe_at_acxiom.co.uk]Sent: 09 November 2001   12:00To: Multiple recipients of list ORACLE-LSubject:   v$session_wait event
  Anyone any idea
  what I am waiting for here. I know it seems obvious but I don;t know   exactly what it means. Anyone who knows about such things care to enlighten me   on where to dig next. This has been sitting like this for 2 days and I believe   it maybe at the root of the long running SQL problem I have had here. What do   I know? ??.
<SPAN

  class=265242511-09112001> 
   1  select event, sql_text, s.sid,
  serial#, s.last_call_et, wait_time, seconds_in_wait, state  2    from v$session s,v$session_wait w, v$sqlarea sa  3  where   s.sql_address = sa.address  4  and s.sql_hash_value =

  sa.hash_value  5  and w.sid = s.sid  6  
  and   w.event != 'Null event' and  7   w 
  .event != 'rdbms ipc message' and  8    w.event != 

  'pipe get' and  9    w.event != 'virtual circuit   status' and 10    w.event not like '%timer%'   and 11    w.event not like 'SQL*Net message   %' 12  and s.audsid != 0 13  and s.sid =   12 14* order by last_call_etSQL> /
   
<FONT face=Courier

  size=2>EVENT----------------------------------------------------------------SQL_TEXT----------------------------------------------------------------------------------------------------       

  SID    SERIAL# LAST_CALL_ET  WAIT_TIME SECONDS_IN_WAITS   TATE---------- ---------- ------------ ---------- ---------------

  -------------------SQL*Net more data from clientsavepoint 

  begin_row       

  12       
  9001            
  0          
  0               

  0 WAITING
<FONT face=Courier

  size=2> 
<FONT face=Courier

  size=2> 
<SPAN

  class=265242511-09112001>Regards
<SPAN

  class=265242511-09112001> 
<SPAN

  class=265242511-09112001>Lee <FONT
  size=3>The information contained in this communication   isconfidential, is intended only for the use of the recipientnamed   above, and may be legally privileged. If the reader of this message is not   the intended recipient, you arehereby notified that any dissemination,   distribution orcopying of this communication is strictly prohibited.   If you have received this communication in error, please re-send this   communication to the sender and delete the original message or any copy of   it from your computersystem. Received on Fri Nov 09 2001 - 10:29:36 CST