{"id":2817,"date":"2018-02-03T13:57:34","date_gmt":"2018-02-03T04:57:34","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=2817"},"modified":"2018-02-03T13:57:34","modified_gmt":"2018-02-03T04:57:34","slug":"awr-%ec%8b%9c%ec%8a%a4%ed%85%9c-%ec%84%b1%eb%8a%a5%ec%9d%b4-%eb%8a%90%eb%a0%a4%ec%a7%88-%eb%95%8c-%ec%8b%9c%ec%8a%a4%ed%85%9c-%eb%b6%80%ed%95%98-%ec%83%81%ed%99%a9-%ec%b6%94%ec%b6%9c-%ec%bf%bc","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=2817","title":{"rendered":"[AWR] \uc2dc\uc2a4\ud15c \uc131\ub2a5\uc774 \ub290\ub824\uc9c8 \ub54c … \uc2dc\uc2a4\ud15c \ubd80\ud558 \uc0c1\ud669 \ucd94\ucd9c \ucffc\ub9ac"},"content":{"rendered":"

<\ucd94\ucd9c \ucffc\ub9ac><\/p>\n

SELECT\ti.db_name, i.instance_number, i.host_name\r\n,\ts.snap_id, s.begin_interval_time, s.secs\r\n,\te1.wait_class, e1.event_name\r\n,\te2.total_Waits - e1.total_Waits as total_waits\r\n,\te2.total_timeouts - e1.total_timeouts as total_timeouts\r\n,\te2.time_waited_micro - e1.time_waited_micro as time_waited_micro\r\n,\t(e2.time_waited_micro - e1.time_waited_micro)\/1000000 as time_waited\r\n,\t(e2.time_waited_micro - e1.time_waited_micro)\/1000000\/s.secs as time_waited_per_second\r\nFROM\t(\r\n\tSELECT\ts.dbid, s.instance_number, s.startup_time\r\n\t, \tsnap_id, begin_interval_time\r\n\t,\tLEAD(snap_id,1) OVER (\r\n\t\t\tPARTITION BY dbid, instance_number, startup_time \r\n\t\t\tORDER BY begin_interval_time) as next_snap_id\r\n\t,\tLEAD(begin_interval_time,1) OVER (\r\n\t\t\tPARTITION BY dbid, instance_number \r\n\t\t\tORDER BY begin_interval_time) as next_begin_interval_time\r\n\t,\tend_interval_time\r\n\t,\t86400*(TO_NUMBER(TO_CHAR(end_interval_time,'J'))\r\n\t       -TO_NUMBER(TO_CHAR(begin_interval_time,'J')))\r\n\t+\t3600*(EXTRACT(HOUR FROM end_interval_time)-EXTRACT(HOUR FROM begin_interval_time))\r\n\t+\t60*(EXTRACT(MINUTE FROM end_interval_time)-EXTRACT(MINUTE FROM begin_interval_time))\r\n\t+\tEXTRACT(SECOND FROM end_interval_time)-EXTRACT(SECOND FROM begin_interval_time) secs\r\n\tFROM\tdba_hist_snapshot s\r\n\tWHERE  s.begin_interval_time > TRUNC(SYSDATE) - 7\r\n\t) s\r\nINNER JOIN dba_hist_database_instance i\r\n\tON i.dbid = s.dbid \r\n\tAND i.instance_number = s.instance_number\r\n\tAND i.startup_time = s.startup_time\t\r\nINNER JOIN dba_hist_system_event e1 --v$system_event\r\n\tON e1.snap_id = s.snap_id\r\n\tAND e1.dbid = s.dbid\r\n\tAND e1.instance_number = s.instance_number\r\nINNER JOIN dba_hist_system_event e2\r\n\tON e2.snap_id = s.next_snap_id\r\n\tAND e2.dbid = s.dbid\r\n\tAND e2.instance_number = s.instance_number\r\nWHERE s.next_snap_id IS NOT NULL\r\nAND  e1.event_id = e2.event_id\r\nAND  e1.wait_class_id = e2.wait_class_id\r\nAND\t( e2.total_Waits > e1.total_Waits\r\n\tOR e2.total_timeouts > e1.total_timeouts\r\n\tOR e2.time_waited_micro > e1.time_waited_micro)\r\nORDER BY 1,2,3,4 ;<\/pre>\n
 <\/p>\n
<\uc218\ud589 \ud654\uba74><\/p>\n
\"\"<\/a><\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
<\ucd94\ucd9c \ucffc\ub9ac> SELECT i.db_name, i.instance_number, i.host_name , s.snap_id, s.begin_interval_time, s.secs , e1.wait_class, e1.event_name , e2.total_Waits – e1.total_Waits as total_waits , e2.total_timeouts – e1.total_timeouts as total_timeouts , e2.time_waited_micro – e1.time_waited_micro as time_waited_micro , (e2.time_waited_micro – e1.time_waited_micro)\/1000000 as time_waited , (e2.time_waited_micro – e1.time_waited_micro)\/1000000\/s.secs as time_waited_per_second FROM ( SELECT s.dbid, s.instance_number, s.startup_time , snap_id, begin_interval_time , LEAD(snap_id,1) OVER […]<\/p>\n","protected":false},"author":1,"featured_media":2499,"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":[9],"tags":[567,69],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/01\/digital4-300x241.jpg?fit=300%2C241","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2817"}],"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=2817"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2817\/revisions"}],"predecessor-version":[{"id":2819,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2817\/revisions\/2819"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2499"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2817"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2817"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2817"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}