dba_tab_modifications

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Thu, 11 Aug 2005 12:37:10 -0400
Message-ID: <f09dd6280508110937645a1bcb@mail.gmail.com>

Hi:

I did gather statistcs for dictinary segments and fixed objects however still I
see values in dba_tab_modificaions as below. As per definition, only stale objects should be displayed in dba_tab_modifications. Please correct me if I am
wrong?

SQL> exec dbms_stats.gather_dictionary_stats; PL/SQL procedure successfully completed.

SQL> exec DBMS_STATS.GATHER_FIXED_OBJECTS_STATS; PL/SQL procedure successfully completed.

SQL> select table_owner,table_name,inserts,updates,deletes from dba_tab_modifica
tions order by inserts desc;

TABLE_OWNER TABLE_NAME INSERTS UPDATES DELETES

------------- ---------------- --------- ---------- ----------
SYS WRH$_LATCH 8352 0 0
SYS WRH$_SYSSTAT 7584 0 0

SYS WRH$_PARAMETER 6192 0 0
SYS WRH$_SQLBIND 5426 0 0 [truncated the output for display purpose]

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 11 2005 - 11:39:13 CDT