| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Should we stop analyzing?
select count(*) on the PK each day and store the results for tracking.
monitor the extent usage for the table.
audit the table.
>>> Josh.Collier_at_Banfield.net 12/30/2003 12:49:33 PM >>> Is there an easy way to track the rate of change in a particular table?
-----Original Message-----
Sent: Tuesday, December 30, 2003 7:24 AM
To: Multiple recipients of list ORACLE-L
Makes sense, BUT...
"If the data changes A LOT you should of course re-analyze." is
assuming you
know when that happens. You are assuming communication between users,
developers, and DBAs. Communication is my New Year's Resolution.
I would at least suggest exporting stats before changing them. Then
there
are all the extra problems such as retaining histograms with 8i,
applications which constantly insert/delete from temporary tables (not
Oracle temp tables), ...
Henry
-----Original Message-----
>>But then I listened to Dave Ensor at the UKOUG conference, and he
said
roughly this:
the optimizer to change execution plans. * "I know that big tables tend to stay big. Small tables stay small. Unique indexes stay unique and non-unique indexes stay non-unique..." * If the data changes A LOT you should of course re-analyze.
Mogens
<<
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
INET: mln_at_miracleas.dk
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Dec 30 2003 - 12:34:33 CST
 |
 |