Re: 9.2.0.5 seems does not have the same statistics as 9.2.0.3?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 13 Jul 2005 05:59:43 +0000 (UTC)
Message-ID: <db2akf$cn1$1@nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com>

"chao_ping" <zhuchao_at_gmail.com> wrote in message news:1121226042.040470.16670_at_g47g2000cwa.googlegroups.com...
> You are right! Thanks very much.
> One more question, I checked _rowsource_execution_statistics in both
> 9203/9205, they are both false. and statistics_level = typical.
>
>
> So by accident oracle seems enabled rowsource_execution_statistics and
> disabled it again in 9205. Is there a known bug for this?
>
> Thanks
>

The "bug" is that 9.2.0.3 (and various other versions) enables _rowsource_execution_statistics when you enable sql_trace. I believe this was intentional. But the overhead did cause people to complain, which is why I assume this was stopped in 9.2.0.5

-- 
Regards

Jonathan Lewis

Now waiting on the publishers:    Cost Based Oracle - Volume 1

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 8th July 2005

Received on Wed Jul 13 2005 - 00:59:43 CDT