From ian@SLAC.Stanford.EDU Mon, 10 Sep 2001 14:02:52 -0700 From: "MacGregor, Ian A." Date: Mon, 10 Sep 2001 14:02:52 -0700 Subject: RE: Last time an Index was used.. In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: text/plain Mpnitoring has to do with tables not indexes. There is no alter index monitoring statement in 8i. I don't know about 9i as I haven't looked at it yet. Ian MacGregor Stanford Linear Accelerator Center ian@slac.stanford.edu -----Original Message----- From: Christopher Spence [mailto:cspence@FuelSpot.com] Sent: Monday, September 10, 2001 10:45 AM To: Multiple recipients of list ORACLE-L Not much at all, you can use monitoring in Oracle 8i. Since it only writes the changes every few hours, it has very monitor impact. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -----Original Message----- Sent: Monday, September 10, 2001 11:50 AM To: Multiple recipients of list ORACLE-L Wow, that's a nice feature. Any idea what the overhead is for this (not that we'll be moving to 9i for at least a year)? Jay Miller -----Original Message----- Sent: Thursday, September 06, 2001 4:22 PM To: Multiple recipients of list ORACLE-L Under 9i MONITORING USAGE | NOMONITORING USAGE Use this clause to begin or end the collection of statistics on index usage. This clause is useful in determining whether an index is being used. Specify MONITORING USAGE to begin statistics collection. Oracle first clears existing statistics on index and then begins to collect statistics on index usage. Statistics collection continues until a subsequent ALTER INDEX ... NOMONITORING USAGE statement is executed. To terminate collection of statistics on index, specify NOMONITORING USAGE. Connor McDonald wrote: > > Not really - but you could move it into its own > tablespace and then monitor reads/write on this tspace > using v$filestat. > > hth > connor > > --- Veronica Levin wrote: > > Hi listers, > > Is there a chance I could find somehow the last time > > (date) an index was > > used???? > > Any help will be appreciated! > > > > Saludos, > > Veronica Levin Enriquez > > Administrador AIX > > Compañía Cervecera de Nicaragua > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Veronica Levin > > INET: vlevin@victoria.com.ni > > > > 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). > > ===== > Connor McDonald > http://www.oracledba.co.uk (mirrored at > http://www.oradba.freeserve.co.uk) > > "Some days you're the pigeon, some days you're the statue" > > ____________________________________________________________ > Do You Yahoo!? > Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your > free @yahoo.ie address at http://mail.yahoo.ie > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?Connor=20McDonald?= > INET: hamcdc@yahoo.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). -- Charlie Mengler Maintenance Warehouse charliem@mwh.com 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Data-free analysis results in a success-free history. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: charliem@mwh.com 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: Miller, Jay INET: JayMiller@TDWaterhouse.com 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: Christopher Spence INET: cspence@FuelSpot.com 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: MacGregor, Ian A. INET: ian@SLAC.Stanford.EDU 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).