Re: Find and trace unknown session?

dan_livingston wrote:
> 9.2.0.6 and 10.1.0.4 - thought I had entered that - no it is not
> irrelevant ...

The response I provided should solve the problem for 10gR1. Go to www.psoug.org
click on Morgan's Library
click on DBMS_SERVICE and find CREATE_SERVICE for creating a service. click on SYSTEM TRIGGERS for that if you need it. click on DBMS_MONITOR for demo code too.

With 9i it is far more difficult to accomplish but you can probably put something together with SYSTEM TRIGGERS, the SYS_CONTEXT function, and the DBMS_SUPPORT package. Demo also in Morgan's Library.

Before implementing any of these be sure to look at the tahiti.oracle.com docs so you understand the concepts too.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)