Question
I want to use AWR and I need to see of the
diagnostic pack and tuning acks are installed.
Answer.
Regardless of license fees, enterprise editions of Oracle
will have the AWR tables installed. You can check to
see of the diagnostic pack and tuning pack are installed via
this SQL*Plus command:
SQL> show
parameter control_management
NAME
TYPE VALUE
------------------------------------
----------- -------------------------
control_management_pack_access
string DIAGNOSTIC+TUNING
As we see, the variable
control_management_pack_access has the value column
that indicates the acks that are installed. Note that
this does not necessarily indicate that the packs have been
properly licensed. The control_management_pack_access
parameter is set to DIAGNOSTIC+TUNING by default
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
