Re: Finding out latest SQL

From: srivenu <srivenu_at_hotmail.com>
Date: 31 Jul 2002 22:49:13 -0700
Message-ID: <1a68177.0207312149.3cc953ec@posting.google.com>

i had written this SQL script for my use. Try this

col sid form 999

col curr form a40 head "     Current SQL"
col prev form a40 head "     Previous SQL"

bre on sid skip 2
select a.sid sid,max(b.sql_text) curr,max(c.sql_text) prev from v$session a, v$sql b,v$sql c
where a.sql_address=b.address
and a.prev_sql_addr=c.address
group by sid
/
cle bre Received on Thu Aug 01 2002 - 00:49:13 CDT