Re: parameters in dbms_stats
- From: "Jost," Jörg <Joerg.Jost@xxxxxxxxxxxx>
- To: Ajeet.Ojha@xxxxxx
- Date: Thu, 01 Apr 2010 11:02:03 +0200
On Thu, 2010-04-01 at 13:17 +0530, Ojha, Ajeet (GE Healthcare,
consultant) wrote:
> Hello All
>
>
>
> What is the menaing of two parameters used in
> dbms_stats.gather_table_stats
>
>
>
> 1) NO_INVALIDATE
>
> 2) FORCE
>
Hi,
1) means that all parsed entries in the shared pool are still valid.
This is not the default.
2) means that you override statistics, which are marked as persistant.
This is also not the default.
The use of no_invalidate is the possibility to gather new stats without
hurting the running system. You avoid probably a lot of hard parses with
this parameter.
The second is just the possibility to change persistant stats. This is
of course necessary to generate new persistant ones :) The second is in
use on my site because of some trouble with histogramms. But that is
another story.
hth
Jörg
Other related posts:
