on 04-30-2008 8:10 AM
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
thz
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Whats your oracle version?...
Check SAP recommendations in SAP Notes 124361 for Oracle 9i and SAP Note 830576 for Oracle 10g.
Regards
Juan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.