首页 > Linux操作系统 > Linux操作系统 > 对table的操作进行监控
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博客 ” ,链接:https://blog.itpub.net/12361284/viewspace-590/ ,如需转载,请注明出处,否则将追究法律责任。