oracle10基本配置,oracle10G配置的修改

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