RE: question about dbms_syste.set_sql_trace_in_session
- From: "Niall Litchfield" <n-litchfield@xxxxxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 04 Mar 2004 08:47:06 +0000
So we will need USER_MANAGER_DEPENDENCIES view to check?
> -----Original Message-----
> From: Mark.Bobak@xxxxxxxxxxxxxxx
> Sent: 03 March 2004 18:35
> To: Mark.Bobak@xxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> Sent: Wednesday, March 03, 2004 1:27 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxxxx]
> Sent: Wednesday, March 03, 2004 1:23 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxxx]
> Sent: Wednesday, March 03, 2004 1:11 PM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: RE: question about dbms_syste.set_sql_trace_in_session
>
>
> How about:
>
> INCLUDING MANAGER
>
> Option?
>
> Igor Neyman, OCP DBA
> ineyman@xxxxxxxxxxxxxx
>
>
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mladen Gogala
> Sent: Wednesday, March 03, 2004 12:41 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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@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
> -----------------------------------------------------------------
>
>
> ----------------------------------------------------------------
> 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:
