compatible 11.2.0
cursor_sharing FORCE
db_cache_size 2 097 152 000
db_file_multiblock_read_count 16
db_writer_processes 1
disk_asynch_io TRUE
filesystemio_options asynch
java_pool_size 167 772 160
job_queue_processes 10
large_pool_size 67 108 864
log_checkpoints_to_alert FALSE
open_cursors 5 000
pga_aggregate_target 5 368 709 120
processes 2 000
recyclebin off
session_cached_cursors 150
sga_max_size 5 301 600 256
shared_pool_reserved_size 78 852 915
shared_pool_size 1 577 058 304
statistics_level TYPICAL
timed_statistics TRUE
undo_management AUTO
undo_retention 10 800
undo_tablespace UNDO_RRC01
workarea_size_policy AUTO
optimizer_capture_sql_plan_baselines FALSE
_optimizer_cost_based_transformation OFF
optimizer_dynamic_sampling 2
optimizer_features_enable 11.2.0.3
optimizer_index_caching 50
optimizer_index_cost_adj 50
optimizer_mode choose
optimizer_secure_view_merging FALSE
_optimizer_skip_scan_enabled FALSE
optimizer_use_invisible_indexes FALSE
optimizer_use_pending_statistics FALSE
optimizer_use_sql_plan_baselines FALSE
Partager