Index usage in 8.1.6

From: Murali Menon <mjgnmenon_at_yahoo.com>
Date: Tue, 01 Apr 2003 08:58:58 -0800
Message-ID: <F001.005772E9.20030401085858@fatcity.com>

How do you monitor if the indexes are being used in 8i? Individually the tkprof and explain plans do the trick. However from a running system, how can the index usage be determined?

If the index is being used? How many times did the index get used during a specific time frame etc.

Regards

Menon

---

Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Murali Menon
  INET: mjgnmenon_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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). Received on Tue Apr 01 2003 - 10:58:58 CST