user_tab_modifications

USER_TAB_MODIFICATIONS describes modifications to all tables owned by the
current user that have been modified since the last time statistics were gathered on the

USER_TAB_MODIFICATIONS describes modifications to all tables owned by the current user that have been modified since the last time statistics were gathered on the tables. 使用User_tab_modifications来获取数据表的DML过程: 1,SQL> select * from USER_TAB_MODIFICATIONS ; no rows selected 2,  SQL>insert into test values(1,'Asher'); one row inserted 3, SQL>select * from USER_TAB_MODIFICATIONS ; no rows selected Why? just waiting for a moment,or after I've executed the procedure【dbms_stats.flush_database_monitoring_info()】,we will get the expected result. 4, SQL> exec dbms_stats.flush_database_monitoring_info(); PL/SQL procedure successfully completed. 5,SQL> select * from USER_TAB_MODIFICATIONS ; The correct result will appears.

评论 (3)

  • robin| 2009年11月16日

    恩,不错.very good

  • Rix Chan| 2014年3月20日

    是不是数据量要变动超过10%,user_tab_modifications才会记录吖?

  • Rix Chan| 2014年3月20日

    这个数据字典从几版本开始有吖?

  • 发表评论

    邮箱地址不会被公开。 必填项已用*标注