Re: How to exclude few tables while gathering a schema stats in oracle 9i

my preferred way is to gather stats only on stale objects, that is -- using 'gather stale' option

then, in 9i, you just don't enable monitoring on large tables so those will never became stale

fyi in 10g there is an ability to lock stats

On Dec 24, 2007 3:46 PM, Prasad <p4cldba_at_gmail.com> wrote:
> All,
>
> I need to do a stats generation for a oracle 9i db schema everynight.
> but there are few very large tables which I want to exclude while gathering
> the schema stats.
>
> Can someone please direct me how i can achieve this in Oracle 9i .
>
> Thanks
> _Prasad
>

-- 
Alex Fatkulin,
The Pythian Group,
http://www.pythian.com/blogs/author/alexf
--
http://www.freelists.org/webpage/oracle-l