Ooops ....I was checking the wrong table ...I should be checking
v$object_usage.....realised this after sending the mail...
Thanks
Ravi Boppudi
-----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
This email has been scanned for all viruses by the MessageLabs SkyScan
service.
**********************************************************************************
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.
***********************************************************************************
Oracle LazyDBA home page