SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Statspack Tables

jaggyamSep 13 2010 — edited Sep 13 2010

Hi All,

How to identify whether STATSPACK is configured or not in 8x DB (thru an SQL)?

We use the following tables for the purpose mentioned next to it in 9x.
stats$snapshot -- Snapshot Details
stats$sql_summary - Statistics of SQL executed during a snap
stats$sqltext - SQL text executed
sTAtS$SYSTEM_EVENT - System events during a snap
STATS$FILESTATXS - I/O Stats during a snap

But what are equivalent tables from where we can find the similar information in 8x?

Thanks in Advance,
Jaggyam

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 11 2010

Added on Sep 13 2010

2 comments

753 views