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.
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.