How about 8.1.7 ? Any chance I could trace index usage?
Saludos,
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua
-----Mensaje 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 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 <[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 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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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
[EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Veronica Levin
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
