Wednesday, October 14, 2009

Oracle license: Diagnostics Pack and Tuning Pack

How it affects your Oracle Enterprise Manager database Control?

Diagnostics Pack:

If you disable access to diagnostics pack, following features are disabled:
Performance (tab)
ADDM (Advisor Central)

Tuning Pack: (requires Diagnostics Pack)

If you disable access to tuning pack, following features are disabled:
SQL Access Advisor (Advisor Central)
SQL Tuning Advisor (Advisor Central)

Following features do not require any Oracle license:

Segment Advisor (Advisor Central)
MTTR Advisor (Advisor Central)
Memory Advisor (Advisor Central)
Undo Management (Advisor Central)