Was poking TFO to find way to collect SQL a particular user had run in database
today and along the way found StatPack Browser and earmarked it for a later
TFO Help tells me how to use the StatsPack Browser and the KB gave me a bit more
info (sort of) but still wasn’t sure about StatsPack so I went to my
O’Reilly Safari and found this:
“A Statspack report is generated from two snapshots of the database. These
snapshots are a copy of the contents of the various dynamic performance tables
that are continuously accumulating information about activity in the database.
Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor
(ADDM) were offered as replacements for Statspack beginning with Oracle Database
10g and are no longer documented in the Oracle manuals. However, you can use AWR
and ADDM only with Enterprise Edition and only if you have a license for
Diagnostics Pack—an extra-cost option available only with Enterprise
Edition. In my experiences, very few organizations have the requisite licenses.
I therefore emphasize the use of Statspack and use it a lot in my own work. Note
that Oracle did make several incremental enhancements to Statspack in Oracle
Database 10g and 11g , thus further increasing its usefulness and relevance.
However, you will have to refer to Chapter 21 of Oracle Database 9i Performance
Tuning Guide and Reference for documentation on Statspack because it is not
documented in the Oracle Database 10g and 11g manuals. A useful introduction to
Statspack as well as installation instructions can be found in spdoc.txt in the
ORACLE_HOME\rdbms\admin folder. “ Beginning Oracle Database 11g
Administration: From Novice to Professional by Iggy Fernandez.
I’d really like to have the last couple of sentences of the quote (or
similar info) stored in KB somewhere so I don’t lose it and can know where
to go when wondering about StatPack again.
Deborah M Flad, DBA
Delaware Children’s Department, State of Delaware
1825 Faulkland Rd, Wilmington DE 19805
Office: 302.633.2694 email@example.com Emergencies: 302.528.3652 Txt:
Our website: www.kids.delaware.gov
How am I doing? Email my manager Eugene Mitchell at Eugene.Mitchell@state.de.us
with any feedback.
“Please consider your environmental responsibility before printing this e-mail”
Confidentiality Notice – This electronic mail transmission and any
attachment(s) are privileged and confidential and are intended only for the
review of the party to whom it is addressed. If you have received this
transmission in error, please immediately notify the sender and delete the
unintended message received. Unintended transmission shall not constitute waiver
of work product or any other privilege.