Re: list of executed DML statements
- From: scott.hutchinson@xxxxxxxxxxxxxxxxxxxxx
- To: dominik@xxxxxxxx
- Date: Tue, 26 Jul 2005 16:08:51 +0100
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@xxxxxxxx>:
> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
::This message sent using the free Web Mail service from http://TheName.co.uk
--
//www.freelists.org/webpage/oracle-l
Other related posts:
