Re: Which SQL is executing

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_at_fatcity.com" title=ORACLE-L_at_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 Received on Mon Jun 04 2001 - 01:04:47 CDT