Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: question about dbms_syste.set_sql_trace_in_session

RE: question about dbms_syste.set_sql_trace_in_session

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Wed, 3 Mar 2004 14:07:28 -0500
Message-ID: <D91D9D5A73FC694BBC52F1EB26AD410F02411FC8@MSGBOSCLD2WIN.DMN1.FMR.COM>


Also you need "alter system" priv :)

Not easy to get

Waleed

-----Original Message-----
From: Bobak, Mark [mailto:Mark.Bobak_at_il.proquest.com] Sent: Wednesday, March 03, 2004 1:36 PM
To: oracle-l_at_freelists.org
Subject: RE: question about dbms_syste.set_sql_trace_in_session

Just make sure it's not your own manager...;-)

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
Sent: Wednesday, March 03, 2004 1:27 PM
To: oracle-l_at_freelists.org
Subject: RE: question about dbms_syste.set_sql_trace_in_session

Humm, Wonder where the CASCADE stops?? *-)

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Bobak, Mark [mailto:Mark.Bobak_at_il.proquest.com] Sent: Wednesday, March 03, 2004 1:23 PM
To: oracle-l_at_freelists.org
Subject: RE: question about dbms_syste.set_sql_trace_in_session

I like:
ALTER SYSTEM FIRE MANAGER <username> CASCADE;

;-)

-----Original Message-----
From: Igor Neyman [mailto:ineyman_at_perceptron.com] Sent: Wednesday, March 03, 2004 1:11 PM
To: oracle-l_at_freelists.org
Subject: RE: question about dbms_syste.set_sql_trace_in_session

How about:

INCLUDING MANAGER Option?

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala Sent: Wednesday, March 03, 2004 12:41 PM To: oracle-l_at_freelists.org
Subject: Re: question about dbms_syste.set_sql_trace_in_session

So, what you are saying is that the next release of oracle will have a command like:

        ALTER SYSTEM FIRE DEVELOPER <USERNAME>
Can I suggest you to add options like "EXECUTE [IMMEDIATE|SLOWLY|PAINFULLY]"? On 03/03/2004 12:33:40 PM, Pete Sharman wrote:
> I think a lot more of it is instrumented with the 10g release.
>
> The usual instrumentation problem. There's no easy answer to how much
code should you instrument other than "it depends". If it's well written SQL and you trust the developer, then it probably needs less instrumentation. If it's crap, then firing the developer may be a better option than instrumentation anyway. :)
>
> Pete
>
> "Controlling developers is like herding cats."
>
> Kevin Loney, Oracle DBA Handbook
>
> "Oh no, it's not. It's much harder than that!"
>
> Bruce Pihlamae, long-term Oracle DBA
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org

[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tanel Põder
> Sent: Thursday, March 04, 2004 3:27 AM
> To: oracle-l_at_freelists.org
> Subject: Re: question about dbms_syste.set_sql_trace_in_session
>
> Yep, Apps is somewhat instrumented, but I don't think that 100% of
it's code
> is...
>
> One performance issue which arises here is that if development tools
and
> application servers don't support module and action information
bundling
> with the call itself (like OCI does), then we introduce too many extra
> database calls just for instrumentation, which means less scalability
and
> worse performance...
>
> Tanel.
>
> ----- Original Message -----
> From: "Pete Sharman" <peter.sharman_at_oracle.com>
> To: <oracle-l_at_freelists.org>
> Cc: "Peter Ross. Sharman" <PETER.SHARMAN_at_oracle.com>
> Sent: Wednesday, March 03, 2004 6:14 PM
> Subject: RE: question about dbms_syste.set_sql_trace_in_session
>
>
> > Untrue, untrue! IIRC, Apps has also been instrumented with the
service,
> module and action name stuff.
> >
> > It's the usual thing. We can give you the tools to make life easier
for
> yourself. If you choose not to use them, more fool you! :)
> >
> > Pete
> >
> > "Controlling developers is like herding cats."
> >
> > Kevin Loney, Oracle DBA Handbook
> >
> > "Oh no, it's not. It's much harder than that!"
> >
> > Bruce Pihlamae, long-term Oracle DBA
> >
> >
> > -----Original Message-----
> > From: oracle-l-bounce_at_freelists.org

[mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Niall Litchfield
> > Sent: Thursday, March 04, 2004 2:47 AM
> > To: oracle-l_at_freelists.org
> > Subject: RE: question about dbms_syste.set_sql_trace_in_session
> >
> > > If the application sets MODULE and ACTION fields by using
> > > DBMS_APPLICATION_INFO package,
> > > one can trace all clients which execute that particular
> > > module automagically,
> > > by using the following:
> > >
> > > DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE(
> > > service_name IN VARCHAR2,
> > > module_name IN VARCHAR2,
> > > action_name IN VARCHAR2 DEFAULT ALL_ACTIONS);
> >
> > There are literally thousands of such installations around the world
as
> well, most of them unfortunately seem to be called sqlplus :(
> >
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission
> > +44 117 975 7805
> >
> >
> >
> >



> > This email contains information intended for
> > the addressee only. It may be confidential
> > and may be the subject of legal and/or
> > professional privilege. Any dissemination,
> > distribution, copyright or use of this
> > communication without prior permission of
> > the sender is strictly prohibited.
> >


> >
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
> >
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
> >
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>


Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Wed Mar 03 2004 - 13:06:34 CST

Original text of this message

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