Re: How to exclude few tables while gathering a schema stats in oracle 9i
- From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
- To: p4cldba@xxxxxxxxx
- Date: Thu, 27 Dec 2007 10:43:59 -0500
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@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
