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 -> Re: records query of one username with osuser

Re: records query of one username with osuser

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 21 Mar 2007 07:18:32 -0700
Message-ID: <1174486710.764370@bubbleator.drizzle.com>


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
Received on Wed Mar 21 2007 - 09:18:32 CDT

Original text of this message

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