Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Monday, September 12, 2011

Oracle post db creation steps

-- Disable 10g/11g Automatic stats.
execute dbms_scheduler.disable('GATHER_STATS_JOB');

-- Configure AWR Retention Settings (30days/15 min for PROD, 15day/30 min for QA)
-- For Production, the SQL is
execute dbms_workload_repository.modify_snapshot_settings(interval => 15, retention => 43200);
-- QA
-- execute dbms_workload_repository.modify_snapshot_settings(interval => 30, retention => 21600);

-- Enable Block change Tracking as needed
alter database enable block change tracking ;

--
-- dbsnmp user
alter user dbsnmp identified by ;
alter user dbsnmp account unlock ;

-- other modifications << Modify the values before execution >>>
--
alter system set recyclebin=OFF scope=spfile sid='*' ;
alter system set db_file_multiblock_read_count=0 scope=spfile sid='*' ;
-- alter system set processes=1500 scope=spfile sid='*' ;
-- alter system set shared_pool_size=2000G scope=spfile sid='*' ;
-- alter system set db_cache_size=1500M scope=spfile sid='*' sid='*' ;
-- alter system set sga_target=0 scope=spfile sid='*' ;
-- alter system set large_pool_size=50M scope=spfile sid='*' ;
-- alter system set java_pool_size=50M scope=spfile sid='*' ;
alter system set parallel_execution_message_size=16384 scope=spfile sid='*' ;
-- alter system set instance_groups= scope=spfile sid='*' ;
-- alter system set parallel_instance_group= scope=spfile sid='*' sid='*' ;
alter system set local_listener=DBISPCDP scope=spfile sid='*' ;
alter system set remote_listener=DBISPCDP scope=spfile sid='*' ;
alter system set db_recovery_file_dest_size=100G scope=spfile sid='*' ;
-- alter system set db_recovery_file_dest=<< >> scope=spfile sid='*' ;
alter system set log_archive_dest_1='LOCATION=use_db_recovery_file_dest' scope=spfile sid='*' ;
alter system set undo_retention=3600 scope=spfile sid='*' ;

No comments: