On the Alert Display, I am getting the following: "Object Name - Optimizer (Missing statistics)." How can I eliminate this? What do I have to update to correct this condition, and how do I go about this? Please advise.
The optimizer is missing statistics that it needs in order to make informed decisions. The DBMS_STATS package can be used to calculate statistics on these objects. There are many options with the DBMS_STATS package, so I would suggest looking at the Oracle documentation to determine how to best use this supplied package:
Dig deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.