Re: Looking for SQL that already ageout from SQL AREA

And that will only be true for DML. Select statements are not in the redo log.
The only way that you could see those is if SQL_TRACE was turned on. -Mark

On Sun, 2005-01-02 at 12:46, David Sharples wrote:

> log miner
> On Mon, 3 Jan 2005 01:32:40 +0800, Oracle <all_about_oracle_at_hotpop.com> wrote:
> > Hi all,
> > Can we find out the SQL command that issued by user, after the SQL command
> > already age out from the buffer?

--
Mark J. Bobak
mark_at_bobak.net
"Science is the belief in the ignorance of experts."  --Richard P.
Feynman


--
http://www.freelists.org/webpage/oracle-l