RE: Which SQL is executing

Wed, 06 Jun 2001 00:57:29 -0700

Hi Chuan,
 
    Still your question is not clear to me. But I am
sending you some scripts, may be these would help you:
 
This gives SQL-TEXT, Oracle-User-name, machine-name
and program-name for the user executing the SQLs.
 
set pagesize 50
set head on
set linesize 70
 
select sa.sql_text,s.username,s.machine,s.program
 from v$sqlarea sa,v$session s
 where s.sql_address=sa.address
 and s.sql_hash_value=sa.hash_value
 order by sa.buffer_gets desc
/
 
This will give all SQLs currently executing including
this one.
 
SELECT u.sid, SUBSTR(u.username,1,12) user_name, s.sql_text
FROM v$sql s, v$session u
WHERE s.hash_value = u.sql_hash_value
ORDER BY user_name
/
HTH,
Rajesh
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Chuan Zhang
Sent: Wednesday, June 06, 2001 11:25 AM
To: Multiple recipients of list ORACLE-L
Subject: 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,
----- Original Message -----
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
----- Original Message -----
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

Reply via email to