Is sthere any way to find what sql stataements were run between two points in time

I am using Oracle 9.2.0.5 on HP UNX 11i. An Oracle error occurred at some point in the past. I want to find what sql statements might have caused the problem. Is there a way to find sql statements run between two points of time by looking at v$ views.

I know using log miner, one can get some information. However, log miner only provides insert, delete and update statements but not select statements.

This is a production system. It does not have any Oracle auditing implemented.

Thanks Received on Thu Mar 09 2006 - 14:05:22 CST