Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to find index is used or not?
What should I check in v$filestat?
Do you have any query to check this?
-----Original Message-----
From: Koivu, Lisa [mailto:lkoivu_at_qode.com]
Sent: Friday, August 04, 2000 5:16 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: How to find index is used or not?
Check out v$filestat.
-----Original Message-----
From: Naik, Sandesh [ mailto:Sandesh.Naik_at_compaq.com
<mailto:Sandesh.Naik_at_compaq.com> ]
Sent: Friday, August 04, 2000 11:25 AM
To: Multiple recipients of list ORACLE-L
Subject: How to find index is used or not?
Hi All,
This might be a very simple question? but is there a way to find once
created index is used or not? I mean is there any table which tells us that
this index has not been used by any query for last so many days or months
...?
If yes, would you like to share that with me?
Thanks
-Sandesh
--
Author: Naik, Sandesh
INET: Sandesh.Naik_at_compaq.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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). Received on Tue Aug 08 2000 - 16:16:06 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message