Solving unknown database performance problems

Associate
Joined
23 Aug 2004
Posts
1,493
A system that uses an oracle backend has performance issues. Assuming there's no infrastructure faults, where do you start diagnosing where the fault has occured? (In Oracle) I know of the v$locks and v$sessions table but aside from studying these, removing locks and killing running oracle processes, my diagnosis knowledge is limited. Can someone who has experience in this area help out? Thanks.
 
Back
Top Bottom