Index usage count.
Hi,
Is it possible to know exact number of times(exact count) an index being used .Any data dictionary view/sql to view this,like to know exact index usage count as v$object_usage only shows only YES/NO .
SQL> select * from v$object_usage;
INDEX_NAME TABLE_NAME MON USE START_MONITORING END_MONITORING
------------------------------ ------------------------------ --- --- ------------------- -------------------
PK_EMP EMP YES YES 06/03/2011 04:52:24
PK_DEPT DEPT YES YES 06/03/2011 04:59:27
Thanks.
Is it possible to know exact number of times(exact count) an index being used .Any data dictionary view/sql to view this,like to know exact index usage count as v$object_usage only shows only YES/NO .
SQL> select * from v$object_usage;
INDEX_NAME TABLE_NAME MON USE START_MONITORING END_MONITORING
------------------------------ ------------------------------ --- --- ------------------- -------------------
PK_EMP EMP YES YES 06/03/2011 04:52:24
PK_DEPT DEPT YES YES 06/03/2011 04:59:27
Thanks.
0