| Table not showing dba_tab_modifications(10g) [message #377402] |
Mon, 22 December 2008 15:49  |
sonumalhi
Messages: 62
Registered: April 2008
|
Member |
|
|
Experts
I have created one test table and inserted some rows.I have analyzed the table and again inserted some rows in the table.I would like to check the the number of inserts from dba_tab_modifications table.
But this table is not shown in the dba_tab_modifications table.
I have checked the monitoring is also enabled as it is enabled default in 10g.
Is there anything I am missing ?
SQL> create table test3 (a number);
Table created.
SQL> insert into test3 values(1);
1 row created.
SQL> analyze table test3 compute statistics;
Table analyzed.
SQL> insert into test3 values(2);
1 row created.
SQL> insert into test3 values(3);
1 row created.
SQL> commit;
Commit complete.
SQL> conn / as sysdba
Connected.
SQL> select * from dba_tab_modifications where table_name='TEST3';
no rows selected
SQL> select owner,table_name,last_analyzed ,monitoring from dba_Tables where table_name='TEST3';
OWNER TABLE_NAME
------------------------------ ------------------------------
LAST_ANALYZED MON
------------------- ---
PDCAMAC TEST3
2008-12-22 15:43:39 YES
SQL> select * from dba_tab_modifications where table_name='TEST3';
no rows selected
SQL> select count(*) from pdcamac.test3;
COUNT(*)
----------
3
Thanks in Advance.
Mehtab
|
|
|
|
| Re: Table not showing dba_tab_modifications(10g) [message #377404 is a reply to message #377402] |
Mon, 22 December 2008 16:09  |
sonumalhi
Messages: 62
Registered: April 2008
|
Member |
|
|
Just searched liitle bit and found the following..
I would have searched before posting......
Note:
This view is populated only for tables with the MONITORING attribute. It is intended for statistics collection over a long period of time. For performance reasons, the Oracle Database does not populate this view immediately when the actual modifications occur. Run the FLUSH_DATABASE_MONITORING_INFO procedure in the DIMS_STATS PL/SQL package to populate this view with the latest information. The ANALYZE_ANY system privilege is required to run this procedure.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
