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.
Sorry. I forgot to attach my file.
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.
Set the following in your database and see what the stats give:
This will enforce the system level bind variables in the query.
ALTER SYSTEM SET cursor_sharing=FORCE;
Life is a journey, not a destination!
Click Here to Expand Forum to Full Width