{"id":149,"date":"2008-10-03T23:34:00","date_gmt":"2008-10-03T21:34:00","guid":{"rendered":"http:\/\/antynet.pl\/index.php\/2008\/10\/03\/oracle-memory\/"},"modified":"2010-08-24T22:43:55","modified_gmt":"2010-08-24T20:43:55","slug":"oracle-memory","status":"publish","type":"post","link":"https:\/\/www.antynet.pl\/index.php\/2008\/10\/03\/oracle-memory\/","title":{"rendered":"ORACLE MEMORY"},"content":{"rendered":"<p><span style=\"font-weight: bold;\">ustawianie pami\u0119ci:<\/span><br \/><span style=\"font-weight: bold;\">SGA<\/span><br \/>parametr sga_target mo\u017cna zmienia\u0107 dynamicznie do warto\u015b\u0107 sga_max_size, natomiast parametr sga_max_size mo\u017ce by\u0107 zmianiany tylko statycznie czyli z restartem bazy<br \/>sga_target > 0 &#8211; automatyczne zarz\u0105dzanie pami\u0119ci\u0105<br \/>a wpisy:<\/p>\n<ul>\n<li>db_cache_size,<\/li>\n<li>java_pool_size,<\/li>\n<li>large_pool_size,<\/li>\n<li>shared_pool_size<\/li>\n<\/ul>\n<p>oznaczaj\u0105 ich minimaln\u0105 warto\u015b\u0107<\/p>\n<p>sga_target = 0 &#8211; r\u0119czne ustawianie pami\u0119ci i powy\u017csze parametry ustawi\u0107 r\u0119cznie<\/p>\n<p>sga_max_size &#8211; do jakiej warto\u015bci mo\u017cna r\u0119cznie podwy\u017cszy\u0107 sga_target<\/p>\n<p>SHARED_POOL_SIZE &#8211; pami\u0119\u0107 w Bajtach dla wsp\u00f3\u0142dzielnonych SQL i PL\/SQL i dla danych s\u0142ownikowych (Library Cache, Data Dictionary Cache)<br \/>DB_CACHE_SIZE &#8211; rozmiar bufora danych dla podstawowego rozmiaru bloku danych<br \/><span style=\"font-weight: bold;\">PGA<\/span><br \/>PGA &#8211; (dla procesu) pami\u0119\u0107 zawieraj\u0105ca kursor, zmienne, obszary sortowania, \u0142aczenia itp.<br \/><span style=\"font-family:arial;\"><span style=\"font-weight: bold;\">ustawienie pami\u0119ci w spfile:<\/span><br \/>ALTER SYSTEM SET sga_max_size=[size]M scope=spfile;<br \/>ALTER SYSTEM SET sga_target=[size]M scope=spfile;<br \/><span style=\"font-weight: bold;\">sprawdzenie zu\u017cycia pami\u0119ci:<br \/><\/span>SELECT name,bytes\/(1024*1024) as MB FROM v$sgainfo;<br \/>SELECT component, min(final_size) low, (min(final_size\/1024\/1024)) lowMB,<\/span><br \/><span style=\"font-family:arial;\">           max(final_size) high, (max(final_size\/1024\/1024)) highMB<\/span><br \/><span style=\"font-family:arial;\">FROM v$sga_resize_ops GROUP BY component  ORDER BY component;<br \/><span style=\"font-weight: bold;\">sprawdzenie ustawie\u0144 pami\u0119ci:<br \/><\/span><span>SHOW SGA<\/span><span style=\"font-weight: bold;\"><\/span><\/span><\/p>\n<div><span style=\"font-family:arial;\"><span style=\"font-weight: bold;\"><span class=\"Apple-style-span\" style=\"font-weight: normal;\">SELECT * FROM v$sgastat;<\/span><\/span><\/span><\/div>\n<div><span style=\"font-family:arial;\"><span style=\"font-weight: bold;\"><span class=\"Apple-style-span\" style=\"font-weight: normal;\">SELECT * FROM\u00a0<span class=\"Apple-tab-span\" style=\"white-space:pre\"> <\/span>v$pgastat;<br \/><\/span><\/span>SELECT name, value FROM v$parameter WHERE name in (&#8217;sga_max_size&#8217;, 'shared_pool_size&#8217;,&#8217;db_cache_size&#8217;, 'large_pool_size&#8217;,&#8217;java_pool_size&#8217;);<\/span><\/div>\n<div><span class=\"Apple-style-span\" style=\"font-family: arial;\">SELECT * FROM v$sgastat WHERE name LIKE 'free memory&#8217;;<\/span><\/div>\n","protected":false},"excerpt":{"rendered":"<p>ustawianie pami\u0119ci:SGAparametr sga_target mo\u017cna zmienia\u0107 dynamicznie do warto\u015b\u0107 sga_max_size, natomiast parametr sga_max_size mo\u017ce by\u0107 zmianiany tylko statycznie czyli z restartem bazysga_target > 0 &#8211; automatyczne zarz\u0105dzanie pami\u0119ci\u0105a wpisy: db_cache_size, java_pool_size, large_pool_size, shared_pool_size oznaczaj\u0105 ich minimaln\u0105 warto\u015b\u0107 sga_target = 0 &#8211; r\u0119czne ustawianie pami\u0119ci i powy\u017csze parametry ustawi\u0107 r\u0119cznie sga_max_size &#8211; do jakiej warto\u015bci mo\u017cna r\u0119cznie [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[80],"tags":[67],"class_list":["post-149","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle-memory"],"_links":{"self":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/149","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/comments?post=149"}],"version-history":[{"count":1,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/149\/revisions"}],"predecessor-version":[{"id":205,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/149\/revisions\/205"}],"wp:attachment":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/media?parent=149"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/categories?post=149"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/tags?post=149"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}