Optimizer Stats collection for Datawarehouses

From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Wed, 18 Nov 2009 19:37:01 -0800 (PST)
Message-ID: <37059.10709.qm_at_web51303.mail.re2.yahoo.com>

Does anybody has any best practices followed for Database stats in 9i /10g ?  Any suggestion or point that can be used like storing stats or adding monitoring clause or so  that it can help in automating/writing some procedure to optimize it. One example is that if there monthly partition table containing several Gig data and when new partition created and utiliZed can experience some performance slowness on the first day of the month. and so TIA Sanjay
Received on Wed Nov 18 2009 - 21:37:01 CST

Original text of this message