Re: list of executed DML statements

Dominik,

V$SQLAREA should give this to you.

SELECT sql_text
FROM v$sqlarea
WHERE TO_DATE(FIRST_LOAD_TIME,'YYYY-MM-DD/HH24:MI:SS') > '26-JUL-2005 16:00:00';

Requires privilege "SELECT ANY DICTIONARY" to see V$SQLAREA. You also need the TO_DATE since FIRST_LOAD_TIME is a VARCHAR2, not a DATE field.

Scott Hutchinson.

Quoting Dominik Smatana <dominik_at_ttsm.net>:

> hello,
>
> is there any way (in Oracle DB 9.2i) to retrieve a list of all
> INSERTs, UPDATEs and DELETEs executed in specific time ago?
>
> thanks
> Dominik Smatana
>
> --
> http://www.freelists.org/webpage/oracle-l
>

::This message sent using the free Web Mail service from http://TheName.co.uk

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