Re: owner of transactions

On 12 Apr, 14:17, "Andrea" <netsecur..._at_tiscali.it> wrote:
> Hi,
> i've read on oracle library that is possible to find when the rows are
> inserted, through SCN:
>
> Example..
> SELECT SCN_TO_TIMESTAMP(ORA_ROWSCN) FROM FOO;
>
> SCN_TO_TIMESTAMP(ORA_ROWSCN)
> ------------------------------
> 11-APR-07 15:29:47,000000000
> 11-APR-07 15:29:47,000000000
> 10-APR-07 15:20:47,000000000
>
> is possible knows also which user has inserted the rows or which user
> had last access on the table?
>
> thanks
> bye
> Andrea

Check out Log Miner:

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14215/logminer.htm

HTH -g Received on Thu Apr 12 2007 - 10:17:21 CDT