{"id":403,"date":"2015-08-24T04:23:10","date_gmt":"2015-08-24T04:23:10","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=403"},"modified":"2015-08-24T04:23:10","modified_gmt":"2015-08-24T04:23:10","slug":"pga-%ec%82%ac%ec%9a%a9%eb%9f%89-%ed%99%95%ec%9d%b8-%ed%95%98%eb%8a%94-%ec%bf%bc%eb%a6%ac","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=403","title":{"rendered":"PGA \uc0ac\uc6a9\ub7c9 \ud655\uc778 \ud558\ub294 \ucffc\ub9ac"},"content":{"rendered":"

PGA\ub97c \uc0ac\uc6a9\ud558\ub294 \uc0ac\uc6a9\ub7c9 \ud655\uc778\uc740 \uac04\ub2e8\ud788 v$sesstat \ubdf0\uc640 v$statname \ubdf0\ub97c \uc870\uc778\ud558\uba74 \ub41c\ub2e4.<\/span><\/p>\n

 <\/span><\/p>\n

\uc790\uc2e0\uc774 \uc0ac\uc6a9\ud558\ub294 pga \uc0ac\uc6a9\ub7c9\uc744 \ud655\uc778\ud558\uae30 \uc704\ud574\uc11c\ub294 \ucd94\uac00\uc801\uc73c\ub85c v$mystat\ubdf0\uc640 \uc870\uc778\uc744 \ud558\uba74\ub41c\ub2e4.<\/span><\/p>\n

 <\/span><\/p>\n

SELECT m.name , t.value<\/span>
FROM v$sesstat t,<\/span>
     v$statname m<\/span>
WHERE  t.statistic# = m.statistic#<\/span>
AND   m.name like ‘%pga%’<\/span>
AND   t.sid = ( SELECT distinct sid FROM v$mystat) ;<\/span><\/p>\n

 <\/span><\/p>\n

NAME                                                    VALUE<\/span>
——————————- ————<\/span>
session pga memory                              1105492<\/span>
session pga memory max                        3333716<\/span><\/p>\n

 <\/span><\/p>\n

 <\/span><\/p>\n

\uc790\uc2e0\uc774 \uc544\ub2cc \ub2e4\ub978 \uc0ac\ub78c\uc758 PGA\uc0ac\uc6a9\ub7c9\uc744 \ubcf4\uae30 \uc704\ud574\uc120 sid\uac12\uc5d0 \ub2e4\ub978 \uc0ac\ub78c\uc758 sid \uac12\uc744 \ub123\uc5b4\uc8fc\uba74 \ub428<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

PGA\ub97c \uc0ac\uc6a9\ud558\ub294 \uc0ac\uc6a9\ub7c9 \ud655\uc778\uc740 \uac04\ub2e8\ud788 v$sesstat \ubdf0\uc640 v$statname \ubdf0\ub97c \uc870\uc778\ud558\uba74 \ub41c\ub2e4.   \uc790\uc2e0\uc774 \uc0ac\uc6a9\ud558\ub294 pga \uc0ac\uc6a9\ub7c9\uc744 \ud655\uc778\ud558\uae30 \uc704\ud574\uc11c\ub294 \ucd94\uac00\uc801\uc73c\ub85c v$mystat\ubdf0\uc640 \uc870\uc778\uc744 \ud558\uba74\ub41c\ub2e4.   SELECT m.name , t.valueFROM v$sesstat t,     v$statname mWHERE  t.statistic# = m.statistic#AND   m.name like ‘%pga%’AND   t.sid = ( SELECT distinct sid FROM v$mystat) ;   NAME                                                    VALUE——————————- ————session pga memory                              1105492session pga memory […]<\/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":[3],"tags":[122,123],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/403"}],"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=403"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/403\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=403"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=403"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=403"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}