Difference between revisions of "SQWareProduction:oracle:etc:sqwora CreDb Init 111.cfg"
m (Updated by Expdbtools) |
m (Updated by BatchUser) |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 46: | Line 46: | ||
fast_start_mttr_target=900 | fast_start_mttr_target=900 | ||
</pre> | </pre> | ||
| − | |||
<br> | <br> | ||
Latest revision as of 20:21, 16 June 2014
Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Init_111.cfg:
File content:
db_name = <ORACLE_SID>
instance_name = <ORACLE_SID>
control_files = (<gvsqw_RootDbf>/base1/control01.ctl,
<gvsqw_RootDbf>/base2/control02.ctl)
db_block_size = 8192
db_file_multiblock_read_count = 8
log_buffer = 1024000
audit_file_dest=<gvsqw_RootAdmin>/adump
diagnostic_dest=<gvsqw_RootAdmin>/ddump
core_dump_dest=<gvsqw_RootAdmin>/cdump
log_archive_dest_1 = 'LOCATION=<gvsqw_RootArch> MANDATORY'
log_archive_format = "<ORACLE_SID>_redo_%t_%s_%r.arc"
#SGA
#sga_target=512M don't work for big instance
db_cache_size=512M
shared_pool_size=256M
java_pool_size=64M
large_pool_size=64M
#PGA
pga_aggregate_target=256M
# regional
NLS_DATE_FORMAT='dd/mm/yyyy'
processes = 400
open_cursors = 512
compatible='<gvsqw_OraVersionCpt>'
instance_type='RDBMS'
max_dump_file_size='10M'
session_cached_cursors=20
shadow_core_dump='partial'
timed_statistics=true
undo_management='auto'
undo_retention=3600
undo_tablespace='UNDO'
workarea_size_policy='auto'
fast_start_mttr_target=900
