Enabling Index monitoring on 19c - Overheads?
Hi all
We have a 19c database that we have inherited. There are appx three thousand indices belonging to application schemas and we are trying to determine if we need all these indices and remove the ones we don't. We are planning to use the index monitoring feature and enable it on those indices and let the system run for a few weeks and then assess which ones we can remove. We wanted to ask if there is any overhead of enabling this feature? Is there any downside to that? Anything we need to be aware of / pay attention to?