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: Thu, 22 Mar 2007 17:44:46 -0700
Message-ID: <1174610685.321473@bubbleator.drizzle.com>


Steve Robin wrote:

> On Mar 21, 8:39 pm, "gazzag" <gar..._at_jamms.org> wrote:

>> On 21 Mar, 15:12, "Steve Robin" <ocma..._at_gmail.com> wrote:
>>
>>
>>
>>
>>
>>> On Mar 21, 7:18 pm, DA Morgan <damor..._at_psoug.org> wrote:
>>>> 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
>>>> damor..._at_x.washington.edu
>>>> (replace x with u to respond)
>>>> Puget Sound Oracle Users Groupwww.psoug.org
>>> Thanks for reply. But if there any other way to trace the sessions of
>>> one osuser because I just have os username and database username.
>>> Yes, I can see the sid from v$session, but I cann't because this user
>>> connected from an front end application which open and close connect
>>> of many times, with same username. If I use it I have to do it again
>>> and again, which is not possible.- Hide quoted text -
>>> - Show quoted text -
>> Again, you might want to google this group for "logon trigger".
>>
>> Also,http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:8...,
>> for example.
>>
>> HTH
>>
>> -g- Hide quoted text -
>>
>> - Show quoted text -
> 
> thanks.
> but how would I come to which session is under sql trace and which is
> not. I want to stop it after a particular activity.

Can you be more explicit and repeat the exact version number.

-- 
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 Thu Mar 22 2007 - 19:44:46 CDT

Original text of this message

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