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

On 9 Mar 2006 12:05:22 -0800, dbaplusplus_at_hotmail.com wrote:

>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

Using statspack taking snapshots on level 5

--
Sybrand Bakker, Senior Oracle DBA