Strict Standards: Declaration of Walker_Page::start_lvl() should be compatible with Walker::start_lvl($output) in /home/yumianfeilong/yumianfeilong.com/wp-includes/classes.php on line 584

Strict Standards: Declaration of Walker_Page::end_lvl() should be compatible with Walker::end_lvl($output) in /home/yumianfeilong/yumianfeilong.com/wp-includes/classes.php on line 584

Strict Standards: Declaration of Walker_Page::start_el() should be compatible with Walker::start_el($output) in /home/yumianfeilong/yumianfeilong.com/wp-includes/classes.php on line 584

Strict Standards: Declaration of Walker_Page::end_el() should be compatible with Walker::end_el($output) in /home/yumianfeilong/yumianfeilong.com/wp-includes/classes.php on line 584

Strict Standards: Declaration of Walker_PageDropdown::start_el() should be compatible with Walker::start_el($output) in /home/yumianfeilong/yumianfeilong.com/wp-includes/classes.php on line 603

Strict Standards: Declaration of Walker_Category::start_lvl() should be compatible with Walker::start_lvl($output) in /home/yumianfeilong/yumianfeilong.com/wp-includes/classes.php on line 702

Strict Standards: Declaration of Walker_Category::end_lvl() should be compatible with Walker::end_lvl($output) in /home/yumianfeilong/yumianfeilong.com/wp-includes/classes.php on line 702

Strict Standards: Declaration of Walker_Category::start_el() should be compatible with Walker::start_el($output) in /home/yumianfeilong/yumianfeilong.com/wp-includes/classes.php on line 702

Strict Standards: Declaration of Walker_Category::end_el() should be compatible with Walker::end_el($output) in /home/yumianfeilong/yumianfeilong.com/wp-includes/classes.php on line 702

Strict Standards: Declaration of Walker_CategoryDropdown::start_el() should be compatible with Walker::start_el($output) in /home/yumianfeilong/yumianfeilong.com/wp-includes/classes.php on line 727

Strict Standards: Redefining already defined constructor for class wpdb in /home/yumianfeilong/yumianfeilong.com/wp-includes/wp-db.php on line 58

Deprecated: Assigning the return value of new by reference is deprecated in /home/yumianfeilong/yumianfeilong.com/wp-includes/cache.php on line 99

Strict Standards: Redefining already defined constructor for class WP_Object_Cache in /home/yumianfeilong/yumianfeilong.com/wp-includes/cache.php on line 404

Deprecated: Assigning the return value of new by reference is deprecated in /home/yumianfeilong/yumianfeilong.com/wp-includes/query.php on line 21

Deprecated: Assigning the return value of new by reference is deprecated in /home/yumianfeilong/yumianfeilong.com/wp-includes/theme.php on line 576

Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /home/yumianfeilong/yumianfeilong.com/wp-includes/classes.php:584) in /home/yumianfeilong/yumianfeilong.com/wp-content/plugins/wordpress-automatic-upgrade/wordpress-automatic-upgrade.php on line 92

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/yumianfeilong/yumianfeilong.com/wp-includes/classes.php:584) in /home/yumianfeilong/yumianfeilong.com/wp-content/plugins/wordpress-automatic-upgrade/wordpress-automatic-upgrade.php on line 92

Strict Standards: Redefining already defined constructor for class ftp_base in /home/yumianfeilong/yumianfeilong.com/wp-content/plugins/wordpress-automatic-upgrade/lib/ftp_class.php on line 56

Strict Standards: Redefining already defined constructor for class ftp in /home/yumianfeilong/yumianfeilong.com/wp-content/plugins/wordpress-automatic-upgrade/lib/ftp_class_sockets.php on line 8
玉面飞龙的BLOG » _memory_imm_mode_without_autosga

_memory_imm_mode_without_autosga

November 10th, 2013 | Categories: Boring | Tags:

当compatible升级为11g的时候,_memory_imm_mode_without_autosga默认为TRUE;在这种情况下,即使没有设置SGA_target; sga_max_size等SGA自动管理的参数,在必要的时候,比方说某个pool内存紧缺,Oracle仍然会自动调整各个pool (db cache/shared pool/large pool etc)的大小,Oracle将该参数设置为TRUE的目的应该是尽量避免ORA-4031的发生。

当Oracle自动调整SGA的时候,11.2.0.3的版本,Oracle不会写任何警示信息到alert.log;但相应信息可以从 V$SGA_RESIZE_OPS查看。

SELECT component, oper_type, oper_mode, parameter,  initial_size/1024/1024 init_MB,target_size/1024/1024 target_MB, final_size/1024/1024 final_MB,status, start_time, end_time FROM V$SGA_RESIZE_OPS;

通过disable这个参数,可以绝对保证各个pool size为手工分配(db_cache_size/shared_pool_size etc)。

connect / as sysdbaalter system set "_memory_imm_mode_without_autosga"=FALSE scope=both;

查看一下各个版本隐藏参数的变化,还是很必要的。Oracle总是喜欢低调的调整一些功能,最后给用户一些小诧异。

sga-re-sizes-occurring-despite-ammasmm-being-disabled-oracle-11-2/

_memory_imm_mode_without_autosga - no really ! don’t resize my sga ! I mean it !

Del.icio.us Google书签 Digg Live Bookmark Technorati Furl Yahoo书签 Facebook 百度搜藏 新浪 ViVi 365Key 网摘 天极网摘 和讯网摘 博拉网 POCO 网摘 饭否 QQ 书签 Digbuzz 我挖网 Mister Wong
  1. violin size
    May 13th, 2014 at 04:29
    Quote | #1

    hey there and thank you for your information – I’ve
    certainly picked up anything new from right here.
    I did however expertise a few technical issues
    using this web site, since I experienced to reload the website many times previous
    to I could get it to load correctly. I had been wondering if your
    web host is OK? Not that I am complaining, but
    sluggish loading instances times will very frequently affect your placement in google and could damage your
    high-quality score if advertising and marketing with Adwords.
    Anyway I am adding this RSS to my email and can look
    out for much more of your respective fascinating content.
    Make sure you update this again soon.

  2. jak schudnac z ud
    June 12th, 2014 at 17:05
    Quote | #2

    Asking questions are in fact pleasant thing if you are not understanding anything fully, but this piece of writing provides fastidious
    understanding yet.

  3. diet plan for weight loss
    June 18th, 2014 at 14:21
    Quote | #3

    hello there and thank you for your info – I have definitely picked up something new from right here.
    I did however expertise several technical points using this website,
    since I experienced to reload the website lots of times previous to I could get it to load
    properly. I had been wondering if your hosting is OK?
    Not that I am complaining, but sluggish loading instances times will often affect your placement in google and can damage
    your quality score if ads and marketing with Adwords. Anyway I am adding this RSS to
    my email and could look out for a lot more of your respective fascinating content.
    Ensure that you update this again soon.

  4. detoxing
    June 22nd, 2014 at 00:08
    Quote | #4

    This site really has all the info I wanted concerning this subject and didn’t know who to ask.

  5. diet pills for women
    June 24th, 2014 at 11:58
    Quote | #5

    I like the valuable info you supply to your articles. I’ll bookmark your blog
    and test again here regularly. I am reasonably certain I will be told many new stuff proper right here!
    Good luck for the following!

  6. Alpha Max
    June 30th, 2014 at 13:14
    Quote | #6

    Today, I went to the beach front with my children. I found a sea shell and
    gave it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.” She placed the shell to her ear and screamed.
    There was a hermit crab inside and it pinched her ear. She never wants to go back!
    LoL I know this is entirely off topic but I had to tell someone!

  7. Order Garcinia cambogia formula
    July 1st, 2014 at 18:01
    Quote | #7

    Hi my friend! I want to say that this post is amazing, nice written and come
    with approximately all vital infos. I’d like to peer extra
    posts like this .

  8. Cool website Designs
    July 4th, 2014 at 06:49
    Quote | #8

    This is very interesting, You’re a very skilled blogger.
    I’ve joined your rss feed and look forward to seeking more
    of your fantastic post. Also, I have shared your site in my
    social networks!

  9. advanced test o boost reviews
    July 5th, 2014 at 04:32
    Quote | #9

    This HCA dietary supplement halts the conversion of carbs
    or sugar in in order to really fats so person will get final results
    faster. With HCA, one wouldn’t feel the need to overindulge and will experience more energy.
    This is the key to losing weight and keeping it away.

  10. www.lawbees.com
    July 9th, 2014 at 00:41
    Quote | #10

    Hello to all, it’s actually a pleasant for me to go
    to see this website, it consists of valuable Information.

  11. low carb diet
    July 11th, 2014 at 08:58
    Quote | #11

    It’s nearly impossible to find experienced people on this subject, however, you sound like
    you know what you’re talking about! Thanks

  12. best supplement to gain muscle
    July 12th, 2014 at 08:27
    Quote | #12

    My spouse and I stumbled over here different website and thought I might as well check things out.
    I like what I see so now i’m following you.
    Look forward to checking out your web page for a second time.

  13. walking for weight loss
    July 12th, 2014 at 09:00
    Quote | #13

    What a material of un-ambiguity and preserveness
    of valuable knowledge regarding unpredicted feelings.

  14. freeauction.tk
    July 16th, 2014 at 15:46
    Quote | #14

    Hi to all, how is the whole thing, I think every one is getting more from this web site,
    and your views are nice designed for new users.

  15. handbag shopping online
    July 21st, 2014 at 07:47
    Quote | #15

    You could definitely see your skills in the work you write.
    The world hopes for more passionate writers such as you who are not afraid
    to say how they believe. Always follow your heart.

  16. Having read this I thought it was rather informative.
    I appreciate you taking the time and effort to put this article together.
    I once again find myself spending a significant amount of time both reading and commenting.
    But so what, it was still worthwhile!

  17. best weight loss pills
    July 25th, 2014 at 09:59
    Quote | #17

    I’ve been exploring for a little bit for any high-quality articles or weblog posts
    on this sort of space . Exploring in Yahoo I at last stumbled upon this website.
    Studying this information So i am happy to express that I’ve a very good
    uncanny feeling I came upon just what I needed.
    I most no doubt will make sure to don?t disregard this web site and provides
    it a look on a constant basis.

  18. healthy weight loss plans
    July 28th, 2014 at 23:21
    Quote | #18

    Thanks for some other great article. Where else may anybody get that type of info in such
    a perfect approach of writing? I have a presentation next week, and I am at the look for such
    information.