RE: Looking for SQL that already ageout from SQL AREA

From: Joze Senegacnik <Joze.Senegacnik_at_snt.si>
Date: Mon, 3 Jan 2005 13:06:03 +0100
Message-ID: <4A18399C13358544BB9A383EA097749E144E68@simail01.adriatic.snt.eu>

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_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Oracle Sent: Sunday, January 02, 2005 6:33 PM
To: oracle-l_at_freelists.org
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

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jan 03 2005 - 06:01:00 CST