您好,欢迎光临! 请 |

user_tab_modifications

作者: | 分类:Experience, Oracle | Tag:, | 评论:3 
字号:T|T
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.

顶一下
(0)
100%
踩一下
(0)
100%

原创内容,转载时请保留原文信息:
文章标题:user_tab_modifications
↑上一篇↑:
↓下一篇↓:

3 篇回应 (访客:3 篇, 博主:0 篇)

  1. robin 2009-16-11

    恩,不错.very good

    #-49楼
  2. Rix Chan 2014-20-03

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

    #-48楼
  3. Rix Chan 2014-20-03

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

    #-47楼

插入图片

NOTICE1:请申请gravatar头像,没有头像的评论可能不会被回复|头像相关帮助!