Database Tuning (MOSC)

MOSC Banner

How I solved Query Runs much Slower 10g than in 9i

User502553-Oracle
User502553-Oracle Posts: 21 Blue Ribbon
in Database Tuning (MOSC) 2 comments
Tagged:

Comments

  • user9543 - oracle
    user9543 - oracle Posts: 1 Newbie
    Hi,

    Have you taken stats on table, System Stats, Sys user stats before migration. Rule hint is forcing optimizer to behave like RBO which is not as efficient as CBO. Please try what I have mentioned as above and try without Rule hint.

     

  • user11999337
    user11999337 Posts: 8 Blue Ribbon
    Did you check  "_optimizer_cost_model"  value? in 9i it is set to I/O where as in 10g it defaults to CPU. if your system is CPU bount, it will cause the performance degradation.

    Regards,

    Palwinder.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center