{"id":3913,"date":"2018-06-15T10:32:00","date_gmt":"2018-06-15T01:32:00","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=3913"},"modified":"2018-06-15T10:32:00","modified_gmt":"2018-06-15T01:32:00","slug":"book-script-%ec%8b%9c%ea%b0%84%eb%8c%80-%eb%b3%84-redo-log-%eb%b0%9c%ec%83%9d%eb%9f%89-%ed%99%95%ec%9d%b8%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=3913","title":{"rendered":"[Book Script] \uc2dc\uac04\ub300 \ubcc4 Redo Log \ubc1c\uc0dd\ub7c9 \ud655\uc778\ud558\uae30"},"content":{"rendered":"

 <\/p>\n

select  thread# \"Thread#\",\r\n substr(to_char(first_time,'yyyy\/mm\/dd'),1,10) \"Day\",\r\n decode(sum(decode(substr(to_char(first_time,'HH24'),1,2),'00',1,0)),0,0,sum(decode(substr(to_char(first_time,'HH24'),1,2),'00',1,0))) \"00\",\r\n decode(sum(decode(substr(to_char(first_time,'HH24'),1,2),'01',1,0)),0,0,sum(decode(substr(to_char(first_time,'HH24'),1,2),'01',1,0))) \"01\",\r\n decode(sum(decode(substr(to_char(first_time,'HH24'),1,2),'02',1,0)),0,0,sum(decode(substr(to_char(first_time,'HH24'),1,2),'02',1,0))) \"02\",\r\n decode(sum(decode(substr(to_char(first_time,'HH24'),1,2),'03',1,0)),0,0,sum(decode(substr(to_char(first_time,'HH24'),1,2),'03',1,0))) \"03\",\r\n decode(sum(decode(substr(to_char(first_time,'HH24'),1,2),'04',1,0)),0,0,sum(decode(substr(to_char(first_time,'HH24'),1,2),'04',1,0))) \"04\",\r\n decode(sum(decode(substr(to_char(first_time,'HH24'),1,2),'05',1,0)),0,0,sum(decode(substr(to_char(first_time,'HH24'),1,2),'05',1,0))) \"05\",\r\n decode(sum(decode(substr(to_char(first_time,'HH24'),1,2),'06',1,0)),0,0,sum(decode(substr(to_char(first_time,'HH24'),1,2),'06',1,0))) \"06\",\r\n decode(sum(decode(substr(to_char(first_time,'HH24'),1,2),'07',1,0)),0,0,sum(decode(substr(to_char(first_time,'HH24'),1,2),'07',1,0))) \"07\",\r\n decode(sum(decode(substr(to_char(first_time,'HH24'),1,2),'08',1,0)),0,0,sum(decode(substr(to_char(first_time,'HH24'),1,2),'08',1,0))) \"08\",\r\n decode(sum(decode(substr(to_char(first_time,'HH24'),1,2),'09',1,0)),0,0,sum(decode(substr(to_char(first_time,'HH24'),1,2),'09',1,0))) \"09\",\r\n decode(sum(decode(substr(to_char(first_time,'HH24'),1,2),'10',1,0)),0,0,sum(decode(substr(to_char(first_time,'HH24'),1,2),'10',1,0))) \"10\",\r\n decode(sum(decode(substr(to_char(first_time,'HH24'),1,2),'11',1,0)),0,0,sum(decode(substr(to_char(first_time,'HH24'),1,2),'11',1,0))) \"11\",\r\n decode(sum(decode(substr(to_char(first_time,'HH24'),1,2),'12',1,0)),0,0,sum(decode(substr(to_char(first_time,'HH24'),1,2),'12',1,0))) \"12\",\r\n decode(sum(decode(substr(to_char(first_time,'HH24'),1,2),'13',1,0)),0,0,sum(decode(substr(to_char(first_time,'HH24'),1,2),'13',1,0))) \"13\",\r\n decode(sum(decode(substr(to_char(first_time,'HH24'),1,2),'14',1,0)),0,0,sum(decode(substr(to_char(first_time,'HH24'),1,2),'14',1,0))) \"14\",\r\n decode(sum(decode(substr(to_char(first_time,'HH24'),1,2),'15',1,0)),0,0,sum(decode(substr(to_char(first_time,'HH24'),1,2),'15',1,0))) \"15\",\r\n decode(sum(decode(substr(to_char(first_time,'HH24'),1,2),'16',1,0)),0,0,sum(decode(substr(to_char(first_time,'HH24'),1,2),'16',1,0))) \"16\",\r\n decode(sum(decode(substr(to_char(first_time,'HH24'),1,2),'17',1,0)),0,0,sum(decode(substr(to_char(first_time,'HH24'),1,2),'17',1,0))) \"17\",\r\n decode(sum(decode(substr(to_char(first_time,'HH24'),1,2),'18',1,0)),0,0,sum(decode(substr(to_char(first_time,'HH24'),1,2),'18',1,0))) \"18\",\r\n decode(sum(decode(substr(to_char(first_time,'HH24'),1,2),'19',1,0)),0,0,sum(decode(substr(to_char(first_time,'HH24'),1,2),'19',1,0))) \"19\",\r\n decode(sum(decode(substr(to_char(first_time,'HH24'),1,2),'20',1,0)),0,0,sum(decode(substr(to_char(first_time,'HH24'),1,2),'20',1,0))) \"20\",\r\n decode(sum(decode(substr(to_char(first_time,'HH24'),1,2),'21',1,0)),0,0,sum(decode(substr(to_char(first_time,'HH24'),1,2),'21',1,0))) \"21\",\r\n decode(sum(decode(substr(to_char(first_time,'HH24'),1,2),'22',1,0)),0,0,sum(decode(substr(to_char(first_time,'HH24'),1,2),'22',1,0))) \"22\",\r\n decode(sum(decode(substr(to_char(first_time,'HH24'),1,2),'23',1,0)),0,0,sum(decode(substr(to_char(first_time,'HH24'),1,2),'23',1,0))) \"23\",\r\n decode(sum(1),0,0,sum(1)) \"Per Day\"\r\nfrom v$log_history\r\nwhere first_time >= trunc(sysdate-7)\r\ngroup by thread#,substr(to_char(first_time,'yyyy\/mm\/dd'),1,10)\r\norder by thread#,substr(to_char(first_time,'yyyy\/mm\/dd'),1,10) desc\r\n\/<\/pre>\n","protected":false},"excerpt":{"rendered":"
  select thread# “Thread#”, substr(to_char(first_time,’yyyy\/mm\/dd’),1,10) “Day”, decode(sum(decode(substr(to_char(first_time,’HH24′),1,2),’00’,1,0)),0,0,sum(decode(substr(to_char(first_time,’HH24′),1,2),’00’,1,0))) “00”, decode(sum(decode(substr(to_char(first_time,’HH24′),1,2),’01’,1,0)),0,0,sum(decode(substr(to_char(first_time,’HH24′),1,2),’01’,1,0))) “01”, decode(sum(decode(substr(to_char(first_time,’HH24′),1,2),’02’,1,0)),0,0,sum(decode(substr(to_char(first_time,’HH24′),1,2),’02’,1,0))) “02”, decode(sum(decode(substr(to_char(first_time,’HH24′),1,2),’03’,1,0)),0,0,sum(decode(substr(to_char(first_time,’HH24′),1,2),’03’,1,0))) “03”, decode(sum(decode(substr(to_char(first_time,’HH24′),1,2),’04’,1,0)),0,0,sum(decode(substr(to_char(first_time,’HH24′),1,2),’04’,1,0))) “04”, decode(sum(decode(substr(to_char(first_time,’HH24′),1,2),’05’,1,0)),0,0,sum(decode(substr(to_char(first_time,’HH24′),1,2),’05’,1,0))) “05”, decode(sum(decode(substr(to_char(first_time,’HH24′),1,2),’06’,1,0)),0,0,sum(decode(substr(to_char(first_time,’HH24′),1,2),’06’,1,0))) “06”, decode(sum(decode(substr(to_char(first_time,’HH24′),1,2),’07’,1,0)),0,0,sum(decode(substr(to_char(first_time,’HH24′),1,2),’07’,1,0))) “07”, decode(sum(decode(substr(to_char(first_time,’HH24′),1,2),’08’,1,0)),0,0,sum(decode(substr(to_char(first_time,’HH24′),1,2),’08’,1,0))) “08”, decode(sum(decode(substr(to_char(first_time,’HH24′),1,2),’09’,1,0)),0,0,sum(decode(substr(to_char(first_time,’HH24′),1,2),’09’,1,0))) “09”, decode(sum(decode(substr(to_char(first_time,’HH24′),1,2),’10’,1,0)),0,0,sum(decode(substr(to_char(first_time,’HH24′),1,2),’10’,1,0))) “10”, decode(sum(decode(substr(to_char(first_time,’HH24′),1,2),’11’,1,0)),0,0,sum(decode(substr(to_char(first_time,’HH24′),1,2),’11’,1,0))) “11”, decode(sum(decode(substr(to_char(first_time,’HH24′),1,2),’12’,1,0)),0,0,sum(decode(substr(to_char(first_time,’HH24′),1,2),’12’,1,0))) “12”, decode(sum(decode(substr(to_char(first_time,’HH24′),1,2),’13’,1,0)),0,0,sum(decode(substr(to_char(first_time,’HH24′),1,2),’13’,1,0))) “13”, decode(sum(decode(substr(to_char(first_time,’HH24′),1,2),’14’,1,0)),0,0,sum(decode(substr(to_char(first_time,’HH24′),1,2),’14’,1,0))) “14”, decode(sum(decode(substr(to_char(first_time,’HH24′),1,2),’15’,1,0)),0,0,sum(decode(substr(to_char(first_time,’HH24′),1,2),’15’,1,0))) “15”, decode(sum(decode(substr(to_char(first_time,’HH24′),1,2),’16’,1,0)),0,0,sum(decode(substr(to_char(first_time,’HH24′),1,2),’16’,1,0))) “16”, decode(sum(decode(substr(to_char(first_time,’HH24′),1,2),’17’,1,0)),0,0,sum(decode(substr(to_char(first_time,’HH24′),1,2),’17’,1,0))) “17”, decode(sum(decode(substr(to_char(first_time,’HH24′),1,2),’18’,1,0)),0,0,sum(decode(substr(to_char(first_time,’HH24′),1,2),’18’,1,0))) “18”, decode(sum(decode(substr(to_char(first_time,’HH24′),1,2),’19’,1,0)),0,0,sum(decode(substr(to_char(first_time,’HH24′),1,2),’19’,1,0))) “19”, decode(sum(decode(substr(to_char(first_time,’HH24′),1,2),’20’,1,0)),0,0,sum(decode(substr(to_char(first_time,’HH24′),1,2),’20’,1,0))) “20”, decode(sum(decode(substr(to_char(first_time,’HH24′),1,2),’21’,1,0)),0,0,sum(decode(substr(to_char(first_time,’HH24′),1,2),’21’,1,0))) “21”, decode(sum(decode(substr(to_char(first_time,’HH24′),1,2),’22’,1,0)),0,0,sum(decode(substr(to_char(first_time,’HH24′),1,2),’22’,1,0))) “22”, decode(sum(decode(substr(to_char(first_time,’HH24′),1,2),’23’,1,0)),0,0,sum(decode(substr(to_char(first_time,’HH24′),1,2),’23’,1,0))) “23”, decode(sum(1),0,0,sum(1)) […]<\/p>\n","protected":false},"author":1,"featured_media":3406,"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":[1094],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/Epi-194-M2M.jpg?fit=425%2C282","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3913"}],"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=3913"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3913\/revisions"}],"predecessor-version":[{"id":3914,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3913\/revisions\/3914"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/3406"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3913"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3913"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3913"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}