Re: Which SQL is executing

[Sam Roberts]

SELECT T.SQL_TEXT FROM V$SQLTEXT T,V$SESSION S  WHERE  S.SQL_ADDRESS=T.ADDRESS ORDER BY T.PIECE;   Sam ----- Original Message ----- From: Chuan Zhang To: 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