DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: LOW DATABASE PERFORMANCE! Help required

  1. #1
    Join Date
    May 2008
    Posts
    6

    LOW DATABASE PERFORMANCE! Help required

    Hi, can any body help me to improve database performance. I am getting high performance on Testing server but on production it degrades to half.

    Production Server
    OS: AIX 5.1L on IBM Power6 Server, 32GB RAm, 6 Physical Processors
    ORACLE: 10G

    Testing UAT Server
    OS: AIX 5.1L on IBM Power5 Server, 16GB RAM, 4 Physical Processors
    ORACLE: 10G


    ORACLE database is same. same size, same pfile,same disk sizes.

    hdisk(n) are copied on testing server

    my production database performance is exact the half but hardware config is high SMT is enabled on production and is disabled on TESTING UAT.
    RegardsSabalesh Mahajan

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    statspack / awr?

  3. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Concurrency? how many users on UAT?... how many users on PROD?

    Compare top ten wait events on both UAT vs. PROD, that might point you in the right direction.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  4. #4
    Join Date
    May 2008
    Posts
    6
    well user sessions are equal on UAT and PROD server while i have executed my processing.

    we donot release servers when night activities are on.
    RegardsSabalesh Mahajan

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    and what does statspack / awr say?

  6. #6
    Join Date
    May 2008
    Posts
    6
    Database spill rate is high...
    how to decrease that????
    RegardsSabalesh Mahajan

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    spill rate - what the hell is that
    Last edited by davey23uk; 06-01-2008 at 11:58 AM.

  8. #8
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    my production database performance is exact the half but hardware config is high SMT is enabled on production and is disabled on TESTING UAT.
    Are you the first guy using the SMT ?

  9. #9
    Join Date
    May 2008
    Posts
    6
    Ok, My prod system is streams detonated system. and spills are related to streams (AQ).
    RegardsSabalesh Mahajan

  10. #10
    Join Date
    Jan 2001
    Posts
    2,828
    streams detonated system ?

    Did the database explode ?



    regards
    Hrishy

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