From Rajesh@ohitelecom.com Wed, 06 Jun 2001 00:57:29 -0700 From: Rajesh Dayal Date: Wed, 06 Jun 2001 00:57:29 -0700 Subject: RE: Which SQL is executing Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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_textFROM v$sql s, v$session uWHERE s.hash_value = u.sql_hash_valueORDER BY user_name/ HTH, Rajesh -----Original Message-----From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Chuan ZhangSent: Wednesday, June 06, 2001 11:25 AMTo: Multiple recipients of list ORACLE-LSubject: 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 -----