Re: records query of one username with osuser

Steve Robin wrote:
> Is there any other way than dbms_system.SET_SQL_TRACE_IN_SESSION,
> to record all the work of one session. Connection is been estabished
> by an application. Now as soon as application connects, it started
> executing queries.
> To do dbms_system.SET_SQL_TRACE_IN_SESSION tracing, session should be
> up to know sid and serial# but I have "osuser name" and "username".
> Now can I record all the queries from that user on that osuser.

Depends on the version.

dbms_monitor (10g)
dbms_support (since 8.0.6)

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