{"id":675,"date":"2015-11-20T09:15:46","date_gmt":"2015-11-20T09:15:46","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=675"},"modified":"2015-11-20T09:15:46","modified_gmt":"2015-11-20T09:15:46","slug":"oracle-db-hang-%ec%83%81%ed%83%9c","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=675","title":{"rendered":"Oracle DB Hang \uc0c1\ud0dc"},"content":{"rendered":"<p><span style=\"font-size: 10pt;\">Oracle Database Hang \uc0c1\ud0dc\uc758 \uc815\uc758<\/span><\/p>\n<p><span style=\"font-size: 11pt;\"><b>1. What`s the problem ?<\/b><\/span><\/p>\n<ul style=\"list-style-type: square;\">\n<li><span style=\"font-size: 10pt;\">\ud604\uc0c1 \ubc1c\uc2f1\uc2dc \uc0c1\ud669 \uc778\uc9c0 \uc2dc\uac04 \ud544\uc694<\/span><\/li>\n<li><span style=\"font-size: 10pt;\">\ud604\uc0c1\uc744 \uc815\uc758\ud558\uae30 \uc5b4\ub824\uc6c0<\/span><\/li>\n<ol style=\"list-style-type: upper-roman;\">\n<li><span style=\"font-size: 9pt;\">\ub204\uac00 \ud604\uc0c1\uc744 \ubd84\uc11d\ud558\ub294\uac00?<\/span><\/li>\n<li><span style=\"font-size: 9pt;\">\ubb34\uc5c7\uc744 \ud655\uc778\ud558\ub294\uac00?<\/span><\/li>\n<\/ol>\n<li><span style=\"font-size: 10pt;\">Hang \ud604\uc0c1\uc73c\ub85c \uc778\ud574 \uc0c1\ud669 \ubd84\uc11d \ubd88\uac00<\/span><\/li>\n<li><span style=\"font-size: 10pt;\">\ubb38\uc81c \uc6d0\uc778\uc744 \ucc3e\uae30 \ubcf4\ub2e4\ub294 Application \/ DBMS\ub97c re-startup<\/span><\/li>\n<\/ul>\n<div><\/div>\n<div><span style=\"font-size: 11pt;\"><b>2. Monitoring Oracle Continuously<\/b><\/span><\/div>\n<ul style=\"list-style-type: disc;\">\n<li><span style=\"font-size: 10pt;\">\uc9c0\uc18d\uc801\uc73c\ub85c Instance\uc758 \ub3d9\uc791 \uc0c1\ud0dc\ub97c \uac10\uc2dc\ud558\uace0 logging<\/span><\/li>\n<li><span style=\"font-size: 10pt;\">Performance\ub97c \uc911\uc2ec\uc73c\ub85c \ud55c monitoring\uc774 \uc544\ub2cc \uc7a5\uc560 \uc778\uc9c0 \ubc0f \uc608\ubc29\uc744 \ubaa9\uc801\uc73c\ub85c \ud55c monitoring \uc2e4\uc2dc<\/span><\/li>\n<li><span style=\"font-size: 10pt;\">\ubbf8\ub9ac \uc815\uc758\ub41c \ube44\uc815\uc0c1 \uc0c1\ud0dc(symptom)\uc774 \ubc1c\uc0dd\ud558\uba74 \uc790\ub3d9\uc73c\ub85c alarm, logging, dump \uc218\ud589<\/span><\/li>\n<li><span style=\"font-size: 10pt;\">\ubbf8\ub9ac \uc815\uc758\ub41c dump \uc124\uc815\uc744 \ud1b5\ud574 \uc0c1\ud669\uc744 \ucd5c\ub300\ud55c \uae30\ub85d<\/span><\/li>\n<li><span style=\"font-size: 10pt;\">\uc9c0\uc18d\uc801\uc73c\ub85c \ube44\uc815\uc0c1 \uc870\uac74 update<\/span><\/li>\n<\/ul>\n<div><span style=\"font-size: 11pt;\"><b>3. \ube44\uc815\uc0c1 \uc0c1\ud0dc\uc758 \uc138\uc158 \ubc1c\uc0dd \uac10\uc2dc<\/b><\/span><\/div>\n<ul style=\"list-style-type: disc;\">\n<li><span style=\"font-size: 10pt;\">V$SESSION_WAIT : \ubaa8\ub4e0 \uc138\uc158\uc758 \ud604\uc7ac \ub300\uae30 \uc0c1\ud0dc\ub97c \ud45c\ud604\ud55c \uac83\uc73c\ub85c \ubaa8\ub2c8\ud130\ub9c1\uc758 \uae30\uc900\uc73c\ub85c \uc0bc\uae30\uc5d0 \ucda9\ubd84\ud55c \ub370\uc774\ud130\ub97c \ud45c\ud604\ud558\uace0 \uc788\ub2e4.<\/span><\/li>\n<ul style=\"list-style-type: disc;\">\n<li><span style=\"font-size: 9pt;\"><span style=\"color: rgb(255, 0, 0);\">\ube44 \uc815\uc0c1<\/span><span style=\"color: rgb(255, 0, 0);\">&nbsp;\uc0c1\ud0dc &nbsp;: PMON\uc774 &#8216;pmon timer&#8217; \uc0c1\ud0dc\uba70 seconds_in_wait\uc774 \uc99d\uac00\ud558\uc9c0 \uc54a\ub294\ub2e4.<\/span><\/span><\/li>\n<\/ul>\n<ol style=\"list-style-type: upper-roman;\">\n<li><span style=\"font-size: 9pt;\">Critical Wait Event\uac00 30\ucd08 \uc774\uc0c1 \uc9c0\uc5f0\ub418\uace0 \uc788\ub2e4.<\/span><\/li>\n<li><span style=\"font-size: 9pt;\">Normal Wait Event\uac00 60\ucd08 \uc774\uc0c1 \uc9c0\uc5f0\ub418\uace0 \uc788\ub2e4.<\/span><\/li>\n<\/ol>\n<li><span style=\"font-size: 10pt;\">5\ucd08 \uac04\uaca9\uc73c\ub85c active session\uc758 wait event\ub97c \uae30\ub85d\ud55c\ub2e4.<\/span><\/li>\n<ol style=\"list-style-type: upper-roman;\">\n<li>Critical Wait event : row cache lock, free buffer waits, library cache pin, log file sync, latch free \ub4f1<\/li>\n<li>Normal Wait event : db file sequential read,SQL*Net message to client(or dblink) \ub4f1.<\/li>\n<li>Idle wait event\ub294 \ubaa8\ub2c8\ud130\ub9c1 \uc81c\uc678<\/li>\n<li>STATE\uac00 &#8216;WAITING&#8217;\uc778 \uac83\ub9cc\uc744 \ub300\uc0c1<\/li>\n<\/ol>\n<li>Wait event\ub294 idle, non-idle\ub85c \ub17c\ub9ac\uc801 \uad6c\ubd84\ud560 \uc218 \uc788\uc73c\uba70, \uadf8 \uc885\ub958\ub294 v$event_name\uc73c\ub85c \ud655\uc778 \ud560 \uc218 \uc788\ub2e4.<\/li>\n<\/ul>\n<div><\/div>\n<div>\n<div><span style=\"font-size: 11pt;\"><b>4.&nbsp;<\/b><\/span><span style=\"font-size: 14.6667px;\"><b>\uacf5\uc720 \uc790\uc6d0\uc758 \ube44 \ud6a8\uc728\uc801 \uc0ac\uc6a9 \uac10\uc2dc \ubc0f Leak \uac10\uc2dc<\/b><\/span><\/div>\n<ul>\n<li><span style=\"font-size: 10pt;\">V$SGASTAT :&nbsp;<\/span><span style=\"font-size: 13.3333px;\">shared pool\uc5d0 \ud560\ub2f9\ub418\ub294 \uba54\ubaa8\ub9ac\uc758\ud06c\uae30\ub97c \ud45c\ud604\ud558\uace0\uc788\ub2e4.<\/span><\/li>\n<ul>\n<li>Application\uc758 \ubaa9\uc801\uacfc \ub3d9\uc791 \ud615\ud0dc\uc5d0 \ub530\ub77c \ud2b9\uc815 \uc720\ud615\uc758 \uba54\ubaa8\ub9ac \ud560\ub2f9\uc774\uc9c0\uc18d\uc801\uc73c\ub85c\uc99d\uac00 \ud560 \uc218 \uc788\ub2e4. \ub610 code bug\uc5d0 \uc758\ud55c memory leak\uc774 \ubc1c\uc0dd \ud560 \uc218 \uc788\ub2e4.<\/li>\n<li>Permanent chunk\uac00 \uc9c0\uc18d\uc801\uc73c\ub85c\ud560\ub2f9 \ub420 \uacbd\uc6b0, ORA-4031\uac00 \ubc1c\uc0dd\ub418\uba70, \uc774\ub294 instance crash\uc758 \uc6d0\uc778\uc774 \ub420 \uc218 \uc788\ub2e4.<\/li>\n<li>\ud2b9\uc815 \uc720\ud615\uc758 memory(name)\uc758 \ud06c\uae30\uac00 \uc9c0\uc18d\uc801\uc73c\ub85c \uc99d\uac00 \ud55c\ub2e4. (\uc2dc\uac04 \ub610\ub294 \uc77c \ube44\uad50)<\/li>\n<li><span style=\"color: rgb(255, 0, 0);\">\ube44 \uc815\uc0c1<\/span><span style=\"color: rgb(255, 0, 0);\">&nbsp;\uc0c1\ud0dc<span style=\"color: rgb(255, 0, 0);\"> &nbsp;:<\/span><\/span><span style=\"color: rgb(255, 0, 0);\">&nbsp;<\/span><span style=\"color: rgb(255, 0, 0);\">&#8216;dictionary cache&#8217; \uc640 &#8216;sql area&#8217;\uc758 \ud06c\uae30\uac00 \uc9c0\uc18d\uc801\uc73c\ub85c \uac10\uc18c\ud55c\ub2e4<\/span><span style=\"font-size: 9pt; color: rgb(255, 0, 0);\">&nbsp;<\/span><\/li>\n<\/ul>\n<\/ul>\n<\/div>\n<ul>\n<li><span style=\"font-size: 10pt;\">V$PROCESS&nbsp;:&nbsp;<\/span><span style=\"font-size: 13.3333px;\">PGA_ALLOC_MEM\uc740 process\uac00 \ud560\ub2f9\ud55cheap\uc758 \ud06c\uae30\uc774\ub2e4.<\/span><\/li>\n<ul>\n<li>\ud2b9\uc815 \uc0c1\ud669\uc5d0\uc11c \uc9c0\uc18d\uc801\uc778 \uba54\ubaa8\ub9ac \ud560\ub2f9\uc73c\ub85c \uc778\ud574 <span style=\"color: rgb(255, 0, 0);\">ORA-4030\uc774 \ubc1c\uc0dd<\/span>\ud560 \uc218 \uc788\ub2e4.&nbsp;<\/li>\n<li>\ubc1c\uc0dd\ud560 \uc218 \uc788\ub294 \uba54\ubaa8\ub9ac \ud06c\uae30\ub294 ulimit \uacfc physical memory\uc5d0 \ub530\ub77c \ub2e4\ub974\ub2e4.&nbsp;<\/li>\n<li>\ube44\uc815\uc0c1\uc801\uc73c\ub85c \ud074 \uacbd\uc6b0 pga heapdump\ub97c \uae30\ub85d\ud55c\ub2e4.<\/li>\n<li><span style=\"color: rgb(255, 0, 0);\">\ube44 \uc815\uc0c1<\/span><span style=\"color: rgb(255, 0, 0);\"><span style=\"color: rgb(255, 0, 0);\">&nbsp;\uc0c1\ud0dc<\/span><span style=\"color: rgb(255, 0, 0);\">&nbsp;<\/span><span style=\"color: rgb(255, 0, 0);\">&nbsp;:<\/span><\/span><span style=\"color: rgb(255, 0, 0);\">&nbsp;<\/span><span style=\"color: rgb(255, 0, 0);\">PGA_ALLOC_MEM\uc774 \uc9c0\uc815\ud55c \ud06c\uae30(1000M?)\ubcf4\ub2e4 \ud06c\ub2e4.<\/span><\/li>\n<\/ul>\n<\/ul>\n<p><\/p>\n<div><span style=\"font-size: 11pt;\"><b>5.&nbsp;<\/b><\/span><span style=\"font-size: 14.6667px;\"><b>\ube44 \uc815\uc0c1 \uc801\uc778 transaction\uc744 \ubaa8\ub2c8\ud130\ub9c1<\/b><\/span><\/div>\n<ul>\n<li><span style=\"font-size: 13.3333px;\">V$ROLLSTAT<\/span><span style=\"font-size: 10pt;\">&nbsp;:&nbsp;<\/span><span style=\"font-size: 13.3333px;\">RBS \uc758 30%\ub97c \ucc28\uc9c0\ud558\ub294undo\uac00 \uc874\uc7ac\ud558\ub294\uc9c0\ub610 active transaction\uc774\uc874\uc7ac\ud558\ub294\uc9c0\ub97c&nbsp;<\/span><span style=\"font-size: 13.3333px;\">\uac10\uc2dc\ud55c\ub2e4. \ubc1c\uc0dd\ud560 \uacbd\uc6b0, \ud574\ub2f9 \uc138\uc158\uc758 \uc815\ubcf4\ub97c \uae30\ub85d\ud55c\ub2e4.<\/span><\/li>\n<ul>\n<li><span style=\"color: rgb(255, 0, 0);\">\ube44 \uc815\uc0c1<\/span><span style=\"color: rgb(255, 0, 0);\">&nbsp;\uc0c1\ud0dc&nbsp;&nbsp;:<\/span><span style=\"color: rgb(255, 0, 0);\">&nbsp;\ud2b9\uc815 rollback(or undo)\uc758 \ud06c\uae30\uac00 rbs\uc758 30%\ub97c \ucd08\uacfc\ud558\uba70 xacts\uac00 0\uc774 \uc544\ub2c8\ub2e4.<\/span><span style=\"font-size: 9pt; color: rgb(255, 0, 0);\">&nbsp;<\/span>&nbsp;<\/li>\n<\/ul>\n<\/ul>\n<ul>\n<li><span style=\"font-size: 13.3333px;\">V$TRANSACTION<\/span><span style=\"font-size: 10pt;\">&nbsp;: L<\/span><span style=\"font-size: 13.3333px;\">ong transaction\uacfclarge transaction\uc744\uac10\uc2dc, \uae30\ub85d\ud55c\ub2e4.<\/span><\/li>\n<ul>\n<li><span style=\"color: rgb(255, 0, 0);\">\ube44 \uc815\uc0c1<\/span><span style=\"color: rgb(255, 0, 0);\">&nbsp;\uc0c1\ud0dc&nbsp;&nbsp;:<\/span><span style=\"color: rgb(255, 0, 0);\">&nbsp;START_TIME\uc774 \ud604\uc7ac\ubcf4\ub2e4 60\ubd84 \uc774\uc804\uc774\ub2e4. USED_UBLK\uac00 \uc77c\uc815 \uc218\uce58 \uc774\uc0c1\uc774\ub2e4.<\/span><span style=\"font-size: 9pt; color: rgb(255, 0, 0);\">&nbsp;<\/span>&nbsp;<\/li>\n<\/ul>\n<\/ul>\n<ul>\n<li><span style=\"font-size: 13.3333px;\">X$KTUXE<\/span><span style=\"font-size: 10pt;\">&nbsp;:&nbsp;<\/span><span style=\"font-size: 13.3333px;\">undo header\uc774\ub2e4. Dead transaction \ubc0f \ube44\uc815\uc0c1 \uc0c1\ud0dc\uc758 transaction\uc774 \ubc1c\uc0dd\ud558\ub294\uc9c0 \uac10\uc2dc\ud55c\ub2e4.<\/span><\/li>\n<ul>\n<li><span style=\"color: rgb(255, 0, 0);\">\ube44 \uc815\uc0c1<\/span><span style=\"color: rgb(255, 0, 0);\">&nbsp;\uc0c1\ud0dc&nbsp;&nbsp;:<\/span><span style=\"color: rgb(255, 0, 0);\">&nbsp;KTUXESTA\uc758 \uac12\uc774 &#8216;ACTIVE&#8217; \uc774\uace0, KTUXECFL\uc774 &#8216;NONE&#8217;\uc774 \uc544\ub2cc \ub2e4\ub978 \uac12\uc774\ub2e4.<\/span><span style=\"font-size: 9pt; color: rgb(255, 0, 0);\">&nbsp;<\/span>&nbsp;<\/li>\n<li><\/li>\n<li>Dead transaction : ktuxesta = \u2018ACTIVE\u2019, ktuxecfl = \u2018DEAD\u2019<\/li>\n<li>Dead transaction \uc758 \ubc1c\uc0dd \uc6d0\uc778: kill session, kill process.<\/li>\n<\/ul>\n<\/ul>\n<p><\/p>\n<div><span style=\"font-size: 11pt;\"><b>6.&nbsp;<\/b><\/span><span style=\"font-size: 14.6667px;\"><b>Sort segment \ubc0f Enqueue \uc758 \uc0c1\ud0dc \uac10\uc2dc<\/b><\/span><\/div>\n<ul>\n<li><span style=\"font-size: 13.3333px;\">V$SORT_USAGE<\/span><span style=\"font-size: 10pt;\">&nbsp;:&nbsp;<\/span><span style=\"font-size: 13.3333px;\">Sort segment \ud560\ub2f9\uc774 \ub9e4\uc6b0 \ud06c\uace0 \uc9c0\uc18d\uc801\uc73c\ub85c \ucee4\uc9c8 \uc218 \uc788\ub2e4. \uadf8 \ud06c\uae30\ub294 SQL\uc5d0 \ub530\ub77c \uacb0\uc815 \ub418\uc5b4\uc608\uce21\uc774 <\/span><span style=\"font-size: 13.3333px;\">\ubd88\uac00\ub2a5\ud558\ub2e4.&nbsp;<\/span><span style=\"font-size: 13.3333px;\">\ub9e4\uc6b0 \ucee4\uc9c4\ub2e4\uba74, \uadf8 \uc791\uc5c5\uc774 \uc815\uc0c1\uc778\uc9c0\uc810\uac80\ud560 \ud544\uc694\uac00 \uc788\ub2e4<\/span><\/li>\n<ul>\n<li><span style=\"color: rgb(255, 0, 0);\">\ube44 \uc815\uc0c1<\/span><span style=\"color: rgb(255, 0, 0);\">&nbsp;\uc0c1\ud0dc&nbsp;&nbsp;:<\/span><span style=\"color: rgb(255, 0, 0);\">&nbsp;BLOCKS\uac00 \uc77c\uc815 \uc218\uce58 \uc774\uc0c1\uc774\ub2e4.<\/span><span style=\"font-size: 9pt; color: rgb(255, 0, 0);\">&nbsp;<\/span>&nbsp;<\/li>\n<\/ul>\n<\/ul>\n<ul>\n<li><span style=\"font-size: 13.3333px;\">V$LOCK<\/span><span style=\"font-size: 10pt;\">&nbsp;:&nbsp;<\/span><span style=\"font-size: 13.3333px;\">Lock request \uc0c1\ud0dc\uac00 30\ucd08 \uc774\uc0c1 \uc9c0\uc18d\ub420 \uacbd\uc6b0 holder\ub97c \ube44\uc815\uc0c1 \uc0c1\ud0dc\ub85c \uac04\uc8fc\ud558\uace0 \uc138\uc158 \uc815\ubcf4\ub97c \uae30\ub85d\ud55c\ub2e4.&nbsp;<\/span><span style=\"font-size: 13.3333px;\">Waiting\ud558\ub294 lock type\uc774 \u2018TX\u2019, \u2018TM\u2019, \u2018UL\u2019\uc774 \uc544\ub2cc \uacbd\uc6b0, holder\uc5d0 \ub300\ud574 errorstack\uc744 dump\ud55c\ub2e4.<\/span><\/li>\n<ul>\n<li><span style=\"color: rgb(255, 0, 0);\">\ube44 \uc815\uc0c1<\/span><span style=\"color: rgb(255, 0, 0);\">&nbsp;\uc0c1\ud0dc&nbsp;&nbsp;:<\/span><span style=\"color: rgb(255, 0, 0);\">&nbsp;Lock request \uc0c1\ud0dc\uac00 30\ucd08 \uc774\uc0c1 \uc9c0\uc18d(CTIME &gt; 30) \uc9c0\uc18d\ub41c\ub2e4. &#8216;TX&#8217;,&#8217;TM&#8217;,&#8217;UL&#8217;\uc774 \uc544\ub2cc lock type\uc5d0 \ub300\ud574 30\uc774\uc0c1 \uc9c0\uc18d \ub300\uae30\ud55c\ub2e4.<\/span><span style=\"font-size: 9pt; color: rgb(255, 0, 0);\">&nbsp;<\/span>&nbsp;<\/li>\n<\/ul>\n<\/ul>\n<p><\/p>\n<div><span style=\"font-size: 11pt;\"><b>7.&nbsp;<\/b><\/span><span style=\"font-size: 14.6667px;\"><b>Instance \uc9c0\ud45c \uac80\uc0ac<\/b><\/span><\/div>\n<ul>\n<li><span style=\"font-size: 13.3333px;\">V$SYSSTAT<\/span><span style=\"font-size: 10pt;\">&nbsp;:&nbsp;<\/span><span style=\"font-size: 13.3333px;\">Active transaction\uc774 \ubc1c\uc0dd\ud558\ub294 production \uc758 \u2018redo size\u2019\ub294 \uc9c0\uc18d\uc801 \uc73c\ub85c \uc99d\uac00 \ud574\uc57c \ud55c\ub2e4.&nbsp;<\/span><\/li>\n<li><span style=\"font-size: 13.3333px;\">LGWR \uc5d0 \ubb38\uc81c\ub97c&nbsp;<\/span><span style=\"font-size: 13.3333px;\">\ub9cc\ub09c\ub2e4\uba74 \uc99d\uac00\ud558\uc9c0 \uc54a\uc744 \uc218 \uc788\ub2e4.<\/span><\/li>\n<li><span style=\"font-size: 13.3333px;\">\ud3c9\uade0 redo write\uc2dc\uac04\uc740 Delta(redo write time)\/Delta(redo writes) \uc774\ub2e4.<\/span><\/li>\n<li><span style=\"font-size: 13.3333px;\">RAC : global cache blocks lost \uc640 corrupt\uc740 0\ub610\ub294 0\uc5d0 \uac00\uae4c\uc6cc\uc57c \ud55c\ub2e4. \ub2e4\ub7c9 \ubc1c\uc0dd\uc2dc \uc7a5\uc560\ub85c \uc774\uc5b4\uc9c8 \uc218<\/span><span style=\"font-size: 13.3333px;\">\uc788\ub2e4.<\/span><\/li>\n<li><span style=\"font-size: 13.3333px;\">Hard parse\uc758\ubc1c\uc0dd\ub7c9\uc740 \ucd08\ub2f9 0\ud68c\ub97c \uc774\uc0c1\uc801\uc73c\ub85c\ud558\ub098 \ud604\uc2e4\uc801\uc73c\ub85c\ubd88\uac00\ub2a5\ud558\ub2e4. 0\uc5d0 \uac00\uae5d\uac8c \uc720\uc9c0\ud558\ub294&nbsp;<\/span><span style=\"font-size: 13.3333px;\">\uac83\uc744 \ubaa9\ud45c\ub85c \ud55c\ub2e4.<\/span><\/li>\n<li><span style=\"color: rgb(255, 0, 0);\">\ube44 \uc815\uc0c1<\/span><span style=\"color: rgb(255, 0, 0);\">&nbsp;\uc0c1\ud0dc&nbsp;&nbsp;<\/span><\/li>\n<ul>\n<li><span style=\"color: rgb(255, 0, 0);\">&#8216;redo entries&#8217;\uac00 \uc9c0\uc18d\uc801\uc73c\ub85c \uc99d\uac00\ud558\uc9c0 \uc54a\ub294\ub2e4.&nbsp;<\/span><\/li>\n<li><span style=\"color: rgb(255, 0, 0);\">\ud3c9\uade0 redo write \uc2dc\uac04\uc774 1\ucd08 \uc774\uc0c1 \uc18c\uc694 \ub41c\ub2e4.<\/span><\/li>\n<li><span style=\"color: rgb(255, 0, 0); font-size: 9pt;\">RAC : global cache blocks lost, corrupt \uac12\uc774 \uc99d\uac00 \ud588\ub294\uac00?<\/span><\/li>\n<li><span style=\"font-size: 9pt; color: rgb(255, 0, 0);\">&#8216;Parse count(hard)&#8217;\uac00 \ub300\ub7c9 \ubc1c\uc0dd \ud588\ub294\uac00?&nbsp;<\/span>&nbsp;<\/li>\n<\/ul>\n<\/ul>\n<p><\/p>\n<div><span style=\"font-size: 11pt;\"><b>8.&nbsp;<\/b><\/span><span style=\"font-size: 14.6667px;\"><b>Hardware monitoring<\/b><\/span><\/div>\n<ul>\n<li><\/li>\n<li><span style=\"font-size: 13.3333px;\">Tnsping\uba85\ub839\uc744 \ud1b5\ud574 listener\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uc751\ub2f5\ud558\uace0 \uc788\ub294\uc9c0 \ud655\uc778\ud55c\ub2e4. Listener\uac00 \uc751\ub2f5 \ud55c\ub2e4\uace0&nbsp;<\/span><span style=\"font-size: 13.3333px;\">session\uc774 \uc815\uc0c1 \uc5f0\uacb0\ub418\ub294\uac83\uc744 \uc758\ubbf8\ud558\uc9c0\ub294\uc54a\ub294\ub2e4.<\/span><\/li>\n<li><span style=\"font-size: 13.3333px;\">Alert log\ub294 bdump\uc5d0 \uae30\ub85d\ub418\uc9c0\ub9cc, \uc138\uc158 \uc811\uc18d\uc744 \uc644\ub8cc\ud558\uc9c0\ubabb\ud55c \uc0c1\ud0dc\uc5d0\uc11c\ub294 ?\/rdbms\/log\uc5d0 \uae30\ub85d\ub420 \uc218<\/span><span style=\"font-size: 13.3333px;\">\uc788\ub2e4. \uc591 \ucabd \ubaa8\ub450\ub97c \uacc4\uc18d \ud655\uc778\ud574\uc57c \ud55c\ub2e4.<\/span><\/li>\n<li><span style=\"font-size: 13.3333px;\">\uc8fc\uae30\uc801\uc73c\ub85c ps \uc815\ubcf4\ub97c \uae30\ub85d : process\uc758 status \ub3c4\ud3ec\ud568\ud558\ub3c4\ub85d\ud55c\ub2e4.<\/span><\/li>\n<li><span style=\"font-size: 13.3333px;\">Sar \ub4f1 \uc73c\ub85c\ud1b5\ud574\uc11c \uc774\ubbf8 \uae30\ub85d\ub418\uace0 \uc788\uc744 \uac83\uc73c\ub85c \uc608\uc0c1.<\/span><\/li>\n<li><span style=\"font-size: 13.3333px;\">SYSTEM\uc758 \uc0c1\ud0dc \uc815\ubcf4 \uae30\ub85d : \uc77c\uc815\uac04\uaca9\uc73c\ub85c &#8216;ps&#8217; \uc815\ubcf4 \uae30\ub85d \/ CPU utilization , run queue length,Swa pinfo \ub4f1<\/span><\/li>\n<li><span style=\"color: rgb(255, 0, 0);\">\ube44 \uc815\uc0c1<\/span><span style=\"color: rgb(255, 0, 0);\">&nbsp;\uc0c1\ud0dc &nbsp;<\/span><\/li>\n<\/ul>\n<ul>\n<ul>\n<li><span style=\"color: rgb(255, 0, 0);\">tnsping &nbsp;\uc751\ub2f5\ud558\uc9c0 \uc54a\uac70\ub098, \uc218\ucd08 \uc774\uc0c1 \uc18c\uc694 \ub41c\ub2e4<\/span><\/li>\n<li><span style=\"color: rgb(255, 0, 0);\">ALert log\uc5d0 log switch\uac00 \uc544\ub2cc \ub2e4\ub978 log\uac00 \ubc1c\uc0dd \ud55c\ub2e4.&nbsp;<\/span><\/li>\n<\/ul>\n<\/ul>\n<div><span style=\"font-size: 11pt;\"><b>9. Identifying a Problem<\/b><\/span><\/div>\n<ul>\n<li><span style=\"font-size: 13.3333px;\">Instance Crash :&nbsp;<\/span><span style=\"font-size: 13.3333px;\">Alert log \ud655\uc778<\/span><\/li>\n<li><span style=\"font-size: 13.3333px;\">Instance Hang : \uc2e0\uaddc \uc811\uc18d \ubd88\uac00 \/ V$VIEW \uc870\ud68c \ubd88\uac00 =\uc811\uc18d \ubd88\uac00 \ud604\uc0c1\uc774 \ubc18\ub4dc\uc2dc instance hang\uc744 \uc758\ubbf8\ud558\ub294 \uac83 \uc544\ub2c8\ub2e4. \ub9ce\uc740 \uc218\uc758 \uacbd\uc6b0&nbsp;<\/span><span style=\"font-size: 13.3333px;\">slowdown\uc774\ub2e4.&nbsp;<\/span><\/li>\n<li><span style=\"font-size: 13.3333px;\">Session Hang(Spin) : Query\uc5d0 \ub300\ud574 \uc751\ub2f5\ud558\uc9c0 \uc54a\ub294 \uc0c1\ud0dc\ub97c \ud3ec\uad04\uc801\uc73c\ub85c \ub9d0\ud55c\ub2e4.<\/span><\/li>\n<ul>\n<li><span style=\"font-size: 13.3333px;\">Spin : \ud2b9\uc815 &nbsp;process\uac00 cpu\ub97c 100% \uc810\uc720\ud55c\ub2e4(Wait\ud558\ub294 event\uac00 \uc5c6\ub2e4)<\/span><\/li>\n<li><span style=\"font-size: 13.3333px;\">\ud2b9\uc815 process\uac00 \ubd88\ud2b9\uc815 lock\/resource\ub97c \uc810\uc720 \ud6c4 \uc751\ub2f5\ud558\uc9c0 \uc54a\uc74c.<\/span><\/li>\n<\/ul>\n<li><span style=\"font-size: 13.3333px;\">Process Spinning : process\uac00 \ud2b9\uc815 \ucf54\ub4dc\ub97c \ubc18\ubcf5 \uc218\ud589\ud558\uba70\uc885\ub8cc\ud558\uc9c0\ubabb\ud574 CPU\ub97c \uacfc\ub2e4 \uc810\uc720\ud558\ub294&nbsp;<\/span><span style=\"font-size: 13.3333px;\">\ud604\uc0c1\uc774\ub2e4. Session hang\uc758 \ud604\uc0c1 \uc911 \ud558\ub098\uc774\ub2e4.<\/span><\/li>\n<li><b><span style=\"font-size: 13.3333px; color: rgb(9, 0, 255);\">Slowdown : long transaction\ub4f1\uc73c\ub85c\uc778\ud574 block\ub418\ub294 session\uc774\ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0, \uadf8 session\uc774 \uc810\uc720\ud558\ub294&nbsp;<\/span><span style=\"font-size: 13.3333px; color: rgb(9, 0, 255);\">resource\ub85c \uc778\ud574 \uc0c8\ub85c\uc6b4 session\ub4e4\uc774\ucd94\uac00\ub85c block\ub418\uc5b4 \ub098\uac08 \uc218 \uc788\ub2e4. \uc774\ub807\uac8cblocking\uc774 \ud655\ub300\ub418\uc5b4\uc9c0\uba74&nbsp;<\/span><span style=\"font-size: 13.3333px; color: rgb(9, 0, 255);\">\uacb0\uad6d\uc740 \uc2e0\uaddc \uc811\uc18d\uc774 \ud5c8\uc6a9\ub418\uc9c0 \ubabb\ud560 \uc218 \uc788\ub2e4.<\/span><\/b><\/li>\n<ul>\n<li><span style=\"font-size: 13.3333px; color: rgb(9, 0, 255);\"><b>\uc2dc\uc2a4\ud15c \uc790\uc6d0\uc758 \uace0\uac08 \ub610\ub294 \ube44\uc815\uc0c1 \uc0c1\ud0dc\uc758 process \ubc1c\uc0dd\uc73c\ub85c \uc778\ud574 \ub9e4\uc6b0 \ub290\ub9ac\uac8c \uc9c4\ud589\ub418\ub294 \uc138\uc158\uc774 \ubc1c\uc0dd<\/b><\/span><\/li>\n<li><span style=\"font-size: 13.3333px; color: rgb(9, 0, 255);\"><b>Very long transaction \ub610\ub294 query\ub85c \uc778\ud574 block \ub41c session\uc774 \ub2e4\uc218 \ubc1c\uc0dd \ud560 \uacbd\uc6b0<\/b><\/span><\/li>\n<li><span style=\"font-size: 13.3333px; color: rgb(9, 0, 255);\"><b>\ub2e4\uc218\uc758 session\uc774 busy\ud558\uac8c \ub3d9\uc791\uc911\uc778 instance\uc5d0 DDL\ub4f1\uc774 \uc694\uad6c\ub418\ub294 \uacbd\uc6b0<\/b><\/span><\/li>\n<li><span style=\"font-size: 13.3333px; color: rgb(9, 0, 255);\"><b>Slowdown \ubc1c\uc0dd\uc2dc \uc2e0\uaddc \uc811\uc18d\uc5d0 \uc218\ubd84 \uc774\uc0c1 \uc18c\uc694\ub418\uae30\ub3c4 \ud55c\ub2e4.<\/b><\/span><\/li>\n<\/ul>\n<\/ul>\n<p><\/p>\n<p><\/p>\n<p><\/p>\n<p><\/p>\n<p><\/p>\n<p><\/p>\n<p><\/p>\n<p><\/p>\n<p><\/p>\n<p><\/p>\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oracle Database Hang \uc0c1\ud0dc\uc758 \uc815\uc758 1. What`s the problem ? \ud604\uc0c1 \ubc1c\uc2f1\uc2dc \uc0c1\ud669 \uc778\uc9c0 \uc2dc\uac04 \ud544\uc694 \ud604\uc0c1\uc744 \uc815\uc758\ud558\uae30 \uc5b4\ub824\uc6c0 \ub204\uac00 \ud604\uc0c1\uc744 \ubd84\uc11d\ud558\ub294\uac00? \ubb34\uc5c7\uc744 \ud655\uc778\ud558\ub294\uac00? Hang \ud604\uc0c1\uc73c\ub85c \uc778\ud574 \uc0c1\ud669 \ubd84\uc11d \ubd88\uac00 \ubb38\uc81c \uc6d0\uc778\uc744 \ucc3e\uae30 \ubcf4\ub2e4\ub294 Application \/ DBMS\ub97c re-startup 2. Monitoring Oracle Continuously \uc9c0\uc18d\uc801\uc73c\ub85c Instance\uc758 \ub3d9\uc791 \uc0c1\ud0dc\ub97c \uac10\uc2dc\ud558\uace0 logging Performance\ub97c \uc911\uc2ec\uc73c\ub85c \ud55c monitoring\uc774 \uc544\ub2cc \uc7a5\uc560 \uc778\uc9c0 [&hellip;]<\/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":[14],"tags":[355,356,357,358,359,360],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/675"}],"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=675"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/675\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=675"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=675"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=675"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}