Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: owner of transactions

Re: owner of transactions

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 12 Apr 2007 14:34:30 -0700
Message-ID: <1176413663.772491@bubbleator.drizzle.com>


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.org
Received on Thu Apr 12 2007 - 16:34:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US