SQL>
SQL> desc dba_tab_modifications
ERROR:
ORA-04043: object dba_tab_modifications does not exist

bcm@bcm-laptop:~$ sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 13 21:43:25 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Enter user-name: / as sysdba

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> desc dba_tab_modifications
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 TABLE_OWNER					    VARCHAR2(30)
 TABLE_NAME					    VARCHAR2(30)
 PARTITION_NAME 				    VARCHAR2(30)
 SUBPARTITION_NAME				    VARCHAR2(30)
 INSERTS					    NUMBER
 UPDATES					    NUMBER
 DELETES					    NUMBER
 TIMESTAMP					    DATE
 TRUNCATED					    VARCHAR2(3)
 DROP_SEGMENTS					    NUMBER

SQL> desc all_tab_modifications
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 TABLE_OWNER					    VARCHAR2(30)
 TABLE_NAME					    VARCHAR2(30)
 PARTITION_NAME 				    VARCHAR2(30)
 SUBPARTITION_NAME				    VARCHAR2(30)
 INSERTS					    NUMBER
 UPDATES					    NUMBER
 DELETES					    NUMBER
 TIMESTAMP					    DATE
 TRUNCATED					    VARCHAR2(3)
 DROP_SEGMENTS					    NUMBER

CREATE PUBLIC SYNONYM dba_tab_modifications FOR sys.dba_tab_modifications;

SQL> set lines 1000
SQL> set pagesize 10000
SQL> select table_owner,table_name,inserts,updates,deletes,timestamp 
from all_tab_modifications 
where table_owner='RIM' and table_name='DRAFT_TAB';
TABLE_OWNER	TABLE_NAME	INSERTS	UPDATES	DELETES	TIMESTAMP
RIM	DRAFT_TAB	79359	1076839	0	14-Dec-11
RIM	DRAFT_TAB	346	231	0	13-Dec-11
RIM	DRAFT_TAB	2158	2246	0	14-Dec-11
RIM	DRAFT_TAB	647	1785	0	14-Dec-11
RIM	DRAFT_TAB	6937	264719	0	14-Dec-11
RIM	DRAFT_TAB	611	191	0	13-Dec-11
RIM	DRAFT_TAB	11	4	0	14-Dec-11
RIM	DRAFT_TAB	498	2776	0	14-Dec-11
RIM	DRAFT_TAB	87	328	0	13-Dec-11
RIM	DRAFT_TAB	904	336	0	13-Dec-11
RIM	DRAFT_TAB	48	89	0	13-Dec-11
RIM	DRAFT_TAB	514	49762	0	13-Dec-11
RIM	DRAFT_TAB	24	9	0	14-Dec-11
RIM	DRAFT_TAB	233	149	0	14-Dec-11
RIM	DRAFT_TAB	497	150	0	13-Dec-11
RIM	DRAFT_TAB	6	8	0	14-Dec-11
RIM	DRAFT_TAB	15	9	0	13-Dec-11

select table_owner,table_name,inserts,updates,deletes,timestamp 
from all_tab_modifications 
where table_owner='RIM' and table_name='DRAFT_TAB';

drop user jon cascade;
grant dba to join identified by jon;
conn jon/jon

create table parts(c1 number) partition by range(c1)
(partition p1 values less than (10),
partition p2 values less than (20));

exec dbms_stats.gather_table_stats('JON','PARTS')


select table_name,partition_name,inserts,updates,deletes
from user_tab_modifications;

insert into parts values(5);
insert into parts values(15);

exec dbms_Stats.flush_database_monitoring_info

select table_name,partition_name,inserts,updates,deletes
from user_tab_modifications;

exec dbms_stats.gather_table_stats('JON','PARTS')

select table_name,partition_name,inserts,updates,deletes
from user_tab_modifications;

mkr02@ORA11GMK> create table foo (a number)
  2  /

Table created.

Elapsed: 00:00:02.94

mkr02@ORA11GMK> exec dbms_stats.gather_table_stats(ownname=>'MKR02',tabname=>'FOO')

PL/SQL procedure successfully completed.

Elapsed: 00:00:01.42

mkr02@ORA11GMK> insert into foo values (101)
  2  /

1 row created.

Elapsed: 00:00:00.10
mkr02@ORA11GMK> commit;

Commit complete.

Elapsed: 00:00:00.00
mkr02@ORA11GMK> BEGIN 
2 dbms_stats.flush_database_monitoring_info;
3 END;
4  /

PL/SQL procedure successfully completed.

Elapsed: 00:00:02.02
mkr02@ORA11GMK> select table_name, inserts, updates, deletes from dba_tab_modifications where table_name = 'FOO'
  2  /

TABLE_NAME                        INSERTS    UPDATES    DELETES
------------------------------ ---------- ---------- ----------
FOO                                     1          0          0

Elapsed: 00:00:00.01
mkr02@ORA11GMK> begin
  2  for i in 1..1000 loop
  3  update foo set a=101;
  4  end loop;
  5  end;
  6  /

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.13
mkr02@ORA11GMK> commit
  2  /

Commit complete.

Elapsed: 00:00:00.00
mkr02@ORA11GMK> BEGIN 
2 dbms_stats.flush_database_monitoring_info;
3 END;
4  /

PL/SQL procedure successfully completed.

Elapsed: 00:00:02.02
mkr02@ORA11GMK> select table_name, inserts, updates, deletes from dba_tab_modifications where table_name = 'FOO'
  2  /

TABLE_NAME                        INSERTS    UPDATES    DELETES
------------------------------ ---------- ---------- ----------
FOO                                     1       1000          0

Elapsed: 00:00:00.00