In 9i there is a View called v$db_object_usgae which will give u details
about Index Usage ..
HTH
Cheers,
Ganesh R
-----Original Message-----
From: Boppudi Ravi
[mailto:oracledba-ezmlmshield-x3413462.[Email address protected]
Sent: 30 June 2004 13:49
To: LazyDBA Discussion
Subject: Question on Index Monitoring
Hi All,
Can any one please tell me which column to look in DBA_INDEXES to see if
the index is being used or not. I read the columns list of DBA_INDEXES in
RTFM but I did not find what I was looking. I have enabled monitoring usage
for all the indexes. Thanks Ravi Boppudi.
****************************************************************************
******
This email and any files transmitted with it are confidential, and may be
subject to legal privilege, and are intended solely for the use of the
individual or entity to whom they are addressed.
If you have received this email in error or think you may have done so, you
may not peruse, use, disseminate, distribute or copy this message. Please
notify the sender immediately and delete the original e-mail from your
system.
Computer viruses can be transmitted by e-mail. Recipients should check this
e-mail for the presence of viruses. The Capita Group and its subsidiaries
accept no liability for any damage caused by any virus transmitted by this
e-mail.
****************************************************************************
*******
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: send a blank email to oracledba-[Email address protected]
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
------------------------------------------------------------------------
For more information about Barclays Capital, please
visit our web site at http://www.barcap.com.
Internet communications are not secure and therefore the Barclays
Group does not accept legal responsibility for the contents of this
message. Although the Barclays Group operates anti-virus programmes,
it does not accept responsibility for any damage whatsoever that is
caused by viruses being passed. Any views or opinions presented are
solely those of the author and do not necessarily represent those of the
Barclays Group. Replies to this email may be monitored by the Barclays
Group for operational or business reasons.
------------------------------------------------------------------------
Oracle LazyDBA home page