Oracle Tuning Pack

The Tuning Pack is a cost option for Oracle Enterprise Edition. It is often used in conjunction with the Diagnostics Pack.

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

CONTROL_MANAGEMENT_PACK_ACCESS

To use the Diagnostics Pack the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter must be set to DIAGNOSTIC or DIAGNOSTIC+TUNING.