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 22:41:38 +1000
Message-ID: <OvlDa.49573$1s1.650111@newsfeeds.bigpond.com>


"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA703BEB37B_at_lnewton.leeds.lfs.co.uk...
> 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)
>

Hi Norman.

Level 4 would get you the bind variables values (level 8 the wait events).

Cheers

Richard Received on Wed Jun 04 2003 - 07:41:38 CDT

Original text of this message

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