Performance degrade after migrate from oracle8i to oracle9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Performance degrade after migrate from oracle8i to oracle9i

  1. #1
    Join Date
    Feb 2002
    Posts
    10

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    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

  3. #3
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    homegrown or delivered app? do tell
    I'm stmontgo and I approve of this message

  4. #4
    Join Date
    Feb 2002
    Posts
    10
    Dear Davey

    Thanks for your response.

    wud u pls guide me how to turn on monitoring and is there any overhead of it.

    Regards

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333

  6. #6
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    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

  7. #7
    Join Date
    Feb 2002
    Posts
    10
    Dear stmontgo

    We are using two types of apps. one developed in oracle 6i forms and other in java.

    Regards

  8. #8
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    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
  •  


Click Here to Expand Forum to Full Width