hi, Cary: Is the difference only whether it can early enable detailed 10046? Or there is still other difference? Thanks Zhu Chao. ----- Original Message ----- From: "Cary Millsap" <cary.millsap@xxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Friday, February 20, 2004 4:03 AM Subject: RE: Ora 9.2/HPUX 11i/Performance > Don't use dbms_system.set_sql_trace_in_session; use > dbms_support.start_trace_in_session. Big difference. The dbms_support > one lets you catch waits and binds. The dbms_system one doesn't. See > "How to activate extended SQL trace" at > http://www.hotsos.com/e-library/index.html for details. > > > Cary Millsap > Hotsos Enterprises, Ltd. > http://www.hotsos.com > * Nullius in verba * > > Upcoming events: > - Performance Diagnosis 101: 2/24 San Diego, 3/23 Park City, 4/6 Seattle > - SQL Optimization 101: 2/16 Dallas > - Hotsos Symposium 2004: March 7-10 Dallas > - Visit www.hotsos.com for schedule details... > > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Vergara, Michael > (TEM) > Sent: Thursday, February 19, 2004 12:27 PM > To: oracle-l@xxxxxxxxxxxxx > Subject: RE: Ora 9.2/HPUX 11i/Performance > > Using the SAP tools, we can isolate the process that is > running (at least instantaneously) SQL that we're interested > in. I then use... > begin > sys.dbms_system.set_sql_trace_in_session( &sid, &serial, TRUE); > end; > / > > ...to trace that session. If we could not find it, you're > absolutely correct that we'd have to turn tracing on globally, > and then walk over 400 trace files looking for SQL of interest. > NOT how I want to spend my day! > > Cheers, > Mike > > > -----Original Message----- > From: Jared Still [mailto:jkstill@xxxxxxxxxx] > Sent: Thursday, February 19, 2004 10:10 AM > To: Oracle-L Freelists > Subject: Re: Ora 9.2/HPUX 11i/Performance > > > When you say 'sql trace' do you mean 10046? > > Which session(s) did you trace? =20 > > As SAP users get their data through an application server, > I would suspect you would need to turn tracing on for all > SAPR3 connections. > > Jared > > On Thu, 2004-02-19 at 09:41, Vergara, Michael (TEM) wrote: > > Hi Everyone! > >=20 > > We are having intermittent and irregular performance issues > > with one of our home-grown reports from our SAP system. I tried > > running a SQL trace, but it was insufficient to our needs. > >=20 > > Is there another kind of trace that I can turn on and turn off > > that will supply more info about the SQL, the execution plan, and > > access times? > >=20 > > Thanks, > > Mike > >=20 > >=20 > > --- > > = > =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3 > D= > 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D > > = > =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3 > D= > 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D > > = > =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3 > D= > 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D > >=20 > > Michael P. Vergara > > Oracle DBA > > Guidant Corporation > >=20 > > ---------------------------------------------------------------- > > 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 -----------------------------------------------------------------