what do you think, both of them the script and the init ora are for 9i
standard edition
DB_BLOCK_SIZE = 8192
COMPATIBLE = 9.2.0.1.0
DB_NAME = XXX
INSTANCE_NAME = XXX
REMOTE_LOGIN_PASSWORDFILE = SHARED
CURSOR_SPACE_FOR_TIME = FALSE # NO ELIMINA CURSORES EN SESION, No
Habilitar en Developer
#O7_DICTIONARY_ACCESSIBILITY=TRUE
###########################################
# CACHE AND I/O
###########################################
DB_CACHE_SIZE = 60M
DB_KEEP_CACHE_SIZE = 25M
DB_RECYCLE_CACHE_SIZE = 10M
DB_FILE_MULTIBLOCK_READ_COUNT = 16
# DB_CACHE_ADVICE = ON/READY/OFF # HABILITAR PARA OBTENER ESTADÍSTICAS DEL
USO DEL CACHE.
###########################################
# POOLS
###########################################
WORKAREA_SIZE_POLICY = AUTO
PGA_AGGREGATE_TARGET = 100M
#JAVA_POOL_SIZE
#JAVA_POOL_SIZE = 1000000 # SI NO UTILIZA JAVA
JAVA_POOL_SIZE = 33000000 # SI USA O SI SE ESTA INSTALANDO
LARGE_POOL_SIZE = 8000000
SHARED_POOL_SIZE = 50000000
# SHARED_POOL_RESERVED_SIZE = 10000000
# PRE_PAGE_SGA = TRUE # OPTIMIZA SI HAY MEMORIA PERMITE ALCANZAR PUNTO
OPTIMO MAS RAPIDO AUNQUE DESACELERA INICIALMENTE
# LOCK_SGA = TRUE # COLOCA TODO EL SGA EN MEMORIA, no funciona en NT
###########################################
# ARCHIVELOGFILES
###########################################
LOG_BUFFER = 1000000 # CANTIDAD DE DATOS QUE PUEDEN GENERARSE
DURANTE 9 SEGUNDOS SIN COMMIT O SAVEPOINT
LOG_ARCHIVE_START = TRUE
LOG_ARCHIVE_DEST = D:\XXXARCHLOG
LOG_CHECKPOINT_INTERVAL = 0
FAST_START_MTTR_TARGET = 300
###########################################
# CURSORS AND LIBRARY CACHE
###########################################
OPEN_CURSORS=800
SESSION_CACHED_CURSORS = 1000
###########################################
# UNDO MANAGEMENT
###########################################
UNDO_MANAGEMENT = AUTO
UNDO_TABLESPACE = TBL_UNDO
UNDO_RETENTION = 56000
###########################################
# DIAGNOSTICS AND STATISTICS
###########################################
BACKGROUND_DUMP_DEST = E:\ORAXXX\TRACE\BACKGROUND
USER_DUMP_DEST = E:\ORAXXX\TRACE\USER
CORE_DUMP_DEST = E:\ORAXXX\TRACE\CDUMP
###########################################
# FILE CONFIGURATION
###########################################
CONTROL_FILES = ("E:\ORAXXX\CONTROLFILES\CTL_XXX01.CTL",
"E:\ORAXXX\CONTROLFILES\CTL_XXX02.CTL",
"D:\ORAXXX\CONTROLFILES\CTL_XXX01.CTL",
"D:\ORAXXX\CONTROLFILES\CTL_XXX02.CTL")
READ_ONLY_OPEN_DELAYED = FALSE #TRUE, accede READONLY tablespaces solo al
leer datos ahi
DB_FILES=15
###########################################
# EXTERNAL FILES
###########################################
UTL_FILE_DIR = *
SESSION_MAX_OPEN_FILES = 30
###########################################
# NÚMERO MÁXIMO DE ROLES PERMITIDOS PARA BD
###########################################
MAX_ENABLED_ROLES = 70
LICENSE_MAX_USERS = 70
PROCESSES = 50 # 5 + (# USUARIOS CONCURRENTES*2
REPORT/DEVELOPER)
## SESSION = DERIVED (1.1 * PROCESSES + 5)
###########################################
# JOBS
###########################################
JOB_QUEUE_PROCESSES = 1
###########################################
# DISTRIBUTED
###########################################
OPEN_LINKS = 4
DB_DOMAIN = ""
REMOTE_DEPENDENCIES_MODE = SIGNATURE
###########################################
# PARA FUNCTION BASED INDEXES
###########################################
QUERY_REWRITE_ENABLED = TRUE
QUERY_REWRITE_INTEGRITY = ENFORCED
###########################################
# CBO
###########################################
optimizer_max_permutations=2500
OPTIMIZER_INDEX_COST_ADJ = 10 # Cambiar a 50 en datawarehousing
OPTIMIZER_INDEX_CACHING = 90 # No cambiar, posibilidad de encontrar
indice en cache
CURSOR_SHARING = EXACT # SIMILAR OR FORCE, quita performance, se
utilizan como auxiliar para mal binding
###########################################
# STATISTICS
###########################################
#TIMED_STATISTICS = TRUE
#STATISTICS_LEVEL = ALL
###########################################
# AUDIT
###########################################
AUDIT_SYS_OPERATIONS = TRUE
AUDIT_TRAIL = DB
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Wed Feb 18 2004 - 07:56:47 CST
