Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can I use v$session.taddr for this?
Mike wrote:
> All,
>
> I have an application which has triggers attached to several tables.
> A single transaction may perform insert/update/delete on more than one
> table. Each trigger writes data to a separate logging table that I
> have created for this purpose.
>
> I'd like to be able to tie all the logging data from each transaction
> together, even though it may have been created by the separate
> triggers. Can I use v$session.taddr for this? I'm hoping that each
> separate transaction will have a taddr value which will persist until
> a rollback or commit, and then have another value for the next
> transaction.
>
> Or is there something else I should be looking at?
>
> Thanks in advance.
>
> -- Mike
IRRC, from v$transaction
XIDUSN
XIDSLOT
XIDSQN
would comprise a UNIQUE key for a single transcation.
HTH & YMMV HAND! Received on Wed May 07 2003 - 19:45:56 CDT