From rabbit@emirates.net.ae Sun, 03 Jun 2001 23:04:47 -0700
From: Sam Roberts <rabbit@emirates.net.ae>
Date: Sun, 03 Jun 2001 23:04:47 -0700
Subject: Re: Which SQL is executing
Message-ID: <F001.00319C8A.20010603230028@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



SELECT T.SQL_TEXT FROM V$SQLTEXT T,V$SESSION S  
WHERE  S.SQL_ADDRESS=T.ADDRESS ORDER BY T.PIECE;
 
Sam
<BLOCKQUOTE 
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
  ----- Original Message ----- 
  <DIV 
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: 
  Chuan 
  Zhang 
  To: <A href="mailto:ORACLE-L@fatcity.com" 
  title=ORACLE-L@fatcity.com>Multiple recipients of list ORACLE-L 
  Sent: Monday, June 04, 2001 9:30 AM
  Subject: Which SQL is executing
  
  Hi All,
   
   
  From v$open_cursor, I know every SQL  opened 
  and parsed in one session. Is there any way to know which SQL is running. Or 
  put another way, can all the SQLs in one session be sorted in timing 
  order dynamically?
   
  Any clue would be much appreciated.
   
  Chuan