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, Montana, USA
======================
set lines 150
select substr(o.NAME,1,20) "Table Name",
substr(u.name,1,12) "Owner",
to_char(o.CTIME,'DD-MON-YYYY HH:MI:SS') "Created",
to_char(o.MTIME,'DD-MON-YYYY HH:MI:SS') "Modified"
from sys.obj$ o, sys.user$ u
where o.name = upper('&table_name')
and o.type# = 2
and o.owner# = u.user#
and u.name = upper('&table_owner')
/
-----Original Message-----
Sent: Thursday, September 06, 2001 1:11 PM
To: Multiple recipients of list ORACLE-L
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Weaver, Walt
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).
