{"id":1181,"date":"2016-01-03T10:10:45","date_gmt":"2016-01-03T10:10:45","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1181"},"modified":"2016-01-03T10:10:45","modified_gmt":"2016-01-03T10:10:45","slug":"update-table-%eb%aa%a8%eb%8b%88%ed%84%b0%eb%a7%81","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1181","title":{"rendered":"update table \ubaa8\ub2c8\ud130\ub9c1"},"content":{"rendered":"


    \n

  1. \n
    \ucc38\uc870 \ubdf0 <\/SPAN><\/DIV>
    \n

      \n
    1. dba_tab_modifications <\/SPAN><\/LI><\/OL><\/LI>
      \n

    2. \n
      \uc0ac\uc6a9 \ubc29\ubc95 <\/SPAN><\/DIV>
      \n

        \n
      1. DBMS_STATS flush \ud6c4 \uc218\ud589 <\/SPAN><\/LI>
        \n
      2. \uc608\uc2dc: exec dbms_stats.flush_database_monitoring_info <\/SPAN><\/LI>
        \n
      3. \uc608\uc2dc: select * from dba_tab_modifications where table_owner=’SCOTT’ ; <\/SPAN><\/LI>
        \n
      4. where \uc808\uc5d0\uc11c \ud544\uc694\ud55c \uac12\uc744 \uc785\ub825 <\/SPAN><\/LI><\/OL><\/LI><\/OL>
        \n

           <\/P>
        \n

        SQL> \/ <\/SPAN><\/P>
        \n

           <\/P>
        \n

        TABLE_OWNER TABLE_NAME PARTITION_NAME SUBPARTITION_NAME INSERTS UPDATES DELETES TIMESTAMP TRU DROP_SEGMENTS <\/SPAN><\/P>
        \n

        —————————— —————————— —————————— —————————— ———- ———- ———- ——— — ————- <\/SPAN><\/P>
        \n

        SCOTT BONUS 1 0 0 29-APR-15 NO 0 <\/SPAN><\/P>
        \n

        SCOTT DEPT 1 1 0 29-APR-15 NO 0 <\/SPAN><\/P>
        \n

        SCOTT EMP 0 1 0 29-APR-15 NO 0 <\/SPAN><\/P>
        \n

           <\/P>
        \n

        SQL> select * from emp ; <\/SPAN><\/P>
        \n

           <\/P>
        \n

        EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO <\/SPAN><\/P>
        \n

        ———- ———- ——— ———- ——— ———- ———- ———- <\/SPAN><\/P>
        \n

        7369 SMITH CLERK 7902 17-DEC-80 800 20 <\/SPAN><\/P>
        \n

        7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30 <\/SPAN><\/P>
        \n

        7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30 <\/SPAN><\/P>
        \n

        7566 JONES MANAGER 7839 02-APR-81 2975 20 <\/SPAN><\/P>
        \n

        7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30 <\/SPAN><\/P>
        \n

        7698 BLAKE MANAGER 7839 01-MAY-81 2850 30 <\/SPAN><\/P>
        \n

        7782 CLARK MANAGER 7839 09-JUN-81 2450 10 <\/SPAN><\/P>
        \n

        7788 SCOTT ANALYST 7566 19-APR-87 3000 20 <\/SPAN><\/P>
        \n

        7839 KING PRESIDENT 17-NOV-81 5000 10 <\/SPAN><\/P>
        \n

        7844 TURNER SALESMAN 7698 08-SEP-81 1500 0 30 <\/SPAN><\/P>
        \n

        7876 ADAMS CLERK 7788 23-MAY-87 1100 20 <\/SPAN><\/P>
        \n

        7900 JAMES CLERK 7698 03-DEC-81 950 30 <\/SPAN><\/P>
        \n

        7902 FORD ANALYST 7566 03-DEC-81 3000 20 <\/SPAN><\/P>
        \n

        8000 MILLER CLERK 7782 23-JAN-82 1300 10 <\/SPAN><\/P>
        \n

           <\/P>
        \n

        14 rows selected. <\/SPAN><\/P>
        \n

           <\/P>
        \n

        SQL> update emp <\/SPAN><\/P>
        \n

        2 set empno=8001 <\/SPAN><\/P>
        \n

        3 where empno=8000 ; <\/SPAN><\/P>
        \n

           <\/P>
        \n

        1 row updated. <\/SPAN><\/P>
        \n

           <\/P>
        \n

        SQL> select * from dba_tab_modifications where table_owner=’SCOTT’ ; <\/SPAN><\/P>
        \n

           <\/P>
        \n

        TABLE_OWNER TABLE_NAME PARTITION_NAME SUBPARTITION_NAME INSERTS UPDATES DELETES TIMESTAMP TRU DROP_SEGMENTS <\/SPAN><\/P>
        \n

        —————————— —————————— —————————— —————————— ———- ———- ———- ——— — ————- <\/SPAN><\/P>
        \n

        SCOTT BONUS 1 0 0 29-APR-15 NO 0 <\/SPAN><\/P>
        \n

        SCOTT DEPT 1 1 0 29-APR-15 NO 0 <\/SPAN><\/P>
        \n

        SCOTT EMP 0 1 0 29-APR-15 NO 0 <\/SPAN><\/P>
        \n

           <\/P>
        \n

        SQL> commit ; <\/SPAN><\/P>
        \n

           <\/P>
        \n

        Commit complete. <\/SPAN><\/P>
        \n

           <\/P>
        \n

        SQL> select * from dba_tab_modifications where table_owner=’SCOTT’ ; <\/SPAN><\/P>
        \n

           <\/P>
        \n

        TABLE_OWNER TABLE_NAME PARTITION_NAME SUBPARTITION_NAME INSERTS UPDATES DELETES TIMESTAMP TRU DROP_SEGMENTS <\/SPAN><\/P>
        \n

        —————————— —————————— —————————— —————————— ———- ———- ———- ——— — ————- <\/SPAN><\/P>
        \n

        SCOTT BONUS 1 0 0 29-APR-15 NO 0 <\/SPAN><\/P>
        \n

        SCOTT DEPT 1 1 0 29-APR-15 NO 0 <\/SPAN><\/P>
        \n

        SCOTT EMP 0 1 0 29-APR-15 NO 0 <\/SPAN><\/P>
        \n

           <\/P>
        \n

        SQL> exec dbms_stats.flush_database_monitoring_info <\/SPAN><\/P>
        \n

           <\/P>
        \n

        PL\/SQL procedure successfully completed. <\/SPAN><\/P>
        \n

           <\/P>
        \n

        SQL> select * from dba_tab_modifications where table_owner=’SCOTT’ ; <\/SPAN><\/P>
        \n

           <\/P>
        \n

        TABLE_OWNER TABLE_NAME PARTITION_NAME SUBPARTITION_NAME INSERTS UPDATES DELETES TIMESTAMP TRU DROP_SEGMENTS <\/SPAN><\/P>
        \n

        —————————— —————————— —————————— —————————— ———- ———- ———- ——— — ————- <\/SPAN><\/P>
        \n

        SCOTT BONUS 1 0 0 29-APR-15 NO 0 <\/SPAN><\/P>
        \n

        SCOTT DEPT 1 1 0 29-APR-15 NO 0 <\/SPAN><\/P>
        \n

        SCOTT EMP 0 2 0 29-APR-15 NO 0 <\/SPAN><\/P>
        \n

           <\/P>
        \n

        SQL> <\/SPAN><\/P><\/p>\n","protected":false},"excerpt":{"rendered":"

        \ucc38\uc870 \ubdf0 dba_tab_modifications \uc0ac\uc6a9 \ubc29\ubc95 DBMS_STATS flush \ud6c4 \uc218\ud589 \uc608\uc2dc: exec dbms_stats.flush_database_monitoring_info \uc608\uc2dc: select * from dba_tab_modifications where table_owner=’SCOTT’ ; where \uc808\uc5d0\uc11c \ud544\uc694\ud55c \uac12\uc744 \uc785\ub825     SQL> \/     TABLE_OWNER TABLE_NAME PARTITION_NAME SUBPARTITION_NAME INSERTS UPDATES DELETES TIMESTAMP TRU DROP_SEGMENTS —————————— —————————— —————————— —————————— ———- ———- ———- ——— — ————- SCOTT BONUS 1 0 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[2],"tags":[671,672],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1181"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1181"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1181\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1181"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1181"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1181"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}