不同应用的用户，需要登录到特定的用户下进行索引的监控：
CONN TESTY/TESTY
ALTER INDEX TE_ID MONITORING USAGE;ALTER INDEX TE_ID NOMONITORING USAGE;
SQL> SELECT * FROM V$OBJECT_USAGE;
INDEX_NAME------------------------------------------------------------TABLE_NAME MONITO USED------------------------------------------------------------ ------ ------START_MONITORING END_MONITORING-------------------------------------- --------------------------------------TE_IDTE YES NO07/15/2011 17:21:13
SQL> SELECT * FROM TESTY.TE 2 WHERE ID=3;
ID---------- 3
SQL> SELECT * FROM V$OBJECT_USAGE;
INDEX_NAME------------------------------------------------------------TABLE_NAME MONITO USED------------------------------------------------------------ ------ ------START_MONITORING END_MONITORING-------------------------------------- --------------------------------------TE_IDTE YES YES07/15/2011 17:21:13


CONN TESTY/TESTY
ALTER INDEX TE_ID MONITORING USAGE;
SQL> SELECT * FROM V$OBJECT_USAGE;
INDEX_NAME------------------------------------------------------------TABLE_NAME MONITO USED------------------------------------------------------------ ------ ------START_MONITORING END_MONITORING-------------------------------------- --------------------------------------
TE_IDTE YES NO07/15/2011 17:21:13
SQL> SELECT * FROM TESTY.TE
2 WHERE ID=3;
ID
----------
3
SELECT * FROM V$OBJECT_USAGE;
INDEX_NAME------------------------------------------------------------TABLE_NAME MONITO USED------------------------------------------------------------ ------ ------START_MONITORING END_MONITORING-------------------------------------- --------------------------------------
TE_IDTE YES YES07/15/2011 17:21:13