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: Holger Baer <holger.baer_at_science-computing.de>
Date: Wed, 04 Jun 2003 14:36:44 +0200
Message-ID: <3EDDE7DC.5020109@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)
>
> Cheers,
> Norman.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>

It's level 4 for waits.

Cheers
Holger Received on Wed Jun 04 2003 - 07:36:44 CDT

Original text of this message

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