刚上线一套oracle10.2.0.3,装好后简单做了如下一些配置:
1.AUTO_SPACE_ADVISOR_JOB作业: It runs the Automatic Segment Advisor, which identifies segments that have space available for reclamation, and then makes recommendations that you can view with Enterprise Manager or a set of PL/SQL package procedures. This job was introduced in 10gR2 and is not present in 10gR1。
2.execute_em_dbms_job_procs作业 这具job每分钟执行一次,里面包括 EMD_COLLECTION.RUN_COLLECTIONS(),EM_PING.MARK_NODE_STATUS();, EM_SEVERITY_REPOS.EXECUTE_REPOS_SEVERITY_EVAL();, EMD_LOADER.ROLLUP();,EM_PURGE.APPLY_PURGE_POLICIES();等 它的作用就是自动收集oem里面的一些信息,停掉这个JOB后,oem页面将无法自动刷新,需要手工去刷新。 角本可在$ORACLE_HOME/sysman/admin/emdrep/sql/core/latest/admin目录下面发现。
3.alter tablespace undotbs1 retention guarantee; alter system set db_recovery_file_dest='/oracle_backup'; alter system set db_recovery_file_dest_size=10g; exec dbms_scheduler.disable('AUTO_SPACE_ADVISOR_JOB'); exec dbms_scheduler.disable('GATHER_STATS_JOB');