DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Statspack report

  1. #1
    Join Date
    Feb 2003
    Location
    London
    Posts
    170

    Statspack report

    Hi all,

    We've been having some performance issues and I have been running statspack to analyze that.
    Can you please help me go through this report and let me know the main areas of concern.

    Thanks a lot.

  2. #2
    Join Date
    Feb 2003
    Location
    London
    Posts
    170
    Sorry. I forgot to attach my file.

    Thanks again.
    Attached Files Attached Files

  3. #3
    Join Date
    Jul 2003
    Posts
    59
    The problem that jumps out at me first is your negative "Execute to Parse" ratio.

    If it's too small, that means you are parsing a majority of the stmts you execute. If it is negative, that means you are actually parsing more stmts than you are executing. That's very bad.

    Look for code that contains literals (things like where acct_no = '12345'). You should use bind variable instead of literals. And, of course, look for those places where you are parsing SQL but then not executing it.

    Tom Best

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Set the following in your database and see what the stats give:

    Code:
       
         ALTER SYSTEM SET cursor_sharing=FORCE;
    This will enforce the system level bind variables in the query.

    -Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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