Skip to Content

Oracle Parameter Recommedation

Dear Oracle Experts,

I have upgraded Oracle 10204 to 10205 and now i want to alter the oracle parameter while system Specs is:

Processors: x3690 X5, Xeon 8C E7-2820 105W 2.00GHz with 2 Processor

RAM: 32 GB

current initSID.ora

prd.__db_cache_size=738197504
*._OPTIM_PEEK_USER_BINDS=FALSE
*.compatible='10.2.0'
*.control_file_record_keep_time=30
*.db_block_size=8192
*.db_cache_size=4294967296
*.db_files=254
*.db_name='PRD'
*.dml_locks=4000
*.event='10191 trace name context forever, level 1'
*.FILESYSTEMIO_OPTIONS='setall'
*.job_queue_processes=1
*.log_buffer=1048576
*.log_checkpoint_interval=0
*.log_checkpoints_to_alert=true
*.open_cursors=800
*.optimizer_features_enable='10.2.0.1'
*.parallel_max_servers=160
*.pga_aggregate_target=629145600
*.processes=280
*.sessions=560
*.sga_max_size=5368709120
*.shared_pool_reserved_size=72461844
*.shared_pool_size=724618444
*.sort_area_retained_size=0
*.sort_area_size=2097152
*.statistics_level='typical'
*.undo_management='AUTO'
*.undo_retention=43200
*.undo_tablespace='PSAPUNDO'
*.user_dump_dest='G:\oracle\PRD\saptrace\usertrace'
*.workarea_size_policy='AUTO'

there are may parameters are not configure with respect to SAP Note 830576 - Parameter recommendations for Oracle 10g.

while my system is OLTP(SAP ECC 6.0) and please give me your expert suggestion with respect to 10.2.0.5 about following parameters.

STAR_TRANSFORMATION_ENABLED
 _FIX_CONTROL
EVENT
 _INDEX_JOIN_ENABLED
DB_FILE_MULTIBLOCK_READ_COUNT
OPEN_CURSORS
OPTIMIZER_INDEX_COST_ADJ 
PARALLEL_THREADS_PER_CPU
PGA_AGGREGATE_TARGET
SHARED_POOL_SIZE
_FIRST_SPARE_PARAMETER 


Regards,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 06, 2012 at 09:13 AM

    Hi,

    Please run the script attached to SAP Note 1171650. Check what value it proposes in your system for below mentioned parameters. You may need to adjust the parameters accordingly.

    Regards,

    Deepak Kori

    Add comment
    10|10000 characters needed characters exceeded