RE: Last time an Index was used..

From: Weaver, Walt <wweaver_at_rightnow.com>
Date: Thu, 06 Sep 2001 11:52:40 -0700
Message-ID: <F001.00385B88.20010906115854@fatcity.com>

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: vlevin_at_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_at_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: Weaver, Walt
INET: wweaver_at_rightnow.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