Re: Which SQL is executing

Hi, Sam,
 
 Thanks for your information.
 

To my understanding, the script you gave is for all the queries. There is still no way to figure out which query is running.
 

Chuan,
<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: Sam Roberts 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 5:00 PM Subject: 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.

     
    <FONT face=Arial
size=2>Chuan Received on Wed Jun 06 2001 - 01:32:28 CDT