Results 1 to 5 of 5
  1. #1
    Join Date
    May 2009
    Posts
    26

    Exclamation Unanswered: database very slow

    I added hard drives on solaris box and when we try to run daily processes they longer than expected, for example a process called paycalc was taking 6hrs and now its taking 35-40hrs
    i have attached a word document file with statspack report
    Attached Files Attached Files

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >a process called paycalc was taking 6hrs and now its taking 35-40hrs
    What changed?
    Change it back.

    Are statistics current for all tables & indexes?
    OS name & version?
    Oracle version to 4 decimal places.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by bmahanzu
    i have attached a word document file with statspack report
    I am afraid the kind of people who open Word documents from unknown sources will not be able to give you any meaningful advice...
    ---
    "It does not work" is not a valid problem statement.

  4. #4
    Join Date
    May 2009
    Posts
    26
    statistics are current
    OS version is solaris 5.10
    oracle 9.2.0.1.0

  5. #5
    Join Date
    Jun 2009
    Posts
    1
    sorry no idea

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •