IT/SAP

To do for After Installed Oracle 10g

SAP_BASIS 2011. 12. 24. 13:48

1.
Execute the following commands as the ora<dbsid> user:
brconnect -u / -c -f stats -t system_stats;
brconnect -u / -c -f stats -t oradict_stats;

2.
Execute the following commands with SQLPlus:
SQL> exec dbms_scheduler.disable('GATHER_STATS_JOB');
SQL> exec dbms_scheduler.disable('ORACLE_OCM.MGMT_CONFIG_JOB');
SQL> exec dbms_scheduler.disable('ORACLE_OCM.MGMT_STATS_CONFIG_JOB');
For Oracle 11g, also execute the following command:
SQL> exec DBMS_AUTO_TASK_ADMIN.DISABLE
For more information, see SAP Note 974781.