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 |
Place the 2 members of each group in separate file systems built on different disk arrays |
set the redo log file configuration |