Is there statistics information for table queries for each table?
Hi,
We need to get statistic information on each table access, query/insert/delete/update.
I have found that Oracle provided a statistic table to get the data of insert/delete/update for each table.
select table_name,INSERTS,UPDATES,DELETES,TO_CHAR(TIMESTAMP,'YYYY-MON-DD:HH24:MI:SS') from all_tab_modifications where TABLE_NAME = 'xxx';
But I cannot find such information on table query (select operations). Is there similar statistic information on table query in Oracle?
Thanks,
Iris