{"id":487,"date":"2012-01-30T12:31:53","date_gmt":"2012-01-30T12:31:53","guid":{"rendered":"http:\/\/brain.dailyon.net\/?p=487"},"modified":"2012-01-30T12:31:53","modified_gmt":"2012-01-30T12:31:53","slug":"oracle-%ec%9e%84%ec%8b%9c-%ed%85%8c%ec%9d%b4%eb%b8%94","status":"publish","type":"post","link":"https:\/\/blog.goorigo.com\/?p=487","title":{"rendered":"Oracle : \uc784\uc2dc \ud14c\uc774\ube14"},"content":{"rendered":"

\uc624\ub77c\ud074\uc5d0\uc11c\ub294 \uc65c MSSQL\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 \uc784\uc2dc \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uc218\uc5c6\uc744\uae4c
\n\uace0\ubbfc\ud588\ub358 \uc801\uc774 \uc788\uc5c8\uc2b5\ub2c8\ub2e4. \uc784\uc2dc\ud14c\uc774\ube14 \ub9cc\ub4e4\uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc788\uad6c\uc694.<\/p>\n

\uc784\uc2dc \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\ub418 duration\uc740 transaction\ub2e8\uc704\ub85c \ud55c\ub2e4\ub294 \uac83\uc744 \uae30\uc5b5\ud574\uc57c \ud569\ub2c8\ub2e4.
\n\uc544\ub798\uc758 \uc21c\uc11c\ub97c \ub530\ub77c \ud558\uc2dc\uba74 \uc784\uc2dc \ud14c\uc774\ube14\uc744 \ub9cc\ub4dc\uc2e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n[\ucd9c\ucc98] [Oracle] \uc784\uc2dc\ud14c\uc774\ube14 \uc0ac\uc6a9\ud558\uae30|\uc791\uc131\uc790 \uad6c\ubbf8\uc9c0\uc5d4<\/p>\n

1. \uc784\uc2dc \ud14c\uc774\ube14\uc0dd\uc131
\nSQL> create global temporary table temp_tab (col1 number, col2 char(15))
\non commit delete rows ;<\/p>\n

 <\/p>\n

drop table\u00a0temp_tab;<\/p>\n

–> on commit delete rows \ub97c \uc798 \uae30\uc5b5\ud574 \ub450\uc138\uc694.
\n[Commit \uc744 \ud558\uba74 \uc0ad\uc81c\uc791\uc5c5\uc744 \ud558\ub294\uac83\uc73c\ub85c \uc124\uc815\ud55c\ub2e4\ub294 \ub9d0\uc785\ub2c8\ub2e4.]<\/p>\n

2. \uc784\uc2dc \ud14c\uc774\ube14\uc5d0 \uc778\ub371\uc2a4 \ub9cc\ub4e4\uae30
\nSQL> create index temp_tab_n1 on temp_tab(col1);<\/p>\n

3. \uc784\uc2dc \ud14c\uc774\ube14\uc5d0 \ub370\uc774\ud130 \uc778\uc11c\ud2b8
\nSQL> insert into temp_tab values ( 1 , ‘\uad6c\ubbf8\uc9c0\uc5d4’) ;<\/p>\n

\u2605 \uc8fc\uc758 : Insert\/Update \ud588\ub2e4\uace0 Commit \ud558\uc2dc\uba74 \uc548\ub429\ub2c8\ub2e4.<\/p>\n

4. \uc784\uc2dc \ud14c\uc774\ube14\uc5d0\uc11c \ub370\uc774\ud130 \uac00\uc838\uc624\uae30
\nSQL> select * from temp_tab ;
\nCOL1 COL2
\n——— ————
\n1 \uad6c\ubbf8\uc9c0\uc5d4<\/p>\n

5. \uc784\uc2dc \ud14c\uc774\ube14 \uad00\ucc30
\n\uc0dd\uae40\uc0c8\ub97c \uc790\uc138\ud788 \ubcf4\uc2dc\ub824\uba74 \ud1a0\ub4dc(Toad)\uc5d0\uc11c desc temp_tab \ud558\uc2dc\uace0<\/p>\n

\uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc0b4\ud3b4\ubcf4\uc2dc\uba74 \uae30\uc874\uc5d0\ub294 \uc788\ub358 Tablespace \uad6c\uc808\uc774 \ube60\uc838 \uc788\ub294\uac83\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n\uc774\ub294 \uc784\uc2dc\ud14c\uc774\ube14\uc774\ub098 \uc778\ub371\uc2a4\uac00 \uba54\ubaa8\ub9ac\uc5d0 \uc0dd\uc131\ub41c\ub2e4\ub294 \uac83\uc744 \ub9d0\ud569\ub2c8\ub2e4.
\nDBA \uc5c5\ubb34 \ud558\uc2dc\ub294 \ubd84\ub4e4\uc740 \ub2e4\uc774\ub098\ubbf9 \ud37c\ud3ec\uba3c\uc2a4 \ubdf0 \ubcf4\uc2dc\uba74(user_objects \ub4f1) \uc54c\uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

6. \uc784\uc2dc \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130\ub97c \uba54\ubaa8\ub9ac\uc5d0\uc11c \ub0b4\ub9ac\uae30
\nSQL> commit ;
\nCommit complete.<\/p>\n

7. \uc784\uc2dc \ud14c\uc774\ube14\uc744 \ub2e4\uc2dc \ubcf4\uba74
\nduration\uc774 transaction\ub2e8\uc704\uc774\uae30 \ub54c\ubb38\uc5d0 commit\uc744 \uc218\ud589\ud558\uba74 \ubaa8\ub4e0 data\uac00 \uc0ac\ub77c\uc9d1\ub2c8\ub2e4.<\/p>\n

\uc77c\ubc18\uc801\uc73c\ub85c, Customizing Tablespace \uc5d0 \ub9cc\ub4e4\uc5b4 \ub454 \uc601\uad6c\ud14c\uc774\ube14\ub4e4\uc740
\n\ub808\ud3ec\ud2b8\uac00 \uc2e4\ud589 \ub420\ub54c\ub9c8\ub2e4 \ud14c\uc774\ube14\uc5d0 \ub370\uc774\ud130\uac00 \uacc4\uc18d \uc313\uc774\uac70\ub098
\n\ud14c\uc774\ube14\uc758 \ub0b4\uc6a9\uc744 \ubaa8\ub450 \uc9c0\uc6b0\uac70\ub098 Truncate \ud55c\ud6c4
\n\ub370\uc774\ud130\ub97c \ub2e4\uc2dc \uc785\ub825\ud558\ub294 \ubc88\uac70\ub7ec\uc6c0\uc774 \uc788\ub294 \uc904\ub85c \uc555\ub2c8\ub2e4.<\/p>\n

\uadf8\ub54c \ub9c8\ub2e4\uc758 \ubb3c\ub9ac\uc801\uc778 I\/O(\uc0ad\uc81c\uc791\uc5c5 \uc2dc) \ubc1c\uc0dd\uc740 \uc11c\ubc84\uc5d0 \uc0c1\ub2f9\ud55c \ubd80\ud558\ub97c \uc8fc\uaca0\uc8e0<\/p>\n

(\ubb3c\ub860 \ub370\uc774\ud130 \uc218\uc2ed\uac74 \ucc98\ub9ac\ud558\ub294 \ud2b8\ub79c\uc7ad\uc158\uc774\ub77c\uba74 \ubd80\ud558\ub97c \uc8fc\uc9c4 \uc54a\uaca0\uc8e0. )<\/p>\n

\uadf8\ub798\uc11c \uba54\ubaa8\ub9ac\ub97c \uc0ac\uc6a9\ud558\uba74 \ubb3c\ub9ac\uc801\uc778 I\/O \uac00 \uba54\ubaa8\ub9ac\uc5d0\uc11c \ubc1c\uc0dd\ud558\ubbc0\ub85c<\/p>\n

\ub2e4\ub978 \uc0ac\uc6a9\uc790 \ud2b8\ub79c\uc7ad\uc158\uc5d0 \uc601\ud5a5\uc744 \uac70\uc758 \uc8fc\uc9c0 \uc54a\uaca0\uc8e0.
\n\ub610\ud558\ub098 , Disk \ubcf4\ub2e4\ub294 \uba54\ubaa8\ub9ac\uc758 \uc18d\ub3c4\uac00 \ube60\ub974\ub2e4.<\/p>\n

\uc704\uc758 \uc77c\ubc18\uc801\uc778 \ubc29\ubc95\uacfc \uc784\uc2dc\ud14c\uc774\ube14 \uc0ac\uc6a9\uc5d0\ub294 \uc11c\ub85c \uc7a5\ub2e8\uc810\uc774 \uc788\uaca0\uc2b5\ub2c8\ub2e4\ub9cc,
\n\uc2e4\ud589 \uc18d\ub3c4\ub294 \ube44\uad50\uac00 \uc548\ub418\uaca0\uc8e0.(\uc81c \uc0dd\uac01)<\/p>\n

\ucd9c\ucc98 : http:\/\/iceken.egloos.com\/3808926<\/p>\n","protected":false},"excerpt":{"rendered":"

\uc624\ub77c\ud074\uc5d0\uc11c\ub294 \uc65c MSSQL\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 \uc784\uc2dc \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uc218\uc5c6\uc744\uae4c \uace0\ubbfc\ud588\ub358 \uc801\uc774 \uc788\uc5c8\uc2b5\ub2c8\ub2e4. \uc784\uc2dc\ud14c\uc774\ube14 \ub9cc\ub4e4\uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc788\uad6c\uc694. \uc784\uc2dc \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\ub418 duration\uc740 transaction\ub2e8\uc704\ub85c \ud55c\ub2e4\ub294 \uac83\uc744 \uae30\uc5b5\ud574\uc57c \ud569\ub2c8\ub2e4. \uc544\ub798\uc758 \uc21c\uc11c\ub97c \ub530\ub77c \ud558\uc2dc\uba74 \uc784\uc2dc \ud14c\uc774\ube14\uc744 \ub9cc\ub4dc\uc2e4… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/487"}],"collection":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=487"}],"version-history":[{"count":0,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/487\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=487"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=487"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=487"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}