Monthly Archives: May 2014

Diag and Tuning Pack: disable

Disable Diag and Tuning pack (oracle 10g and 11g) – Baselines must not be used: 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 must not be … Continue reading

Posted in Uncategorized | Leave a comment

SMON rollback/transaction recovery disable, drop object

monitor recovery: select * from V$FAST_START_TRANSACTIONS; disable, drop, enable: alter system set “_smu_debug_mode”=1024 ; bounce db (?) drop table … remove “_smu_debug_mode” bounce db Recovery still going on. Trying event: event=”10513 trace name context forever, level 2″ event=”10061 trace name … Continue reading

Posted in Uncategorized | Leave a comment