Top SQL from statspack

Giganews Newsgroups
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
Rick Denoire

Replies