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
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.
Mpnitoring has to do with tables not indexes. There is no alter index index_name
monitoring statement in 8i. I don't know about 9i as I haven't looked at it yet.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
From: Christopher Spence
original-
De: Charlie Mengler [mailto:[EMAIL PROTECTED]]
Enviado el: Jueves, 06 de Septiembre de 2001 02:22 p.m.
Para: Multiple recipients of list ORACLE-L
Asunto: Re: Last time an Index was used..
Under 9i
MONITORING USAGE | NOMONITORING USAGE
Use this clause to begin or end the collection
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
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 [EMAIL PROTECTED] wrote:
Hi listers,
Is there a chance I could find somehow the last time
(date) an index was
used
Any help will be
You mean the last time the index was accessed by a query or the last time
the index was modified?
You probably mean the first one, but just in case you mean the second one
here's a query I use for tables. It can be modified for indexes by changing
type# to 1, I believe.
--Walt Weaver
Bozeman,
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
recipients of list ORACLE-L
Asunto: Re: Last time an Index was used..
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