IMPAX 6.5.1 Server Knowledge Base home > Oracle Server home
After the database is started on the new system, run the commands described in this topic to update the statistics.
To update the database statistics
Log into the Database Server.
Start an sqlplus session by typing
sqlplus / as sysdba
Type the following command:
exec dbms_scheduler.run_job('gather_stats_job');
Errors from running gather_stats_job are logged to the Oracle alert log. On Solaris systems, the alert log is located at /usr/mvf/data/logs/oracle/bdump/alert_MVF.log. On Windows systems, the alert log is located at c:\mvf\data\logs\oracle\bdump\alert_MVF.log.
Type the following command:
exec dbms_scheduler.run_job('dbadmin.gather_and_lock_stats_job');
On Solaris systems, the log file for this job is located in /usr/mvf/data/logs/gather_and_lock_stats.log. On Windows, the log file can be found in C:\mvf\data\logs\gather_and_lock_stats.log.
Topic number: 10194 Applies to: IMPAX 6.5.1 Server Knowledge Base |