Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: trace sql statements

Re: trace sql statements

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 4 Jun 2003 23:19:06 +1000
Message-ID: <W2mDa.49597$1s1.649707@newsfeeds.bigpond.com>


"Holger Baer" <holger.baer_at_science-computing.de> wrote in message news:3EDDE7DC.5020109_at_science-computing.de...
> Norman Dunbar wrote:
> > Morning Urs,
> >
> > try using level 4 or level 8 to show the bind variable values. I'm sorry
> > I can't remember which is correct as I always use level 12 and get binds
> > and waits in the trace as well. Most useful. :o)
> >
>
> It's level 4 for waits.
>

Hi Holger

Level 4, bind variables, level 8 waits, level 12 both.

Honest ;)

Richard Received on Wed Jun 04 2003 - 08:19:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US