Re: sql_trace

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 21 Apr 2007 13:53:53 -0700
Message-ID: <1177188834.433649@bubbleator.drizzle.com>

manesachin97_at_gmail.com wrote:
> hi friend i have 1 query
> that is
> using sql_trace=true
> or
> alter session set sql_trace=true
> you can find out the query execution performance
>
> but in case there is so many user then how can you find out that
> perticular user query is this
>
> for example
> _________________________________________________
>
> user_dump_dest=/oracle/udump/
>
> filename username(i am adding for understanding)
> file1.trc hr
> file2.trc sales
> file3.trc sales
>
>
> using abouve files suppose you need to find out
> users hr executed query
>
> how will you find out this?
>
> adavantage of this
>
> if there is thousands of user then it become very difficult for dba to
> trace aparticular user detail
>
> and for him difficult to trace further using trace
>
> i want output like this
> username executed qu
> filename username
> oracle/udump/file1.trc hr
> oracle/udump/file4.trc hr
> oracle/udump/file1.trc hr
> oracle/udump/file1.trc hr
>
> so that i can user
> tkprof oracle/udump/file1.trc
>
> this is good for handy work of tkprof

You have not provided sufficient information, for example version and what you are actually doing, to help you.

When I run a 10053 trace here is what I see:

ACTION NAME:() 2007-04-21 13:52:01.663
MODULE NAME:(SQL*Plus) 2007-04-21 13:52:01.663
SERVICE NAME:(SYS$USERS) 2007-04-21 13:52:01.663
SESSION ID:(159.461) 2007-04-21 13:52:01.663

That should provide sufficient information to do what you want.

Action and module can be set using DBMS_APPLICATION_INFO.

-- 
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 Sat Apr 21 2007 - 15:53:53 CDT