RE: Looking for SQL that already ageout from SQL AREA

  • From: "Joze Senegacnik" <Joze.Senegacnik@xxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 3 Jan 2005 13:06:03 +0100

In 10g information is stored in the DBA_HIST_SQLTEXT that displays the =
text of SQL statements belonging to shared SQL cursors captured in the =
Workload Repository. This view captures information from V$SQL and is =
used with the DBA_HIST_SQLSTAT view.
But there is no such feature available in versions prior 10g.

Regards, Joze

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Oracle
Sent: Sunday, January 02, 2005 6:33 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Looking for SQL that already ageout from SQL AREA


Hi all,

Can we find out the SQL command that issued by user, after the SQL =
command
already age out from the buffer?

Thanks

Sinardy





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

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

Other related posts: