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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------