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

From Wiki_dbSQWare
Revision as of 00:27, 16 December 2010 by Exploit (talk | contribs) (Updated by Expdbtools)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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
Note:
You can replace file $gvsqw_OraBin/../etc/sqwora_CreDb_Init_112.cfg

by $gvsqw_OraBin/../etc_cust/sqwora_CreDb_Init_112.cfg for all your environnement
or by $HOME/edtConfig/sqwora_CreDb_Init_112.cfg specifically for this user..


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