Is index monitoring turned on, by default in Oracle 10g ?
I am familiar with Index Monitoring feature of Oracle db and its usage.
Recently a DBA mentioned to me that, in Oracle 10g, index monitoring is turned ON, by default when you create an index, is that correct ?
I create a small test table , with an index and then queried the v$object_usage view as the owner of that table. I did not see any row there?
I will appreciate your response on this, whether Index monitoring is ON , by default in Oracle 10g ?
Regards,
Ashish