View Single Post

   
  #1 (permalink)  
Old 02-25-2008, 03:57 AM
dbaplusplus@hotmail.com
 
Posts: n/a
Default 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

Reply With Quote