Load after Oracle upgrade??

From: Charles Ballowe (hangman_at_steelballs.org)
Date: 08/24/04

  • Next message: Jonathan Burelbach: "trucluster application dependency" 
    Date: Tue, 24 Aug 2004 14:32:02 -0500
To: tru64-unix-managers@ornl.gov

    Our database/applications team just did an upgrade of Oracle applications
    and database over the weekend and now the system load seems to be extremely
    high.

    Database 8i->9i
    Applications 11.5.8 -> 11.5.9

    OS is 5.1A

    Pre-upgrade, the system load average seemed to be between 2 and 12 depending
    on time of day etc. (near 0 at night). Post upgrade it's constantly pushing
    30 from start of business on through the day.

    I suspect that there are some tuning issues that need to be worked through,
    but I want to be sure that I'm not missing anything. Is there anything that
    I should look at or maybe tell the DBAs to look at that could improve
    performance?

    I've already verified that system parameters are set to where Oracle
    recommends.

    Has anybody else done a similar upgrade and noticed any similar problems?

    -Charlie

  • Next message: Jonathan Burelbach: "trucluster application dependency"

    Relevant Pages