Re: Top SQL from statspack

From: Norman Dunbar <Norman_at_REMOVETHIS.Dunbar-IT.co.uk>
Date: Tue, 21 Dec 2004 10:34:54 +0000
Message-ID: <41c7fc4b$1_4@mk-nntp-2.news.uk.tiscali.com>

Rick Denoire wrote:
> 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
>

Hi Rick,

run the Statspack snapshot at level 6.

Run the SPREPORT script to get the top SQL stuff as normal, note the hash value.

Run the SPREPSQL and give it the hash it wants.

Cheers,
Norm. Received on Tue Dec 21 2004 - 04:34:54 CST