Re: Looking for SQL that already ageout from SQL AREA

  • From: "Mark J. Bobak" <mark@xxxxxxxxx>
  • To: davidsharples@xxxxxxxxx
  • Date: Sun, 02 Jan 2005 13:47:19 -0500

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@xxxxxxxxxx> 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@xxxxxxxxx
"Science is the belief in the ignorance of experts."  --Richard P.
Feynman


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

Other related posts: