Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Hariharan.

Asked: October 12, 2016 - 1:03 pm UTC

Last updated: October 13, 2016 - 2:08 am UTC

Version: 12.1.0.2

Viewed 1000+ times

You Asked

Hi All,

It seems that only indexes that are listed in the explain plan are monitored by index monitoring feature.

But indexes that are used for constraint checking might not be listed in explain plan and in this case the index monitoring feature fails.

Can You confirm that only indexes listed in explain plan are covered by index monitoring feature?

If so we have to accept this as a kind of 'it works as designed', isn't it?

-- I dont have test case , but this is a question
-- Please guide me further.




Thanks,



and Connor said...

That is correct. The *current* implementation of index monitoring is in effect done as parse time.

We've recognised the limitations of this, and index monitoring has been completely revamped in 12.2, so that it is done based on the index being used in *execution*.

So bear with us... a better model is coming :-)

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Thank you so much Connor

Hariharan Senthil pandiyan, October 13, 2016 - 12:28 pm UTC

Very helpful to understand the Case. Thanks once again.