Oracle - Table Statistics

Wojtek Bialek - Dataedo Team Wojtek Bialek 10th October, 2024

Imported Statistics

Statistics Is imported Description
Row count Indicates the number of rows in table
Last user query -
Number of user queries -
Last user update Time of last user update
Number of user updates Number indicated sum of inserts, updates and delets done on table
Last load time -

Requirements

Dataedo requires access to the following tables and views:

  • all_tables
  • all_tab_partitions
  • all_tab_modifications

Limitations

  • Statistics in Oracle are not gathered continuously but are instead collected at scheduled intervals. As a result, after importing data, the statistics may not immediately reflect the current state of the database, potentially leading to discrepancies.

Learn more

Read more about table statistics import in main article