Oracle 권고 parameters

11.2.0.4
*._gby_hash_aggregation_enabled=FALSE
*._highthreshold_undoretention=43200
*._newsort_enabled=FALSE
*._nlj_batching_enabled=0
*._optim_peek_user_binds=FALSE
*._optimizer_adaptive_cursor_sharing=FALSE
*._optimizer_connect_by_cost_based=FALSE
*._optimizer_extended_cursor_sharing='NONE'
*._optimizer_extended_cursor_sharing_rel='NONE'
*._optimizer_use_feedback=FALSE
*._use_adaptive_log_file_sync='FALSE'

출처 : http://pat98.tistory.com/809

- Oracle 12c 권고파라메터 (옵티마이저의 경우는 민감하므로 참고만 할것) -

 

SEC_CASE_SENSITIVE_LOGON=TRUE

SQLNET.ALLOWED_LOGON_VERSION_SERVER=11 (In sqlnet.ora)

AUDIT_TRAIL=none/db (선택사항)

DEFERRED_SEGMENT_CREATION=FALSE

JOB_QUEUE_PROCESSES=16 (real CPU count)

_DATAFILE_WRITE_ERRORS_CRASH_INSTANCE=TRUE

MAX_STRING_SIZE=STANDARD

INMEMORY_FORCE=OFF

SESSION_CACHED_CURSORS=200

_MEMORY_IMM_MODE_WITHOUT_AUTOSGA=TRUE

_OPTIMIZER_AGGR_GROUPBY_ELIM=FALSE

_OPTIMIZER_COST_BASED_TRANSFORMATION=OFF

OPTIMIZER_MODE=ALL_ROWS

OPTIMIZER_DYNAMIC_SAMPLING=2 (11은 자동선택)

OPTIMIZER_USE_PENDING_STATISTICS=FALSE

STATISTICS_LEVEL=TYPICAL

CONTROL_MANAGEMENT_PACK_ACCESS=DIAGNOSTIC+TUNING (standard edition=none)

 

- New Paramters 12c -

 

Oracle Database 12.1.0.1

 

– CELL_OFFLOADGROUP_NAME
– CONNECTION_BROKERS
– DB_BIG_TABLE_CACHE_PERCENT_TARGET
– DB_INDEX_COMPRESSION_INHERITANCE
– DNFS_BATCH_SIZE
– ENABLE_PLUGGABLE_DATABASE
– HEAT_MAP
– MAX_STRING_SIZE
– NONCDB_COMPATIBLE
– OPTIMIZER_ADAPTIVE_FEATURES
– OPTIMIZER_ADAPTIVE_REPORTING_ONLY
– PARALLEL_DEGREE_LEVEL
– PARALLEL_FAULT_TOLERANCE_ENABLED
– PDB_FILE_NAME_CONVERT
– PGA_AGGREGATE_LIMIT
– SPATIAL_VECTOR_ACCELERATION
– TEMP_UNDO_ENABLED
– THREADED_EXECUTION
– UNIFIED_AUDIT_SGA_QUEUE_SIZE
– USE_DEDICATED_BROKER

 

Oracle Database 12.1.0.2

 

 – DBFIPS_140
 – COMMON_USER_PREFIX
 – DB_PERFORMANCE_PROFILE
 – ENABLE_GOLDENGATE_REPLICATION (11.2.0.4 and 12.1.0.2)
 – EXCLUDE_SEED_CDB_VIEW
 – INMEMORY_CLAUSE_DEFAULT
 – INMEMORY_FORCE
 – INMEMORY_MAX_POPULATE_SERVERS
 – INMEMORY_QUERY
 – INMEMORY_SIZE
 – INMEMORY_TRICKLE_REPOPULATE_SERVERS_PERCENT
 – OPTIMIZER_INMEMORY_AWARE
 – PDB_LOCKDOWN
 – PDB_OS_CREDENTIAL