DBMS_UTILITY
This package provides various utility subprograms.
Procedures
The most relevant procedures are:
ANALYZE_SCHEMA
: analyzes all the tables, indexes, and clusters in a schemaANALYZE_DATABASE
: analyzes all the tables, indexes, and clusters in a databaseGET_TIME
: returns the current time in hundredths of a second
Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.