domingo, 8 de marzo de 2009

Ejemplo de INIT.ora 11g


############################################################
#             INITMyBd.ORA                                 #
############################################################

MyBd.__java_pool_size=67108864
MyBd.__large_pool_size=16777216
MyBd.__oracle_base='/ruta/software/oracle_base/'#ORACLE_BASE set from environment
MyBd.__pga_aggregate_target=1493172224
MyBd.__sga_target=2801795072
MyBd.__shared_io_pool_size=0
MyBd.__shared_pool_size=553648128
MyBd.__streams_pool_size=0
*.audit_file_dest='/ruta/destino/audit/'
*.audit_trail='DB'
*.compatible='11.1.0'
*.control_files='/ruta/control/control01.ctl','/ruta/control/control02.ctl','/ruta/control/control03.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='MyBd'
*.db_recovery_file_dest_size=1G
*.db_recovery_file_dest=' '
*.diagnostic_dest='/ruta/directorio/trazas'
*.dispatchers='(PROTOCOL=TCP)'
*.fast_start_mttr_target=20
*.log_archive_dest='/ruta/archivado'
*.log_archive_format='MyBd%t_%s_%r.arc'
*.memory_max_target=4294967296
*.memory_target=4294967296
*.open_cursors=500
*.processes=750
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_servers=0
*.undo_retention=900
*.undo_tablespace='UNDOTBS1'

No hay comentarios: