Database Settings

S.No Settings Description
1 N/A Run Strip Utility immediately after importing a new database.
2 N/A Import/ Export should prefix today's date to log to import or export files.
3 DBMS_STATS.GATHER_TABLE_STATS ('ASADMIN', 'ASCYCLE', cascade=>true, degree => 32); The table statistics can be included in all the cycle related procedures which populate the CYCLE tables. The below has been added to the 'ASC_POPULATEPOLICYCCYLE' procedure.
4 select 'ALTER SEQUENCE '||sequence_name||' CACHE 10000;' from all_sequences where sequence_owner='ASADMIN'; SEQUENCE Cache, Consider setting CACHE to 10000 for all oracle sequences. Use the given sql statement to generate the ddl for altering sequence cache.
5 alter system set cursor_sharing='FORCE' scope=spfile; Cursors do not seem to be reused well. Change cursor_sharing to FORCE. The cursor_sharing was set to ‘SIMILAR’ which is deprecated in Oracle 11.2G
6 alter system set Processes='4000' scope=spfile;

Set the processes

Note: These parameters might depend on the load execution and weblogic connection settings

7 alter system set open_cursors='30000' scope=spfile;

Set the open_cursors

Note: These parameters might depend on the load execution

8 alter system set session_cached_cursors='3000' scope=spfile;

Set session_cached_cursors

Note: These parameters might depend on the load execution

9 alter system set memory_target='8G' scope=spfile;

set memory target

Note: These parameters might depend on the load execution

10 alter system set shared_pool_size='1G' scope=spfile;

Set shared_pool_size

Note: These parameters might depend on the load execution

11
  • Redo Log file configuration should be Groups -3
  • Members in each group -2
  • Size of Each Member - 2GB

Place the 2 members of each group in separate file systems built on different disk arrays

set the redo log file configuration

 

 

 

 

 

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. About Oracle Insurance | Contact Us