IMPAX 6.5.1 Server Knowledge Base home > Oracle Server home > Collecting database statistics > Gathering statistics with gather_stats_job

Viewing the statistics update history

You can view a history of when gather_stats_job last updated statistics on Oracle tables.

To view the statistics update history

  1. Log in as user oracle on AS3000 or AgfaService on AS300 Oracle on Windows

  2. To login to sqlplus, type

    sqlplus / as sysdba

  3. View the statistics history by typing

    select table_name, stats_update_time from dba_tab_stats_history order by stats_update_time;

  4. To log out of sqlplus type

    exit


Topic number: 113623

Applies to: IMPAX 6.5.1 Server Knowledge Base