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

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

****************I am authoring a Book on Oracle Database Cloud Services.......More details to follow.***************

Title : Oracle Database Cloud Revealed
Publisher : Apress
Release Date : Jan-2019

**********************************************************************************


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]


My Cloud Certifications:

AWS Certified Solutions Architect Associate

Oracle Cloud Infrastructure 2018 Certified Architect Associate.

Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.

Oracle Database Cloud Administrator Certified Professional.

Oracle Database Cloud Service Operations Certified Associate.

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: