# Ahbaid Gaffoor
# mydbname: dbcreate.ora
# Generic, adjust per db

# {{{ DB
db_name='mydbname'
db_domain='mydomain.com'
compatible='10.2.0.4.0'
db_block_size=2048
db_file_multiblock_read_count=16
control_files='/dbh/mydbname/ctl1/control01.ctl','/dbh/mydbname/ctl2/control02.ctl'
# }}}

# {{{ Dataguard configuration
#
# If the ifile is used for Dataguard, comment out the log_archive_dest paramaeter
# and vice versa.
#
#ifile=/orah/oracle/admin/mydbname/pfile/mydbname-dg.ora
log_archive_dest=/dbh/mydbname/arch
# }}}

# {{{ Redo / Archive 
log_archive_format='mydbname-%t_%s_%r.arc'
log_buffer=32
# These redo settings are for Demo use, they encourage more redo log activity 
# and are perfect for a Dataguard demo.
log_checkpoint_interval=1
log_checkpoint_timeout=5
log_archive_max_processes=2
# }}}

# {{{ Pools
sga_target=300M
db_cache_size=150M
java_pool_size=5M
large_pool_size=5M
shared_pool_size=60M
streams_pool_size=0
pga_aggregate_target=70M
# }}}

# {{{ Process Management
job_queue_processes=10
processes=150
open_cursors=300
# }}}

# {{{ File destinations
audit_file_dest='/orah/oracle/admin/mydbname/adump'
background_dump_dest='/orah/oracle/admin/mydbname/bdump'
user_dump_dest='/orah/oracle/admin/mydbname/udump'
core_dump_dest='/orah/oracle/admin/mydbname/cdump'
# }}}

# {{{ Flash Recovery Area
#db_recovery_file_dest='/dbh/mydbname/flash/'
#db_recovery_file_dest_size=2g
# }}}

# {{{ Undo 
undo_management='AUTO'
undo_tablespace='UNDO_TS'
# }}}

# {{{ Security / Audit
remote_login_passwordfile='EXCLUSIVE'
# }}}