Re: Oracle 11 - 10053 trace doesn't produce any output
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: 14 Mar 2008 13:27:17 GMT
Message-ID: <47da7d35$0$1341$834e42db@reader.greatnowhere.com>
Date: 14 Mar 2008 13:27:17 GMT
Message-ID: <47da7d35$0$1341$834e42db@reader.greatnowhere.com>
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 http://mgogala.freehostia.comReceived on Fri Mar 14 2008 - 08:27:17 CDT