on 09-13-2007 1:11 PM
Hello,
we have a lot of performance problems with oracle 10G. Especially tables scan on DRAW or AEN1 have long response times. It seems that the CBO uses the wrong strategy. The latest merge fix is already installed. Any idea to solve the problem is welcome.
Best regards
Juergen Remmert
Hi Juren Remmert..
We also had a lot of performance issues.We had upgraded 6 systems from 9.2.0.7 to 10.2.0.2.
As others have rightly pointed out u need to set all the parameters of Oracle in accordance with the note 830576.
This note should set right everything for u.
The <b>_(underscore)</b> parameters are very important in that.
Regards
Bharathwaj V
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Typical reasons beside statistics are:
- Parameters (-> note 830576 has to be applied carefully)
- Changes of CBO behavior with 10g (-> note 176754)
If this doesn't solve the problem and you need a more detailed advice, please provide me with details (execution plan, SQL statement, statistics, ...).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We had similar performance issues in our environment, once we upgraded from 9.2.0.2 to 10.2.0.2.
Oracle: 10.2.0.2
SAP: 4.7x110
OS: SOLARIS 9 64bit
The above mentioned notes were very helpful. We had to install an oracle patch as well (found on marketplace) -- 6321245
and make the following oracle parameters changes:
pga_aggregate_target - 144MB (default = 25MB)
*.event="10027 trace name context forever, level 1"
*.event="10028 trace name context forever, level 1"
*.event="10162 trace name context forever, level 1"
*.event="10183 trace name context forever, level 1"
*.event="10191 trace name context forever, level 1"
*.event="10629 trace name context forever, level 32"
*.event="38068 trace name context forever, level 100"
*.event="38043 trace name context forever, level 1"
*.optimizer_index_caching=50
*.optimizer_index_cost_adj=20
*.parallel_execution_message_size=16384
*._b_tree_bitmap_plans=FALSE
*._index_join_enabled=FALSE
*._optim_peek_user_binds=FALSE
*._optimizer_mjc_enabled=FALSE
*._sort_elimination_cost_ratio=10
Remove
*.optimizer_features_enable='9.2.0'
HTH
try:
brconnect -c -u / -f stats -t DRAW,AEN1 -f collect
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.