\n<\/li>\n<\/ul>\n
\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc784\uacc4\uac12 (Tablespace threshold)<\/h3>\n
\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc784\uacc4\uac12\uc740 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 “\uac00\ub4dd \ucc2c \uc815\ub3c4”\uc5d0 \uc758\ud574 \uc815\uc758\ub41c\ub2e4. \uc774\ub294 \uc0ac\uc6a9\ub7c9\/\ud560\ub2f9\ub7c9\uc758 \ubc31\ubd84\uc728\ub85c \ud45c\ud604\ub420 \uc218 \uc788\ub2e4.<\/p>\n
\uc774\ub7ec\ud55c \uc784\uacc4\uac12\uc740 \ub2e4\uc2dc Warning \uc784\uacc4\uac12\uacfc Critical \uc784\uacc4\uac12\uc758 \ub450 \ub2e8\uacc4\ub85c \uc815\uc758\ub41c\ub2e4.<\/p>\n
\uc870\uac74<\/h3>\n\n- \n\ucd08\uae30\ud654 \ud30c\ub77c\ubbf8\ud130 COMPATIBLE >= 10.0 \uc77c \uac83.<\/div>\n<\/li>\n
- \n\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub294 Locally Managed \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc77c \uac83.<\/div>\n<\/li>\n<\/ul>\n
\uc0c1\uc138 \uae30\ub2a5<\/h3>\n
DBA\ub294 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \ubcc4\ub85c \uc784\uacc4\uac12\uc744 \uc9c0\uc815\ud560 \uc218 \uc788\ub2e4. \ub9cc\uc77c \uc544\ubb34 \uac83\ub3c4 \uba85\uc2dc\ud558\uc9c0 \uc54a\uc73c\uba74, \uba3c\uc800 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc804\uccb4\uc5d0 \ub300\ud55c \uae30\ubcf8\uac12\uc774 \uc801\uc6a9\ub418\uba70,<\/p>\n
\uadf8 \uac12\uc740 Warning \uc784\uacc4\uac12 85%, Critical \uc784\uacc4\uac12 97%\uc774\ub2e4.<\/p>\n
\ub2e4\ub9cc migrate\ub41c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uacbd\uc6b0 \ud3b8\uc758\uc0c1 null\ub85c \uc790\ub3d9 \uc124\uc815\ub418\uc5b4 alert \uae30\ub2a5\uc774 off \ub41c\ub2e4.<\/p>\n
\ubc31\uadf8\ub77c\uc6b4\ub4dc \ud504\ub85c\uc138\uc2a4\uc778 MMON\uc774 \ub9e4 10\ubd84\ub9c8\ub2e4 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 \uacf5\uac04 \uc0ac\uc6a9\ub7c9\uc744 \uc815\uc758\ub41c \uc784\uacc4\uac12\uacfc \ube44\uad50\ud558\ub294 \uacc4\uc0b0\uc744 \uc218\ud589\ud558\uba70 \uadf8 \uacb0\uacfc\ub97c \ub0b4\ubd80 \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ud55c\ub2e4.<\/p>\n
\ub9cc\uc77c \uc0ac\uc6a9\ub7c9\uc774 \uc784\uacc4\uac12\uc744 \ucd08\uacfc\ud558\ub294 \uacbd\uc6b0, \uc801\uc808\ud55c alert\uac00 \ubc1c\uc0dd\ub41c\ub2e4. (RAC \ud658\uacbd\uc758 \uacbd\uc6b0 \uc778\uc2a4\ud134\uc2a4\ub9c8\ub2e4 MMON\uc774 \uc788\uc9c0\ub9cc \uac01\uc790\uc758 \ud65c\ub3d9\uc740 \ub3d9\uae30\ud654\ub418\uba70,<\/p>\n
\uc784\uacc4\uac12\uc758 \ucd08\uacfc \uc0c1\ud669\uc744 \uc81c\uc77c \ucc98\uc74c \ubc1c\uacac\ud55c MMON\uc774 alert\ub97c \uc0dd\uc131\ud558\uac8c \ub41c\ub2e4.)<\/p>\n
\uc774\uc81c DBA\ub294 \uc801\uc808\ud55c \uc870\uce58\uc5d0 \uc758\ud574 \ud574\ub2f9 \uacf5\uac04 \ubb38\uc81c\ub97c \ubbf8\ub9ac \ud574\uacb0\ud560 \uc218 \uc788\ub2e4.<\/p>\n
\uc774\ub54c \uadf8 \uc561\uc158\uc744 \uc218\ud589\ud55c \uc138\uc158\uc774 \uc55e\uc11c \uc5b8\uae09\ud55c \ub0b4\ubd80 \ud14c\uc774\ube14\uc744 \uc5c5\ub370\uc774\ud2b8\ud558\uac8c \ub418\uba70 \uc774\uac83\uc774 MMON\uc758 \ub2e4\uc74c \ubc88 \uccb4\ud06c\uc5d0\uc11c \ud655\uc778\ub428\uc73c\ub85c\uc368 \ud574\ub2f9 alert\uac00 \ud574\uc81c\ub420 \uc218 \uc788\ub294 \uac83\uc774\ub2e4.<\/p>\n
\uc0ac\uc6a9 \ubc29\ubc95<\/h3>\n
\ud06c\uac8c \uc138\uac00\uc9c0\uc758 \uc0ac\uc6a9\uc790 \uc778\ud130\ud398\uc774\uc2a4\uac00 \uc81c\uacf5\ub41c\ub2e4.<\/p>\n
<\/p>\n
\uad00\ub828\ub41c \ub3d9\uc801 \uc131\ub2a5 \ubdf0 \ubc0f \ub515\uc154\ub108\ub9ac \ubdf0\ub97c \uc774\uc6a9\ud55c \uc870\ud68c<\/h4>\n
\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc784\uacc4\uac12\uc740 \ub515\uc154\ub108\ub9ac \ubdf0 DBA_THRESHOLDS\ub85c\ubd80\ud130 \ud655\uc778\ud560 \uc218 \uc788\uc73c\uba70, \uac19\uc740 \uc815\ubcf4\uac00 WRI$_ALERT_THRESHOLD\ub85c\ubd80\ud130\ub3c4 \uc81c\uacf5\ub41c\ub2e4.<\/p>\n
\ub2e4\uc74c\uc740 DBA_THRESHOLDS\uc5d0 \ub300\ud55c \ucd5c\ucd08 \uc870\ud68c\uc774\ub2e4.<\/p>\n
\n\n\n \n\nSQL> select warning_operator wop,
\n<\/span><\/p>\n 2 warning_value warn,
\n<\/span><\/p>\n 3 critical_operator cop,
\n<\/span><\/p>\n 4 critical_value cri,
\n<\/span><\/p>\n 5 observation_period op,
\n<\/span><\/p>\n 6 consecutive_occurrences co,
\n<\/span><\/p>\n 7 instance_name,
\n<\/span><\/p>\n 8 object_type,
\n<\/span><\/p>\n 9 object_name,
\n<\/span><\/p>\n 10 status
\n<\/span><\/p>\n 11 from dba_thresholds
\n<\/span><\/p>\n 12 where metrics_name = ‘Tablespace Space Usage’;
\n<\/span><\/p>\nWOP WARN COP CRI OP CO INSTANCE_NAME OBJECT_TYPE OBJECT_NAME STATUS
\n<\/span><\/p>\n—- —- —- —- — — ————- ———– ————— ——
\n<\/span><\/p>\nGT 85 GT 97 1 1 TABLESPACE VALID<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n>= 87%, >= 97%\uc758 \uae30\ubcf8\uac12 \uc124\uc815\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4. Instance_name\uc774 null\uc784\uc740 \uc774 \uc124\uc815\uc774 database-wide\ud55c \uc124\uc815\uc784\uc744 \ub098\ud0c0\ub0b4\uba70,<\/p>\n
object_type\uc740 tablespace\uc774\ub418 object_name\uc774 null\uc784\uc740 \ud604\uc7ac \uc5b4\ub5a4 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc5d0 \ub300\ud574\uc11c\ub3c4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uae30\ubcf8 \uc124\uc815\uc774 override\ub418\uc9c0 \uc54a\uc740 \uc0c1\ud0dc\uc784\uc744 \ubcf4\uc5ec\uc900\ub2e4.<\/p>\n
<\/p>\n
<\/p>\n
\ud328\ud0a4\uc9c0\ub97c \uc0ac\uc6a9\ud55c \uc784\uacc4\uac12\uc758 \uc77d\uae30\/\uc4f0\uae30<\/h4>\n
\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc784\uacc4\uac12\uc5d0 \ub300\ud55c PL\/SQL \uc778\ud130\ud398\uc774\uc2a4\ub85c\uc11c DBMS_SERVER_ALERTS \ud328\ud0a4\uc9c0\uac00 \uc81c\uacf5\ub41c\ub2e4.<\/p>\n
\uc774 \ud328\ud0a4\uc9c0\uc758 \uc5ec\ub7ec \ud504\ub85c\uc2dc\uc800\ub4e4\uc758 \ud30c\ub77c\ubbf8\ud130\ub294 DBA_THRESHOLDS \/ WRI$_ALERT_THRESHOLD \uc758 \uac01 \uceec\ub7fc\ub4e4\uacfc \ub300\ubd80\ubd84 \ub9e4\ud551\ub41c\ub2e4.<\/p>\n
\ub2e4\uc74c\uc740 DBMS_SERVER_ALERT.SET_THRESHOLD \ud504\ub85c\uc2dc\uc800\ub97c \uc774\uc6a9\ud558\uc5ec USERS \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc758 \uc784\uacc4\uac12\uc744 \uacbd\uace0\uac12 70%, \ud55c\uacc4\uac12 90%\ub85c \uc218\uc815\ud558\ub294 \uc608\uc774\ub2e4.<\/p>\n
\n\n\n \n\nSQL> begin
\n<\/span><\/p>\n 2 dbms_server_alert.set_threshold(9000, 4, ’70’, 4, ’90’, 10, 1, null, 5, ‘USERS’);
\n<\/span><\/p>\n 3 end;
\n<\/span><\/p>\n\/
\n<\/span><\/p>\n— <\/span>\ub2e4\uc2dc<\/span> DBA_THRESHOLDS<\/span>\ub97c<\/span>
\n<\/span>\uc870\ud68c\ud558\uc5ec<\/span>
\n<\/span>\uc218\ud589<\/span>
\n<\/span>\uacb0\uacfc<\/span>
\n<\/span>\ud655\uc778<\/span>
\n<\/span><\/span><\/p>\nWOP WARN COP CRI OP CO INSTANCE_NAME OBJECT_TYPE OBJECT_NAME STATUS
\n<\/span><\/p>\n—- —- —- —- — — ————- ———– ————— ——
\n<\/span><\/p>\nGE 70 GE 90 10 1 TABLESPACE USERS VALID
\n<\/span><\/p>\nGT 85 GT 97 1 1 TABLESPACE VALID<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\nUSERS \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc5d0 \ub300\ud55c \ubcc4\ub3c4\uc758 \ud589\uc774 \uc0dd\uc131\ub41c \uac83\uc744 \uc54c \uc218 \uc788\ub2e4.<\/p>\n
<\/p>\n
<\/p>\n
Enterprise Manager\uc758 GUI<\/h4>\n
Enterprise Manager\ub294 \ub515\uc154\ub108\ub9ac \ubdf0\/\ub3d9\uc801 \uc131\ub2a5 \ubdf0\uc5d0 \ub300\ud55c \uc870\ud68c \ubc0f DBMS_SERVER_ALERT \ud328\ud0a4\uc9c0\uc758 \uc0ac\uc6a9\uc744 GUI\ub85c \uc81c\uacf5\ud55c\ub2e4.<\/p>\n
\ub2e4\uc74c\uc740 “\ub370\uc774\ud130\ubca0\uc774\uc2a4 -> \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 -> \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \ud3b8\uc9d1” \ud654\uba74\uc758 “\uc784\uacc4\uac12” \ud0ed\uc744 \ud1b5\ud574 \ubcf8 \ud654\uba74 \uc608\uc774\ub2e4.<\/p>\n
![\"\"](\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020518_1129_TIP1.png?w=640\")
<\/p>\n
\uc758\uacac<\/h2>\n
\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc784\uacc4\uac12\uc740 \uacf5\uac04 \ubd80\uc871 \uc624\ub958\ub97c \uc0ac\uc804\uc5d0 \ubc29\uc9c0\ud560 \uc218 \uc788\uc744 \ub9cc\ud07c \ucda9\ubd84\ud55c \uc2dc\uac04\uc744 \ud655\ubcf4\ud560 \uc218 \uc788\ub294 \ub9cc\ud07c \uc791\uac8c,<\/p>\n
\uadf8\ub7ec\ub098 \uadf8\ub9ac \uae09\ud55c \uc0c1\ud669\uc774 \uc544\ub2d8\uc5d0\ub3c4 \ubd88\uad6c\ud558\uace0 alert\uac00 \ubc1c\uc0dd\ud558\ub294 \uac83\uc740 \ubc29\uc9c0\ud560 \uc218 \uc788\uc744 \uc815\ub3c4\ub85c \ud06c\uac8c \uc124\uc815\ud558\ub294 \uac83\uc774 \uc774\uc0c1\uc801\uc77c \uac83\uc774\ub2e4.<\/p>\n
\ub610\ud55c \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 \ud2b9\uc9d5\ubcc4\ub85c \ub2e4\uc74c\uacfc \uac19\uc740 \uace0\ub824\ub97c \ud574\uc57c \ud560 \uac83\uc774\ub2e4.<\/p>\n
<\/p>\n
\n- \n\uc77d\uae30 \uc804\uc6a9\/\uc624\ud504\ub77c\uc778 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 \uacbd\uc6b0 \uacf5\uac04 \uc0ac\uc6a9\ub7c9\uc774 \uc99d\uac00\ud558\uc9c0 \uc54a\uc744 \uac83\uc774\ubbc0\ub85c \uc784\uacc4\uac12\uc774\ub098 alert\ub97c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub3c4\ub85d \ud574\uc57c \ud560 \uac83\uc774\ub2e4.<\/div>\n<\/li>\n
- \nTemporary \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \ubc0f Undo \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 \uc0ac\uc6a9\ub7c9\uc740 \uc77c\ubc18\uc801\uc778 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc640\ub294 \ub2ec\ub9ac workload\uc640 \uc5f0\uad00\ub41c \ub3d9\uc801\uc778 \ud2b9\uc131\uc744 \uac16\uace0 \uc788\uc73c\ubbc0\ub85c, \uc784\uacc4\uac12 \ub610\ud55c \ubcf4\ub2e4 \ub3d9\uc801\uc73c\ub85c \uad00\ub9ac\ud574\uc57c \ud560 \uac83\uc774\ub2e4.<\/div>\n<\/li>\n
- \nAUTOEXTENSIBLE \ub370\uc774\ud130\ud30c\uc77c\uc758 \uacbd\uc6b0 \uc784\uacc4\uac12\uc740 \ud30c\uc77c\uc758 \ucd5c\ub300 \ud06c\uae30\ub85c \uc9c0\uc815\ud55c \uac12\uc5d0 \uc758\uac70\ud558\uc5ec \uc815\ud574\uc9c8 \uac83\uc774\uba70, \ub9cc\uc77c UNLIMITED \ub370\uc774\ud130\ud30c\uc77c\uc774\ub77c\uba74 OS\uc758 \ucd5c\ub300 \ud30c\uc77c \ud06c\uae30\uc640 \uc5f0\uad00\uc774 \ub418\uc5b4 \uc9c0\uc815\ub418\uc5b4\uc57c \ud560 \uac83\uc774\ub2e4.<\/div>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
Oracle Database 10g \ubd80\ud130 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 \ub514\uc2a4\ud06c \uacf5\uac04 \uc0ac\uc6a9\uc744 \uc0ac\uc804\uc801\uc73c\ub85c \uad00\ub9ac\ud560 \uc218 \uc788\ub3c4\ub85d \ud558\ub294 \uae30\ub2a5\uc744 \uc81c\uacf5\ud55c\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 alert\ub97c \ud1b5\ud558\uc5ec DBA\ub85c \ud558\uc5ec\uae08 \uacf5\uac04 \ubd80\uc871 \uc624\ub958\uac00 \ubc1c\uc0dd\ud558\uae30 \uc804\uc5d0 \ubbf8\ub9ac \ud544\uc694\ud55c \uc870\uce58\ub97c \ucde8\ud560 \uc218 \uc788\ub3c4\ub85d \ud568. \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 \uacf5\uac04 \uc0ac\uc6a9 \uae30\ub85d\uc744 AWR\uc5d0 \uc800\uc7a5\ud568\uc73c\ub85c\uc368, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uacf5\uac04 \uc0ac\uc6a9 \uacbd\ud5a5 \ubd84\uc11d \ubc0f \uc6a9\ub7c9 \uacc4\ud68d\uc744 \ub3c4\uc6c0. \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc784\uacc4\uac12 (Tablespace threshold) \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc784\uacc4\uac12\uc740 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 “\uac00\ub4dd […]<\/p>\n","protected":false},"author":1,"featured_media":2880,"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":[3],"tags":[679,89,1022],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/tips-newsletter.jpg?fit=680%2C530","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3589"}],"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=3589"}],"version-history":[{"count":3,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3589\/revisions"}],"predecessor-version":[{"id":3592,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3589\/revisions\/3592"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2880"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3589"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3589"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3589"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\uc0c1\uc138 \uae30\ub2a5<\/h3>\n
DBA\ub294 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \ubcc4\ub85c \uc784\uacc4\uac12\uc744 \uc9c0\uc815\ud560 \uc218 \uc788\ub2e4. \ub9cc\uc77c \uc544\ubb34 \uac83\ub3c4 \uba85\uc2dc\ud558\uc9c0 \uc54a\uc73c\uba74, \uba3c\uc800 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc804\uccb4\uc5d0 \ub300\ud55c \uae30\ubcf8\uac12\uc774 \uc801\uc6a9\ub418\uba70,<\/p>\n
\uadf8 \uac12\uc740 Warning \uc784\uacc4\uac12 85%, Critical \uc784\uacc4\uac12 97%\uc774\ub2e4.<\/p>\n
\ub2e4\ub9cc migrate\ub41c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uacbd\uc6b0 \ud3b8\uc758\uc0c1 null\ub85c \uc790\ub3d9 \uc124\uc815\ub418\uc5b4 alert \uae30\ub2a5\uc774 off \ub41c\ub2e4.<\/p>\n
\ubc31\uadf8\ub77c\uc6b4\ub4dc \ud504\ub85c\uc138\uc2a4\uc778 MMON\uc774 \ub9e4 10\ubd84\ub9c8\ub2e4 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 \uacf5\uac04 \uc0ac\uc6a9\ub7c9\uc744 \uc815\uc758\ub41c \uc784\uacc4\uac12\uacfc \ube44\uad50\ud558\ub294 \uacc4\uc0b0\uc744 \uc218\ud589\ud558\uba70 \uadf8 \uacb0\uacfc\ub97c \ub0b4\ubd80 \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ud55c\ub2e4.<\/p>\n
\ub9cc\uc77c \uc0ac\uc6a9\ub7c9\uc774 \uc784\uacc4\uac12\uc744 \ucd08\uacfc\ud558\ub294 \uacbd\uc6b0, \uc801\uc808\ud55c alert\uac00 \ubc1c\uc0dd\ub41c\ub2e4. (RAC \ud658\uacbd\uc758 \uacbd\uc6b0 \uc778\uc2a4\ud134\uc2a4\ub9c8\ub2e4 MMON\uc774 \uc788\uc9c0\ub9cc \uac01\uc790\uc758 \ud65c\ub3d9\uc740 \ub3d9\uae30\ud654\ub418\uba70,<\/p>\n
\uc784\uacc4\uac12\uc758 \ucd08\uacfc \uc0c1\ud669\uc744 \uc81c\uc77c \ucc98\uc74c \ubc1c\uacac\ud55c MMON\uc774 alert\ub97c \uc0dd\uc131\ud558\uac8c \ub41c\ub2e4.)<\/p>\n
\uc774\uc81c DBA\ub294 \uc801\uc808\ud55c \uc870\uce58\uc5d0 \uc758\ud574 \ud574\ub2f9 \uacf5\uac04 \ubb38\uc81c\ub97c \ubbf8\ub9ac \ud574\uacb0\ud560 \uc218 \uc788\ub2e4.<\/p>\n
\uc774\ub54c \uadf8 \uc561\uc158\uc744 \uc218\ud589\ud55c \uc138\uc158\uc774 \uc55e\uc11c \uc5b8\uae09\ud55c \ub0b4\ubd80 \ud14c\uc774\ube14\uc744 \uc5c5\ub370\uc774\ud2b8\ud558\uac8c \ub418\uba70 \uc774\uac83\uc774 MMON\uc758 \ub2e4\uc74c \ubc88 \uccb4\ud06c\uc5d0\uc11c \ud655\uc778\ub428\uc73c\ub85c\uc368 \ud574\ub2f9 alert\uac00 \ud574\uc81c\ub420 \uc218 \uc788\ub294 \uac83\uc774\ub2e4.<\/p>\n
\uc0ac\uc6a9 \ubc29\ubc95<\/h3>\n
\ud06c\uac8c \uc138\uac00\uc9c0\uc758 \uc0ac\uc6a9\uc790 \uc778\ud130\ud398\uc774\uc2a4\uac00 \uc81c\uacf5\ub41c\ub2e4.<\/p>\n
<\/p>\n
\uad00\ub828\ub41c \ub3d9\uc801 \uc131\ub2a5 \ubdf0 \ubc0f \ub515\uc154\ub108\ub9ac \ubdf0\ub97c \uc774\uc6a9\ud55c \uc870\ud68c<\/h4>\n
\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc784\uacc4\uac12\uc740 \ub515\uc154\ub108\ub9ac \ubdf0 DBA_THRESHOLDS\ub85c\ubd80\ud130 \ud655\uc778\ud560 \uc218 \uc788\uc73c\uba70, \uac19\uc740 \uc815\ubcf4\uac00 WRI$_ALERT_THRESHOLD\ub85c\ubd80\ud130\ub3c4 \uc81c\uacf5\ub41c\ub2e4.<\/p>\n
\ub2e4\uc74c\uc740 DBA_THRESHOLDS\uc5d0 \ub300\ud55c \ucd5c\ucd08 \uc870\ud68c\uc774\ub2e4.<\/p>\n
| SQL> select warning_operator wop, \n<\/span><\/p>\n 2 warning_value warn, 3 critical_operator cop, 4 critical_value cri, 5 observation_period op, 6 consecutive_occurrences co, 7 instance_name, 8 object_type, 9 object_name, 10 status 11 from dba_thresholds 12 where metrics_name = ‘Tablespace Space Usage’; WOP WARN COP CRI OP CO INSTANCE_NAME OBJECT_TYPE OBJECT_NAME STATUS —- —- —- —- — — ————- ———– ————— —— GT 85 GT 97 1 1 TABLESPACE VALID<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n >= 87%, >= 97%\uc758 \uae30\ubcf8\uac12 \uc124\uc815\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4. Instance_name\uc774 null\uc784\uc740 \uc774 \uc124\uc815\uc774 database-wide\ud55c \uc124\uc815\uc784\uc744 \ub098\ud0c0\ub0b4\uba70,<\/p>\n object_type\uc740 tablespace\uc774\ub418 object_name\uc774 null\uc784\uc740 \ud604\uc7ac \uc5b4\ub5a4 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc5d0 \ub300\ud574\uc11c\ub3c4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uae30\ubcf8 \uc124\uc815\uc774 override\ub418\uc9c0 \uc54a\uc740 \uc0c1\ud0dc\uc784\uc744 \ubcf4\uc5ec\uc900\ub2e4.<\/p>\n <\/p>\n <\/p>\n \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc784\uacc4\uac12\uc5d0 \ub300\ud55c PL\/SQL \uc778\ud130\ud398\uc774\uc2a4\ub85c\uc11c DBMS_SERVER_ALERTS \ud328\ud0a4\uc9c0\uac00 \uc81c\uacf5\ub41c\ub2e4.<\/p>\n \uc774 \ud328\ud0a4\uc9c0\uc758 \uc5ec\ub7ec \ud504\ub85c\uc2dc\uc800\ub4e4\uc758 \ud30c\ub77c\ubbf8\ud130\ub294 DBA_THRESHOLDS \/ WRI$_ALERT_THRESHOLD \uc758 \uac01 \uceec\ub7fc\ub4e4\uacfc \ub300\ubd80\ubd84 \ub9e4\ud551\ub41c\ub2e4.<\/p>\n \ub2e4\uc74c\uc740 DBMS_SERVER_ALERT.SET_THRESHOLD \ud504\ub85c\uc2dc\uc800\ub97c \uc774\uc6a9\ud558\uc5ec USERS \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc758 \uc784\uacc4\uac12\uc744 \uacbd\uace0\uac12 70%, \ud55c\uacc4\uac12 90%\ub85c \uc218\uc815\ud558\ub294 \uc608\uc774\ub2e4.<\/p>\n 2 dbms_server_alert.set_threshold(9000, 4, ’70’, 4, ’90’, 10, 1, null, 5, ‘USERS’); 3 end; \/ — <\/span>\ub2e4\uc2dc<\/span> DBA_THRESHOLDS<\/span>\ub97c<\/span> WOP WARN COP CRI OP CO INSTANCE_NAME OBJECT_TYPE OBJECT_NAME STATUS —- —- —- —- — — ————- ———– ————— —— GE 70 GE 90 10 1 TABLESPACE USERS VALID GT 85 GT 97 1 1 TABLESPACE VALID<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n USERS \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc5d0 \ub300\ud55c \ubcc4\ub3c4\uc758 \ud589\uc774 \uc0dd\uc131\ub41c \uac83\uc744 \uc54c \uc218 \uc788\ub2e4.<\/p>\n <\/p>\n <\/p>\n Enterprise Manager\ub294 \ub515\uc154\ub108\ub9ac \ubdf0\/\ub3d9\uc801 \uc131\ub2a5 \ubdf0\uc5d0 \ub300\ud55c \uc870\ud68c \ubc0f DBMS_SERVER_ALERT \ud328\ud0a4\uc9c0\uc758 \uc0ac\uc6a9\uc744 GUI\ub85c \uc81c\uacf5\ud55c\ub2e4.<\/p>\n \ub2e4\uc74c\uc740 “\ub370\uc774\ud130\ubca0\uc774\uc2a4 -> \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 -> \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \ud3b8\uc9d1” \ud654\uba74\uc758 “\uc784\uacc4\uac12” \ud0ed\uc744 \ud1b5\ud574 \ubcf8 \ud654\uba74 \uc608\uc774\ub2e4.<\/p>\n \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc784\uacc4\uac12\uc740 \uacf5\uac04 \ubd80\uc871 \uc624\ub958\ub97c \uc0ac\uc804\uc5d0 \ubc29\uc9c0\ud560 \uc218 \uc788\uc744 \ub9cc\ud07c \ucda9\ubd84\ud55c \uc2dc\uac04\uc744 \ud655\ubcf4\ud560 \uc218 \uc788\ub294 \ub9cc\ud07c \uc791\uac8c,<\/p>\n \uadf8\ub7ec\ub098 \uadf8\ub9ac \uae09\ud55c \uc0c1\ud669\uc774 \uc544\ub2d8\uc5d0\ub3c4 \ubd88\uad6c\ud558\uace0 alert\uac00 \ubc1c\uc0dd\ud558\ub294 \uac83\uc740 \ubc29\uc9c0\ud560 \uc218 \uc788\uc744 \uc815\ub3c4\ub85c \ud06c\uac8c \uc124\uc815\ud558\ub294 \uac83\uc774 \uc774\uc0c1\uc801\uc77c \uac83\uc774\ub2e4.<\/p>\n \ub610\ud55c \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 \ud2b9\uc9d5\ubcc4\ub85c \ub2e4\uc74c\uacfc \uac19\uc740 \uace0\ub824\ub97c \ud574\uc57c \ud560 \uac83\uc774\ub2e4.<\/p>\n <\/p>\n Oracle Database 10g \ubd80\ud130 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 \ub514\uc2a4\ud06c \uacf5\uac04 \uc0ac\uc6a9\uc744 \uc0ac\uc804\uc801\uc73c\ub85c \uad00\ub9ac\ud560 \uc218 \uc788\ub3c4\ub85d \ud558\ub294 \uae30\ub2a5\uc744 \uc81c\uacf5\ud55c\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 alert\ub97c \ud1b5\ud558\uc5ec DBA\ub85c \ud558\uc5ec\uae08 \uacf5\uac04 \ubd80\uc871 \uc624\ub958\uac00 \ubc1c\uc0dd\ud558\uae30 \uc804\uc5d0 \ubbf8\ub9ac \ud544\uc694\ud55c \uc870\uce58\ub97c \ucde8\ud560 \uc218 \uc788\ub3c4\ub85d \ud568. \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 \uacf5\uac04 \uc0ac\uc6a9 \uae30\ub85d\uc744 AWR\uc5d0 \uc800\uc7a5\ud568\uc73c\ub85c\uc368, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uacf5\uac04 \uc0ac\uc6a9 \uacbd\ud5a5 \ubd84\uc11d \ubc0f \uc6a9\ub7c9 \uacc4\ud68d\uc744 \ub3c4\uc6c0. \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc784\uacc4\uac12 (Tablespace threshold) \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc784\uacc4\uac12\uc740 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 “\uac00\ub4dd […]<\/p>\n","protected":false},"author":1,"featured_media":2880,"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":[3],"tags":[679,89,1022],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/tips-newsletter.jpg?fit=680%2C530","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3589"}],"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=3589"}],"version-history":[{"count":3,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3589\/revisions"}],"predecessor-version":[{"id":3592,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3589\/revisions\/3592"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2880"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3589"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3589"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3589"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}} |