Gunther Oracle APEX und Datenbank Wiki

-- prüfen 
SQL>SHOW parameter control_management_pack_access
 
NAME                                 TYPE                              VALUE
------------------------------------ --------------------------------- -------------------------
control_management_pack_access       string                            DIAGNOSTIC+TUNING
 
 
-- Verwendung untersagen:
ALTER system SET control_management_pack_access='NONE' scope=BOTH sid='*';

Pack Übersicht:

12c

• https://docs.oracle.com/database/121/DBLIC/options.htm#DBLIC165

11g

• http://docs.oracle.com/cd/E11882_01/license.112/e47877/options.htm#DBLIC159

Prüfen, ob ein AWR Report in der DB verwendet wurde:

COLUMN name format a15
COLUMN detected_usages format 9999
 
SELECT name
     , detected_usages
     , currently_used
     , TO_CHAR(last_sample_date,'dd.mm.yyyy hh2:mi') last_check
FROM dba_feature_usage_statistics
WHERE  name = 'AWR Report' ;
 
NAME            DETECTED_USAGES CURRENTLY_USED  LAST_SAMPLE
--------------- --------------- --------------- ---------------------
AWR Report                    1 FALSE           17-NOV-2014:09:00

Für die Lizenzbedingungen beim Einsatz vom AWR siehe:

• AWR Reporting - Licensing Requirements Clarification (Doc ID 1490798.1)