Re: TIMED STATISTICS Impact on perf

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Tue, 4 Jun 2002 05:47:39 +1000
Message-ID: <adgh58$d8q$1@lust.ihug.co.nz>

Put it this way: if you notice, or can measure, the impact of setting it to TRUE, then your database is so badly tuned, and so desperately in need of some decent diagnosis and fixing, that you can't afford NOT to set it to true.

There was an horrendous bug in (I think) 8.1.6 that meant setting it to true prevented any cursor sharing at all, but that's long since been fixed. For any reasonably-functional database, the impact is utterly negligible, especially compared to potential benefits.

Regards
HJR "Alain" <athiery_at_ais-nantes.fr> wrote in message news:3cfb8d32$0$399$626a54ce_at_news.free.fr...
> What is the impact to set timed_statictics to TRUE
> on an Oracle 8.1.7
>
> ALAN
>
>
Received on Mon Jun 03 2002 - 14:47:39 CDT