Embedded Files
The Tuning Pack is a cost option for Oracle Enterprise Edition. It is often used in conjunction with the Diagnostics Pack.
Features
Features
- SQL Access Advisor
- SQL Tuning Advisor
- Oracle Database In-Memory Advisor
- Automatic SQL Tuning
- SQL Profiles
- Real-time SQL and PL/SQL Monitoring
- Real-time Database Operations Monitoring
- Reorganize objects
PackagesDBMS_ADVISOR (with exceptions)DBMS_SQLTUNE (with exceptions)ViewsV$SQL_MONITORV$SQL_PLAN_MONITORScriptssqltrpt.sql
Parameters
Parameters
CONTROL_MANAGEMENT_PACK_ACCESS
CONTROL_MANAGEMENT_PACK_ACCESS
To use the Diagnostics Pack the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter must be set to DIAGNOSTIC or DIAGNOSTIC+TUNING.
Page updated
Google Sites
Report abuse