cancel
Showing results for 
Search instead for 
Did you mean: 

IDES ERROR PLZ HELP-----reply req'd URGENT

former_member829550
Active Participant
0 Kudos

hi frnds,

recently our system went to golive.

in the early watch report some db parameters were shown as inconsistent. we adjusted these parameters in the ides system and unfortunately forgot to take the back up of the early parameter settings. from then on the ides system is not working properly. if a abap programmer is working on the ides then it is going to the dumps and also with the fico people.

we chaged the following parameters.

plzz reply .......

helpful answers will be surely rewarded with points.

btree_bitmap_plans

bloomfilter_enabled

sortelimination_cost_ratio

optimizermjc_enabled

fixcontrol

inmemory_undo

max_dump_file_size

optimizer_index_caching

optimizer_index_cost_adj

parallel_execution_message_size

parallel_max_servers

parallel_threads_per_cpu

processes

query_rewrite_enabled

replication_dependency_tracking

SESSIONS

SHARED_POOL_RESERVED_SIZE

STAR_TRANSFORMATION_ENABLED

TABLELOOKUP_PREFETCH_SIZE

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member829550
Active Participant
0 Kudos

thz

JPReyes
Active Contributor
0 Kudos

Whats your oracle version?...

Check SAP recommendations in SAP Notes 124361 for Oracle 9i and SAP Note 830576 for Oracle 10g.

Regards

Juan

former_member829550
Active Participant
0 Kudos

ECC 6 on Oracle 10.2.0.2.0 on WIN NT platform.

JPReyes
Active Contributor
0 Kudos

The the values of SAP Note 830576 should be the right ones for you.

Regards

Juan