v$mystat中查看/*+ append */起作用了吗?

来源:互联网 发布:知乎 暴利 编辑:程序博客网 时间:2024/06/03 15:33
u1@ORCL> select m.SID,s.NAME,m.VALUE from v$mystat m,v$statname s where m.STATISTIC#=s.STATISTIC# and name like '%physical writes direct%';       SID NAME                                                              VALUE---------- ------------------------------------------------------------ ----------       125 physical writes direct                                             1013       125 physical writes direct temporary tablespace                           0       125 physical writes direct (lob)                                          0u1@ORCL> insert into tt select * from t;已创建71117行。u1@ORCL> select m.SID,s.NAME,m.VALUE from v$mystat m,v$statname s where m.STATISTIC#=s.STATISTIC# and name like '%physical writes direct%';       SID NAME                                                              VALUE---------- ------------------------------------------------------------ ----------       125 physical writes direct                                             1013       125 physical writes direct temporary tablespace                           0       125 physical writes direct (lob)                                          0u1@ORCL> insert /*+ append */ into tt select * from t;已创建71117行。u1@ORCL> select m.SID,s.NAME,m.VALUE from v$mystat m,v$statname s where m.STATISTIC#=s.STATISTIC# and name like '%physical writes direct%';       SID NAME                                                              VALUE---------- ------------------------------------------------------------ ----------       125 physical writes direct                                             2026       125 physical writes direct temporary tablespace                           0       125 physical writes direct (lob)                                          0u1@ORCL> insert /*+append*/ into tt select * from t;insert /*+append*/ into tt select * from t                        *第 1 行出现错误:ORA-12838: 无法在并行模式下修改之后读/修改对象u1@ORCL> rollback;回退已完成。u1@ORCL> insert /*+append*/ into tt select * from t;已创建71117行。u1@ORCL> select m.SID,s.NAME,m.VALUE from v$mystat m,v$statname s where m.STATISTIC#=s.STATISTIC# and name like '%physical writes direct%';       SID NAME                                                              VALUE---------- ------------------------------------------------------------ ----------       125 physical writes direct                                             3039       125 physical writes direct temporary tablespace                           0       125 physical writes direct (lob)                                          0u1@ORCL> rollback;回退已完成。