Re: question about dbms_syste.set_sql_trace_in_session
- From: Mladen Gogala <mladen@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 3 Mar 2004 12:41:11 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
> Behalf Of Tanel Põder
> Sent: Thursday, March 04, 2004 3:27 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxx>
> To: <oracle-l@xxxxxxxxxxxxx>
> Cc: "Peter Ross. Sharman" <PETER.SHARMAN@xxxxxxxxxx>
> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of Niall Litchfield
> > Sent: Thursday, March 04, 2004 2:47 AM
> > To: oracle-l@xxxxxxxxxxxxx
> > 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@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at //www.freelists.org/archives/oracle-l/
> > FAQ is at //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@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at //www.freelists.org/archives/oracle-l/
> > FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
