Re: Oracle 11 - 10053 trace doesn't produce any output

From: Mladen Gogala <>
Date: 14 Mar 2008 13:27:17 GMT
Message-ID: <47da7d35$0$1341$>

On Fri, 14 Mar 2008 03:54:41 -0700, Charles Hooper wrote:

> As I am sure you are aware, it should only produce output on a hard
> parse (adding a comment to the SQL statement may not be enough to force
> a hard parse on 11g, if I recall correctly). That said, during testing
> of 11g, I found that occasionally when I attempted to enable a 10046
> trace for another session, no output was generated.
> Have you tried flushing the shared pool to see if it makes a difference?

Yes, I did. No luck.

Mladen Gogala
Received on Fri Mar 14 2008 - 08:27:17 CDT

Original text of this message