ITPub博客

对table的操作进行监控

原创 Linux操作系统 作者:oracle_ace 时间:2007-12-14 14:57:49 0 删除 编辑

SQL> create table t(id int);

Table created

SQL> select * from user_tab_modifications;

TABLE_NAME                     PARTITION_NAME                 SUBPARTITION_NAME                 INSERTS    UPDATES    DELETES TIMESTAMP   TRUNCATED
------------------------------ ------------------------------ ------------------------------ ---------- ---------- ---------- ----------- ---------

SQL> alter table t monitoring;

Table altered

SQL> insert into t values(1);

1 row inserted

SQL> update t set id=1;

1 row updated

SQL> select * from user_tab_modifications;

TABLE_NAME                     PARTITION_NAME                 SUBPARTITION_NAME                 INSERTS    UPDATES    DELETES TIMESTAMP   TRUNCATED
------------------------------ ------------------------------ ------------------------------ ---------- ---------- ---------- ----------- ---------

SQL> exec DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO

PL/SQL procedure successfully completed

SQL> select * from user_tab_modifications;

TABLE_NAME                     PARTITION_NAME                 SUBPARTITION_NAME                 INSERTS    UPDATES    DELETES TIMESTAMP   TRUNCATED
------------------------------ ------------------------------ ------------------------------ ---------- ---------- ---------- ----------- ---------
T                                                                                                     1          1          0

All the process will be freshed after 20 minutes

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12361284/viewspace-590/,如需转载,请注明出处,否则将追究法律责任。

下一篇: Bitmap的问题
请登录后发表评论 登录
全部评论

注册时间:2007-12-10

  • 博文量
    284
  • 访问量
    783587