-
Performance degrade after migrate from oracle8i to oracle9i
RDBMS Version: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
Operating System and Version: Windows 2003
Performance degrade after migration from oracle8i
I have shifted database from oracle 8i to 9i thru export and import.
I also ran gather stats thru command
execute dbms_stats.gather_schema_stats(ownname => 'username',estimate_percent=> 33,cascade => TRUE,degree => 4);
The database ran two days perfectly. On third evening database performance degraded drastically. I check buffer hit and cached hit, which were above 99%. Then I ran gather stats again and performance restored. Now fourth evening database performance down again so I ran gather stats and database start performing.
Any idea where things are wrong....Regards
-
well you identified the problem yourself no?
Your datasets must be changing very quickly and you need to gather more stats.
Turn on monitoring and oracle can gather stats when it needs to, then your performace should be ok without you intervening all the time
-
homegrown or delivered app? do tell
I'm stmontgo and I approve of this message
-
Dear Davey
Thanks for your response.
wud u pls guide me how to turn on monitoring and is there any overhead of it.
Regards
-
-
Originally posted by sallo
Dear Davey
Thanks for your response.
wud u pls guide me how to turn on monitoring and is there any overhead of it.
Regards
what app are u using dude? their are vendor specifc issues - care to share with the class?
I'm stmontgo and I approve of this message
-
Dear stmontgo
We are using two types of apps. one developed in oracle 6i forms and other in java.
Regards
-
Originally posted by sallo
Dear stmontgo
We are using two types of apps. one developed in oracle 6i forms and other in java.
Regards
ah ok, I know erps for one will give you recommended init setiings that often include some nasty little _ underscrore parameters
I'm stmontgo and I approve of this message
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|