Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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)Received on Tue Jun 21 2005 - 17:35:54 CDT