Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: owner of transactions
Andrea 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
gv$transaction
gv$active_session_history (ASH)
But be aware of your licensing before touching ASH.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu Apr 12 2007 - 16:34:30 CDT