oracle10g 配置

来源：互联网发布：葫芦侠找不到游戏数据编辑：程序博客网时间：2024/05/10 08:40

刚上线一套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');