Re: Trace on a Table

GiriBabu.09_at_gmail.com wrote:
> I would like to know how we can have a trace on table to findout which
> IP address and port are updating the table.
>
> Regards,
> Giri

Ports ... not sure it is possible or that it has any meaning. Is the connection coming through an application server to the listener?

IP address can be determined using SYS_CONTEXT function http://www.psoug.org/reference/sys_context.html

Table update can be found using BEFORE or AFTER update trigger http://www.psoug.org/reference/table_trigger.html

-- 
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