From CTrassens@uni2.es Wed, 28 Feb 2001 02:24:48 -0800 From: "Trassens, Christian" Date: Wed, 28 Feb 2001 02:24:48 -0800 Subject: RE: dbms_stats Message-ID: MIME-Version: 1.0 Content-Type: text/plain Hi, I am using it in a DW. And the overhead isn't too noticeable. Take into account that SMON wakes up every 3 hours for this feature. However there is a bug in 8.1.6 with GATHER STALE and GATHER EMPTY with the argument of CASCADE=>TRUE. You may receive an PL/SQL error one of the 65XX refering to max buffer reached or similar. It is solved on 8.1.7. Regards. > -----Mensaje original----- > De: Lord David [SMTP:dlord@haysits.co.uk] > Enviado el: miércoles 28 de febrero de 2001 9:41 > Para: Multiple recipients of list ORACLE-L > Asunto: dbms_stats > > Hi list > > Does anyone have any tales to tell of using MONITORING and the 'GATHER > STALE' option of the dbms_stats.gather* procedures? Someone here has > suggested that we use it for a new product we're developing, but I am a > little concerned over whether the monitoring has any significant > performance > impact. > > TIA > David Lord > Senior DBA, Hays Commercial Services, IT Solutions > dlord@haysits.co.uk > > > ********************************************************************** > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please notify > the system manager. > > This footnote also confirms that this email message has been swept by > MIMEsweeper for the presence of computer viruses. > > www.mimesweeper.com > ********************************************************************** > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Lord David > INET: dlord@haysits.co.uk > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Trassens, Christian INET: CTrassens@uni2.es Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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).