Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Can I use v$session.taddr for this?
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.