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 -> Associating a row with the object which created it

Associating a row with the object which created it

From: Donnie Armstrong <darmstro_at_isd.net>
Date: Tue, 04 May 1999 09:06:48 -0500
Message-ID: <372EFEF8.41F7@isd.net>


First post,

We are attempting to trace where some of our rows are comng from using triggers and the V$ tables. Identifying where the row came from, like a trigger fired, procedure executed, ect, we are able to identify what the SQL statement is from the relationship between V$SESSION -> V$SQLTEXT, but unable to tie the SQL back to the object. Any suggestions?

Donnie Armstrong
darmstro_at_isd.net Received on Tue May 04 1999 - 09:06:48 CDT

Original text of this message

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