{"id":43,"date":"2022-09-22T11:44:35","date_gmt":"2022-09-22T14:44:35","guid":{"rendered":"https:\/\/kappasoft.com.br\/wiki\/?p=43"},"modified":"2022-09-22T11:49:39","modified_gmt":"2022-09-22T14:49:39","slug":"como-verificar-necessidade-de-aumento-de-pga-ou-sga-em-um-banco-oracle-atraves-do-advice","status":"publish","type":"post","link":"https:\/\/kappasoft.com.br\/wiki\/2022\/09\/22\/como-verificar-necessidade-de-aumento-de-pga-ou-sga-em-um-banco-oracle-atraves-do-advice\/","title":{"rendered":"Como verificar necessidade de aumento de PGA ou SGA em um banco ORACLE atrav\u00e9s do ADVICE"},"content":{"rendered":"\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:true,&quot;languageLabel&quot;:&quot;language&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;sql&quot;,&quot;mime&quot;:&quot;text\/x-sql&quot;,&quot;theme&quot;:&quot;material&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:false,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;&quot;,&quot;language&quot;:&quot;SQL&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;sql&quot;}\">SQL&gt; SELECT SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME FROM V$SGA_TARGET_ADVICE;<\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"334\" height=\"284\" src=\"https:\/\/kappasoft.com.br\/wiki\/wp-content\/uploads\/2022\/09\/image-1.png\" alt=\"\" class=\"wp-image-46\" srcset=\"https:\/\/kappasoft.com.br\/wiki\/wp-content\/uploads\/2022\/09\/image-1.png 334w, https:\/\/kappasoft.com.br\/wiki\/wp-content\/uploads\/2022\/09\/image-1-300x255.png 300w, https:\/\/kappasoft.com.br\/wiki\/wp-content\/uploads\/2022\/09\/image-1-60x51.png 60w, https:\/\/kappasoft.com.br\/wiki\/wp-content\/uploads\/2022\/09\/image-1-150x128.png 150w\" sizes=\"auto, (max-width: 334px) 100vw, 334px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:true,&quot;languageLabel&quot;:&quot;language&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;sql&quot;,&quot;mime&quot;:&quot;text\/x-sql&quot;,&quot;theme&quot;:&quot;material&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:false,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;&quot;,&quot;language&quot;:&quot;SQL&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;sql&quot;}\">SQL&gt; SELECT PGA_TARGET_FOR_ESTIMATE,PGA_TARGET_FACTOR,ESTD_EXTRA_BYTES_RW FROM V$PGA_TARGET_ADVICE;<\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"499\" height=\"307\" src=\"https:\/\/kappasoft.com.br\/wiki\/wp-content\/uploads\/2022\/09\/image-2.png\" alt=\"\" class=\"wp-image-47\" srcset=\"https:\/\/kappasoft.com.br\/wiki\/wp-content\/uploads\/2022\/09\/image-2.png 499w, https:\/\/kappasoft.com.br\/wiki\/wp-content\/uploads\/2022\/09\/image-2-300x185.png 300w, https:\/\/kappasoft.com.br\/wiki\/wp-content\/uploads\/2022\/09\/image-2-60x37.png 60w, https:\/\/kappasoft.com.br\/wiki\/wp-content\/uploads\/2022\/09\/image-2-150x92.png 150w\" sizes=\"auto, (max-width: 499px) 100vw, 499px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,2],"tags":[],"class_list":["post-43","post","type-post","status-publish","format-standard","hentry","category-banco-de-dados","category-oracle"],"_links":{"self":[{"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/posts\/43","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/comments?post=43"}],"version-history":[{"count":3,"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/posts\/43\/revisions"}],"predecessor-version":[{"id":49,"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/posts\/43\/revisions\/49"}],"wp:attachment":[{"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/media?parent=43"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/categories?post=43"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/tags?post=43"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}