First question as always, operating system and version??? Dick Goulet Senior Oracle DBA ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of patrick obrien Sent: Tuesday, November 23, 2010 11:55 AM To: oracle-l@xxxxxxxxxxxxx Subject: Perforamance problem on an Application running on top of Oracle 9 Good Day DBA's, Our shop owns a check printing application running on top of Oracle 9.2.0.1.0. This application is very slow during one particular process. While this process is running so slow, what view/table can I look at to see what table this process is using? And, any other thoughts on how I can troubleshoot an oracle 92010 database with performance problems. thank you very much, Patrick O*