Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center