{"provider_url":"https://hatena.blog","title":"MEMORY_TARGET","version":"1.0","author_url":"https://blog.hatena.ne.jp/atsukanrock/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fatsukanrock.hatenablog.com%2Fentry%2F20090303%2F1236060139\" title=\"MEMORY_TARGET - atsukanrock\u306e\u30d6\u30ed\u30b0\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","image_url":null,"published":"2009-03-03 15:02:19","url":"https://atsukanrock.hatenablog.com/entry/20090303/1236060139","blog_title":"atsukanrock\u306e\u30d6\u30ed\u30b0","height":"190","type":"rich","description":"Oracle 11g\u304b\u3089\u306e\u6a5f\u80fd\u306b\u3001\u300c\u81ea\u52d5\u30e1\u30e2\u30ea\u7ba1\u7406\u300d\u3068\u3044\u3046\u306e\u304c\u3042\u308b\u305d\u3046\u3060\u3002MEMORY_TARGET\u521d\u671f\u5316\u30d1\u30e9\u30e1\u30fc\u30bf\uff08\u304a\u3088\u3073MEMORY_MAX_TARGET\uff09\u3067\u8a2d\u5b9a\u3067\u304d\u308b\u305d\u3046\u3067\u3001SGA\u3068PGA\u306e\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u306e\u5408\u8a08\u3055\u3048\u6307\u5b9a\u3059\u308c\u3070\u3001\u5f8c\u306fOracle\u304c\u81ea\u52d5\u7684\u306b\uff08\u9069\u5207\u306b\uff09\u5185\u8a33\u3092\u6c7a\u3081\u3066\u304f\u308c\u308b\u3068\u3044\u3046\u3082\u306e\u3060\u3002 10g\u3067\u3042\u308c\u3070SGA_TARGET*1\uff0bPGA_AGGREGATE_TARGET*2\u3067\u8a2d\u5b9a\u3057\u3066\u3044\u305f\u306e\u3060\u304c\u300111g\u3067\u306f\u3088\u308a\u7c21\u5358\u306b\u306a\u3063\u305f\u3002 *1:10g\u304b\u3089\u5229\u7528\u53ef\u80fd *2:9i\u304b\u3089\u5229\u7528\u53ef\u80fd","width":"100%","categories":["Oracle"],"provider_name":"Hatena Blog","blog_url":"https://atsukanrock.hatenablog.com/","author_name":"atsukanrock"}