SQWareProduction:oracle:etc:sqwora CreDb Init 122.cfg

From Wiki_dbSQWare
Jump to: navigation, search

Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Init_122.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
log_buffer = 1024000
audit_file_dest=<gvsqw_RootAdmin>/adump
diagnostic_dest=<gvsqw_RootAdmin>/ddump
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
deferred_segment_creation=false