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

From Wiki_dbSQWare
Revision as of 22:30, 24 May 2011 by BatchUser (talk | contribs) (Updated by BatchUser)
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Init_112.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
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


Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareProduction:oracle:etc:sqwora_CreDb_Init_112.cfg&oldid=2025"