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 -----------------------------------------------------------------