{"id":50,"date":"2020-07-07T16:09:49","date_gmt":"2020-07-07T07:09:49","guid":{"rendered":"http:\/\/www.shamonabe.com\/?p=50"},"modified":"2020-07-07T16:09:50","modified_gmt":"2020-07-07T07:09:50","slug":"post-50","status":"publish","type":"post","link":"http:\/\/www.shamonabe.com\/?p=50","title":{"rendered":"PGA\u3001UGA\u306e\u30bb\u30c3\u30b7\u30e7\u30f3\u3054\u3068\u306e\u4f7f\u7528\u91cf\u3092\u7b97\u51fa"},"content":{"rendered":"<p>\u4ee5\u4e0b\u306eSQL\u3092\u5b9f\u884c<\/p>\n<p><code>select<br \/>\nsum(decode(sn.name, 'session pga memory', ss.value, NULL)) \"PGA USED\",<br \/>\nsum(decode(sn.name, 'session uga memory', ss.value, NULL)) ,<br \/>\n(select username from v$session where sid=ss.sid) \"USENAME\",<br \/>\nss.sid<br \/>\nfrom<br \/>\nv$mystat ss,<br \/>\nv$statname sn<br \/>\nwhere<br \/>\nss.statistic# = sn.statistic#<br \/>\nand sn.name in ('session pga memory', 'session uga memory')<br \/>\ngroup by ss.sid;<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4ee5\u4e0b\u306eSQL\u3092\u5b9f\u884c select sum(decode(sn.name, &#8216;session pga memory&#8217;, s<\/p>\n<p><a class=\"more-link\" href=\"http:\/\/www.shamonabe.com\/?p=50\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/posts\/50"}],"collection":[{"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=50"}],"version-history":[{"count":1,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/posts\/50\/revisions"}],"predecessor-version":[{"id":51,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/posts\/50\/revisions\/51"}],"wp:attachment":[{"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=50"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=50"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=50"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}