RE: Question On Statistics Gathering

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Fri, 27 Jun 2003 13:38:13 -0700
Message-ID: <F001.005BB61D.20030627131441@fatcity.com>

not much experience
yes it will, but in 8i the rate at which the stats were updated in the DD was *slow*, in 9i it is on demand or 5 minutes I think.

Raj

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----

From: Meng, Dennis [mailto:[EMAIL PROTECTED]] Sent: Friday, June 27, 2003 4:34 PM
To: Multiple recipients of list ORACLE-L Subject: Question On Statistics Gathering

Hi All,
Currently we have a very large database ( 8.1.7.4 ) on Tru64 that is having query optimization problems. Lacking good, up-to-date statistics is the main cause of it. Because of the size and availability window we can't afford to analyze the whole schema. Now 8i has

a new feature that only gathers stats when stale. You have to set table to monitoring mode first. I am intrigued by this new feature and am reading up on it and have 2 questions: 1. How reliable and bug-free is this feature? 2. We do a lot of sqlldr direct path, which bypasses table insert. Will this feature catch the rows inserted that way?

TIA
Dennis

*********************************************************************This e-mail

message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank

you.*********************************************************************1

Received on Fri Jun 27 2003 - 15:38:13 CDT