Diag and Tuning Pack: disable the beast

11g and 10g changes:

– Baselines:
begin
for m in (select * from dba_hist_baseline where baseline_name != ‘SYSTEM_MOVING_WINDOW’) loop
sys.dbms_workload_repository.drop_baseline(baseline_name=>m.baseline_name,cascade=>true);
end loop;
end ;
/

– Manual Snapshots:
begin
for m in (select * from dba_hist_snapshot where snap_flag0) loop
sys.dbms_workload_repository.drop_snapshot_range(low_snap_id=>m.snap_id,high_snap_id=>m.snap_id);
end loop;
end ;
/

– awr disable
begin sys.dbms_awr.disable_awr(); end;
/

– Advisor cleaning: (that rude thing was done for many reasons, licensing beeing one of them – you decide if you need to go to such lengths)

truncate table sys.WRI$_ADV_OBJECTS;
truncate table sys.WRI$_ADV_MESSAGE_GROUPS;
truncate table sys.WRI$_ADV_ACTIONS;
truncate table sys.WRI$_ADV_PARAMETERS;
truncate table sys.WRI$_ADV_RATIONALE;
truncate table sys.WRI$_ADV_RECOMMENDATIONS;
truncate table sys.WRI$_ADV_FINDINGS;
truncate table sys.WRI$_ADV_REC_ACTIONS;
truncate table sys.WRI$_ADV_TASKS;
truncate table sys.wri$_adv_usage ;

– 11g: tuning schedulers disabled. That should be optional as far as licenses are concerned but there are many reasons to get rid of them.

– OEM (Cloud Control, formerly Grid Control, formerly OEM): disable Packs in Grid Control interface, menu on the top-right corner.

Next: mapping between licensed features and dba_feature_usage_statistics is known – see metalink id: Database Options/Management Packs Usage Reporting for Oracle Database 11g Release 2 (Doc ID 1317265.1)

Then one can do this:

1) map features to dba_feature_usage_statistics and sys.wri$_dbu_feature_metadata

2) sys.wri$_dbu_feature_metadata describes how oracle checks for feature usage

3) the feature is disabled based on analysis of sys.wri$_dbu_feature_metadata

4) Mos article “MMON Suspended Due to ORA-12751 “cpu time or run time policy violation” (Doc ID 761298.1)” is used to execute oracle FUS immediately:
alter session set events ‘immediate trace name mmon_test level 6’;

5) repeat from step 2 untill dba_feature_usage_statistics is satisfactory

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s