When you say 'sql trace' do you mean 10046? Which session(s) did you trace? 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! > > 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. > > 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? > > Thanks, > Mike > > > --- > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= > > Michael P. Vergara > Oracle DBA > Guidant Corporation > > ---------------------------------------------------------------- > 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 -----------------------------------------------------------------