{"id":131,"date":"2017-03-12T17:29:39","date_gmt":"2017-03-12T08:29:39","guid":{"rendered":"https:\/\/dong1lkim.oboki.net\/?p=131"},"modified":"2025-08-13T22:32:38","modified_gmt":"2025-08-13T13:32:38","slug":"tibero-backgroun-processes","status":"publish","type":"post","link":"https:\/\/oboki.net\/workspace\/data-engineering\/database\/tibero\/tibero-backgroun-processes\/","title":{"rendered":"Tibero Background Processes"},"content":{"rendered":"<h3>DBWR<\/h3>\n<p>DB Buffer Cache\uc5d0 \uc800\uc7a5\ub41c \ub0b4\uc6a9\uc744 Datafile\uc5d0 \uc800\uc7a5\ud558\ub294 \ud504\ub85c\uc138\uc2a4<br \/>\nDBWR\uc740 \uae30\ubcf8\uc801\uc73c\ub85c \ud55c \ud504\ub85c\uc138\uc2a4\ub9cc \uc791\ub3d9\ud558\uc9c0\ub9cc, I\/O\uac00 \ub9ce\uc740 \uacbd\uc6b0 \ud504\ub85c\uc138\uc2a4 \uc218\ub97c \ub298\ub824 \uc131\ub2a5 \ud5a5\uc0c1 \uac00\ub2a5<\/p>\n<ul>\n<li>DB Buffer Cache\uc5d0\uc11c Datafile\ub85c \ub0b4\ub824\uc4f0\ub294 \uacbd\uc6b0\n<ul>\n<li>Checkpoint \uc2e0\ud638 \ubc1c\uc0dd<\/li>\n<li>Dirty Buffer\uac00 \uc784\uacc4\uac12\uc744 \uc9c0\ub0ac\uc744 \ub54c<\/li>\n<li>Time Out\uc774 \ubc1c\uc0dd\ud588\uc744 \ub54c<\/li>\n<li>RAC Ping\uc774 \ubc1c\uc0dd\ud588\uc744 \ub54c<\/li>\n<li>Tablespace\uac00 Read Only \uc0c1\ud0dc\ub85c \ubcc0\uacbd\ub410\uc744 \ub54c<\/li>\n<li>Tablespace\uac00 Offline\ub420 \ub54c<\/li>\n<li>Tablespace\uac00 Begin Backup \uc0c1\ud0dc\ub85c \ub420 \ub54c<\/li>\n<li>Drop table, Truncate Table \ub420 \ub54c<\/li>\n<\/ul>\n<\/li>\n<li>DB Buffer Cache\uc758 \uc138 \uac00\uc9c0 \uc0c1\ud0dc\n<ul>\n<li>Free Buffer<br \/>\n\ub36e\uc5b4\uc368\ub3c4 \uc0c1\uad00 \uc5c6\ub294 \uacbd\uc6b0(\uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc558\uac70\ub098 \uc0ac\uc6a9\ub418\uc5c8\ub354\ub77c\ub3c4 \ubcc0\uacbd\uc0ac\ud56d\uc774 \uc800\uc7a5 \ub41c \uacbd\uc6b0)<\/li>\n<li>Dirty Buffer<br \/>\n\ubcc0\uacbd\ub41c \ub370\uc774\ud130\uac00 \uc800\uc7a5\ub418\uc9c0 \uc54a\uc544 \uc808\ub300 \ub36e\uc5b4\uc4f0\uc5ec\uc11c\ub294 \uc548\ub418\ub294 \ubc84\ud37c<\/li>\n<li>Pinned Buffer<br \/>\n\uc11c\ubc84 \ud504\ub85c\uc138\uc2a4\uac00 \ud604\uc7ac \uc0ac\uc6a9\uc911\uc778 \ube14\ub85d<br \/>\n\uc704 \uc138 \uac00\uc9c0 \uc0c1\ud0dc\ub97c List\ub97c \ub9cc\ub4e4\uc5b4 \ub2e4\uc74c\uacfc \uac19\uc774 \uad00\ub9ac\ud55c\ub2e4.<\/li>\n<li>LRU List\n<ul>\n<li>\uba54\uc778\ub9ac\uc2a4\ud2b8 : \uc0ac\uc6a9\ub41c \ubc84\ud37c\ub4e4\uc758 \ub9ac\uc2a4\ud2b8, Hot \uc601\uc5ed\uacfc Cold \uc601\uc5ed<\/li>\n<li>\ubcf4\uc870\ub9ac\uc2a4\ud2b8 : \ubbf8\uc0ac\uc6a9\ub41c \ubc84\ud37c\ub4e4\uc774\ub098, DBWR\uc5d0 \uc758\ud574 \uae30\ub85d\ub41c \ubc84\ud37c \ub9ac\uc2a4\ud2b8<\/li>\n<\/ul>\n<\/li>\n<li>LRUW List(Dirty List)\n<ul>\n<li>\uba54\uc778\ub9ac\uc2a4\ud2b8 : \ubcc0\uacbd\ub41c \ubc84\ud37c\ub4e4\uc758 \ub9ac\uc2a4\ud2b8<\/li>\n<li>\ubcf4\uc870\ub9ac\uc2a4\ud2b8 : \ud604\uc7ac DBWR\uc5d0 \uc758\ud574 \uae30\ub85d\uc911\uc778 \ubc84\ud37c\ub4e4\uc758 \ub9ac\uc2a4\ud2b8<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3>LGWR<\/h3>\n<p>Redo Log Buffer\uc5d0 \uc788\ub294 \ub0b4\uc6a9\uc744 Redo Log File\ub85c \uc800\uc7a5<\/p>\n<ul>\n<li>Redo Log Buffer\uc5d0\uc11c Redo Log File\ub85c \ub0b4\ub824\uc4f0\ub294 \uacbd\uc6b0\n<ul>\n<li>Commit\uc774 \ubc1c\uc0dd\ud588\uc744 \ub54c<\/li>\n<li>1\/3\uc774 \ucc3c\uc744 \ub54c<\/li>\n<li>\ubcc0\uacbd\ub7c9\uc774 1M\uac00 \ub418\uc5c8\uc744 \ub54c<\/li>\n<li>3\ucd08\ub9c8\ub2e4<\/li>\n<li>DBWR\uc774 \ub0b4\ub824\uc4f0\uae30 \uc804\uc5d0<br \/>\nCommit\uc744 \uc218\ud589\ud558\uac8c \ub418\uba74 \ub370\uc774\ud130\ub97c \ub0b4\ub824\uc4f4\ub2e4\uae30 \ubcf4\ub2e4\ub294 Redo Log\ub97c \uc800\uc7a5\ud558\ub294 \uac83<br \/>\n\ud2b8\ub79c\uc7ad\uc158\uc774 \ubc1c\uc0dd\ud560 \ub54c\ub9c8\ub2e4 SCN \uc22b\uc790\ub97c \ub298\ub824\uac00\uba70 \uad00\ub9ac\ub97c \ud558\uace0 \uc774 \uc22b\uc790\ub97c \ud1b5\ud574 \uc7a5\uc560 \ubc1c\uc0dd\uc2dc \ubcf5\uad6c\ub3c4 \uac00\ub2a5.<\/li>\n<\/ul>\n<\/li>\n<li>SCN\uc774 \uae30\ub85d\ub418\ub294 \uacf3\n<ul>\n<li>Control File Header\n<ul>\n<li>Checkpoint \ubc1c\uc0dd \uc2dc<\/li>\n<li>Resetlogs \ubc1c\uc0dd \uc2dc<br \/>\n*Incomplete Recovery \uc218\ud589 \uc2dc<\/li>\n<\/ul>\n<\/li>\n<li>Data Blocks(Cache Layer)\n<ul>\n<li>Block Clean out \uc2dc \ub9c8\uc9c0\ub9c9 SCN\uc744 \uac01 \ube14\ub85d\uc5d0 \uae30\ub85d<\/li>\n<\/ul>\n<\/li>\n<li>Data Blocks(ITL Entries)\n<ul>\n<li>Data Block\uc758 Transaction Layer \uc548\uc5d0 \uc788\ub294 ITL(Interested Transaction List) entries\uc5d0 Commit\ub41c SCN\uc815\ubcf4\ub97c \uae30\ub85d(Delayed Block clean out)<\/li>\n<\/ul>\n<\/li>\n<li>Datafile Headers\n<ul>\n<li>\ubaa8\ub4e0 \ub370\uc774\ud130 \ud30c\uc77c \ud5e4\ub354\uc5d0 \uc544\ub798\uc758 \uacbd\uc6b0 SCN \uae30\ub85d\n<ul>\n<li>\ub9c8\uc9c0\ub9c9 Check point \ubc1c\uc0dd \uc2dc<\/li>\n<li>Begin backup \uc218\ud589 \uc2dc<\/li>\n<li>\ubcf5\uad6c\uac00 \ub418\uc5c8\ub2e4\uba74 \uc0ac\uc6a9\ub41c \ub9c8\uc9c0\ub9c9 SCN \uae30\ub85d<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li>Redo Records \/ Log Buffer\n<ul>\n<li>Commit\uc774 \uc218\ud589\ub418\uba74 Commit Record\uc5d0 SCN\uc744 \ud3ec\ud568\ud558\uc5ec \uc800\uc7a5<\/li>\n<\/ul>\n<\/li>\n<li>\uadf8 \uc678\n<ul>\n<li>Rollback Segment(Undo Segment)\uc640 Tablespace Header\uc5d0 \uae30\ub85d<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3>CKPT<\/h3>\n<p>DBWR\uc5d0\uac8c Checkpoint Signal \uc744 \ubc1c\uc0dd<br \/>\nCheckpoint\uac00 \ubc1c\uc0dd\ud558\uac8c \ub418\uba74 DB Buffer Cache\uc5d0\uc11c \uc800\uc7a5\ub418\uc9c0 \uc54a\uc740 \ube14\ub85d\uc744 DBWR\uc774 \ub370\uc774\ud130\ud30c\uc77c\ub85c \uc800\uc7a5\ud558\uace0, Redo Log Buffer\uc5d0\uc11c \uc800\uc7a5\ub418\uc9c0 \uc54a\uc740 \ub0b4\uc6a9\uc744 LGWR\uac00 \ub85c\uadf8\ud30c\uc77c\ub85c \uc800\uc7a5<\/p>\n<ul>\n<li>Checkpoint\uac00 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0\n<ul>\n<li>Log Swith\uac00 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0<\/li>\n<li>DBA\uac00 \uc218\ub3d9\uc73c\ub85c \ubc1c\uc0dd\uc2dc\ud0a4\ub294 \uacbd\uc6b0(alter system checkpoint)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>DBWR DB Buffer Cache\uc5d0 \uc800\uc7a5\ub41c \ub0b4\uc6a9\uc744 Datafile\uc5d0 \uc800\uc7a5\ud558\ub294 \ud504\ub85c\uc138\uc2a4 DBWR\uc740 \uae30\ubcf8\uc801\uc73c\ub85c \ud55c \ud504\ub85c\uc138\uc2a4\ub9cc \uc791\ub3d9\ud558\uc9c0\ub9cc, I\/O\uac00 \ub9ce\uc740 \uacbd\uc6b0 \ud504\ub85c\uc138\uc2a4 \uc218\ub97c \ub298\ub824 \uc131\ub2a5 \ud5a5\uc0c1 \uac00\ub2a5 DB Buffer Cache\uc5d0\uc11c Datafile\ub85c \ub0b4\ub824\uc4f0\ub294 \uacbd\uc6b0 Checkpoint \uc2e0\ud638 \ubc1c\uc0dd Dirty Buffer\uac00 \uc784\uacc4\uac12\uc744 \uc9c0\ub0ac\uc744 \ub54c Time Out\uc774 \ubc1c\uc0dd\ud588\uc744 \ub54c RAC Ping\uc774 \ubc1c\uc0dd\ud588\uc744 \ub54c Tablespace\uac00 Read Only \uc0c1\ud0dc\ub85c \ubcc0\uacbd\ub410\uc744 \ub54c Tablespace\uac00 Offline\ub420 \ub54c Tablespace\uac00 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-131","post","type-post","status-publish","format-standard","hentry","category-tibero"],"_links":{"self":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/131","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/comments?post=131"}],"version-history":[{"count":5,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/131\/revisions"}],"predecessor-version":[{"id":1409,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/131\/revisions\/1409"}],"wp:attachment":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/media?parent=131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/categories?post=131"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/tags?post=131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}