IMPAX 6.5.1 Server Knowledge Base home > Oracle Server home > Collecting database statistics > Gathering statistics with gather_stats_job
You can view a history of when gather_stats_job last updated statistics on Oracle tables.
To view the statistics update history
Log in as user oracle on AS3000 or AgfaService on AS300 Oracle on Windows
To login to sqlplus, type
sqlplus / as sysdba
View the statistics history by typing
select table_name, stats_update_time from dba_tab_stats_history order by stats_update_time;

To log out of sqlplus type
exit
Topic number: 113623 Applies to: IMPAX 6.5.1 Server Knowledge Base |