Database Administration (MOSC)

MOSC Banner

Is index monitoring turned on, by default in Oracle 10g ?

edited Oct 9, 2009 7:45AM in Database Administration (MOSC) 3 commentsAnswered ✓
 Folks,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center