Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Index Monitoring question

Index Monitoring question

From: Singh, Ratnesh (GEI, GEFA, Contractor) <Ratnesh.Singh_at_ge.com>
Date: Wed, 25 Feb 2004 19:57:29 -0500
Message-ID: <53C7726C165C4B46B5470C1A20EDBC4A0123A527@LYHMLVEM01.e2k.ad.ge.com>


We have enabled monitoring for our indexes.

The result from V$Object_Usage shows that start_monitoring date is not null and end_monitoring date is null. This means that monitoring has been started and has not yet been stopped.

However why does column monitoring show the value as NO ? Does this mean that monitoring is not happening ?

ex :

TABLE_NAME 		 INDEX_NAME 			 MON USE START_MONITORING    END_MONITORING 

------------------ ------------------------- --- --- ------------------- -------------------
DOCMT_PCKG_ACTVTY DOCMT_PCKG_ACTVTY_ACTVTY_XFK NO NO 11/30/2003 17:56:57 thanks & regards
ratnesh

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Wed Feb 25 2004 - 18:54:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US