|Subject:||Top SQL from statspack|
|Posted by:||Rick Denoire (100.177…@germanynet.de)|
|Date:||Mon, 20 Dec 2004|
How do I get the full length text of top SQL queries from the
statspack schema (oraperf)? The instance has been recycled recently so
I won't find them in the V$SQLAREA or V$SQLTEXT anymore.
I would like to compile a script containing these queries as a kind of
benchmark. It would be nice to run a query to pull all these
statements from the statspack data into a spool file.
Thanks a lot