Related Tips & Info

Support Tip: DA How to check when Oracle database statistics were last updated

heathercaldwell
 
0 Likes

Database statistics are used by the database engine to optimize queries and improve performance. From time to time it is best to regenerate these statistics. On a large and very active database, this may be required weekly. This article explains how to obtain the most recent update date of the statistics from an Oracle database.

Full article: https://portal.microfocus.com/s/article/KM000006503

Labels:

Knowledge Docs
Comment List
Related
Recommended

Resources

Support
Documentation
Learning Services
CyberRes Academy
Partner Programs
Contact us
Compliance
Help
Company
Privacy Policy
Terms of Use
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Conduct
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.