Home » RDBMS Server » Server Administration » Table not showing dba_tab_modifications(10g) (oracle 10.2.0.3 )
Table not showing dba_tab_modifications(10g) [message #377402] Mon, 22 December 2008 15:49 Go to next message
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 Go to previous messageGo to next message
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.
Re: Table not showing dba_tab_modifications(10g) [message #377448 is a reply to message #377404] Tue, 23 December 2008 01:54 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback.
Next time before posting, Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel
Previous Topic: ORA-12560
Next Topic: Segment shirnk
Goto Forum:
  


Current Time: Sun Dec 04 00:30:27 CST 2016

Total time taken to generate the page: 0.34580 seconds