Some of the diagnosis efforts include user processes and counts, Sar, Top, OS stats, DBstats, comparing historic stats, analyzing current events, rubuilding the analyze tables and indexes, system reboot, etc. We conclude that the user processes have had no influence on the time changes. No known database or systems changes have been identified. No new events have been linked to the build extension.
Any ideas on the fluctuating build times?
Note that DBMS_SUPPORT is not installed by default; create it by logging in as SYS and execute $ORACLE_HOME/rdbms/admin/dbmssupp.sql.
Dig Deeper on Oracle database performance problems and tuning
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.