Perforamance problem on an Application running on top of Oracle 9

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*         

--
http://www.freelists.org/webpage/oracle-l