OCM_Session1_1_Database Setup and Undo Management
TIMES: 45 minutes1. Database Setup and Undo Management 1.1 Run the minimum required scripts to complete the basic configuration of the PROD database.1.2 Set up automatic undo management in the PROD database to support the following requirements:1.2.1 Avoid ORA-01555 Snapshot too old errors for queries running up to 90 minues on average.1.2.2 The number or concurrent OLTP users will be approximately 120 during normal business hours.1.2.3 The number or concurrent batch processes that will run in the evenings and weekends will approximately 12 to 15
[*]7.跑脚本，跑catalog和catporc这两个脚本
[*]1.1 Run the minimum required scripts to complete the basic configuration of the PROD database.
SQL> @$ORACLE_HOME/rdbms/admin/catalog.sqlSQL> @$ORACLE_HOME/rdbms/admin/catproc.sql
PL/SQL procedure successfully completed.
SQL> select open_mode from v$database;
OPEN_MODE----------READ WRITE
1 row selected.
[*] 1.2.1 Avoid ORA-01555 Snapshot too old errors for queries running up to 90 minues on average.
SQL> alter system set undo_retention=5400;
System altered.
[*] 1.2.2 The number or concurrent OLTP users will be approximately 120 during normal business hours.
SQL> alter system set processes=135 scope=spfile;
System altered.
[*]1.2.3 The number or concurrent batch processes that will run in the evenings and weekends will approximately 12 to 15
SQL> alter system set job_queue_processes=15;
System altered.
SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.
Total System Global Area524288000 bytesFixed Size 1220360 bytesVariable Size 150995192 bytesDatabase Buffers 369098752 bytesRedo Buffers 2973696 bytesDatabase mounted.Database opened.SQL> 版权声明：本文为博主原创文章，未经博主允许不得转载。
页:
[1]