Strict Standards: Redefining already defined constructor for class ftp in /home/yumianfeilong/ on line 8
玉面飞龙的BLOG » _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的时候,的版本,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;



_memory_imm_mode_without_autosga - no really ! don’t resize my sga ! I mean it ! 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.

    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.

    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

  19. top rated diet pills
    August 5th, 2014 at 09:22
    Quote | #19

    Everything is very open with a clear explanation of the challenges.
    It was truly informative. Your site is extremely helpful.
    Thank you for sharing!

  20. probiotic supplements
    August 5th, 2014 at 13:06
    Quote | #20

    I’m really enjoying the design and layout of your blog. It’s a very
    easy on the eyes which makes it much more enjoyable for me to come here and visit more often. Did you hire out a developer to create your theme?
    Great work!

  21. n02 black
    August 6th, 2014 at 09:44
    Quote | #21

    Hey! I’m at work surfing around your blog from my new
    apple iphone! Just wanted to say I love reading through your blog and look
    forward to all your posts! Keep up the fantastic work!

  22. face skin care
    August 7th, 2014 at 14:37
    Quote | #22

    Hmm is anyone else experiencing problems with the pictures on this blog loading?
    I’m trying to figure out if its a problem on my end or if it’s
    the blog. Any feedback would be greatly appreciated.

  23. lux Detox erfahrungen
    September 25th, 2014 at 12:32
    Quote | #23

    Useful information. Fortunate me I discovered your
    site by accident, and I’m shocked why this accident didn’t came
    about in advance! I bookmarked it.

  24. garcinia plus dr oz
    September 26th, 2014 at 00:50
    Quote | #24

    I’m amazed, I must say. Seldom do I encounter a blog that’s both equally educative and engaging, and without a doubt, you’ve hit the nail on the
    head. The problem is something which too few men and women are speaking
    intelligently about. Now i’m very happy I found this during my search for something concerning this.

  25. max burn cambogia cuanto cuesta
    September 26th, 2014 at 15:54
    Quote | #25

    It’s really very complex in this full of activity life to listen news on TV, therefore I simply use the web for that purpose, and obtain the newest information.

  26. Shelley
    September 27th, 2014 at 23:34
    Quote | #26

    Thank you for sharing your thoughts. I really appreciate your efforts and I am waiting for
    your further write ups thanks once again.

  27. 12 volt solar Battery charger
    October 3rd, 2014 at 01:02
    Quote | #27

    If some one needs expert view on the topic of blogging
    then i propose him/her to pay a visit this blog, Keep up the nice work.

    October 9th, 2014 at 13:10
    Quote | #28

    With the latest study from PEW Research stating that 95% of teens have
    access to the Internet, 80% of kids have cell phones and 48% have data plans, providing a safe cyber-space should be a priority
    for all parents. They only want your money and they
    want as much of it as they can possibly get.
    Efficiency: Many carriers provide multiple receive emails, so your fax messages
    are automatically delivered to whomever you intend.

  29. wilderness kayak
    October 16th, 2014 at 03:19
    Quote | #29

    Hello all, here every person is sharing these familiarity, thus
    it’s pleasant to read this webpage, and I used to go to see this webpage
    every day.

  30. unclaimed property in
    November 1st, 2015 at 07:22
    Quote | #30

    For example, stocks must be reissued below totally different names and mutual funds
    sent to a unique deal with than other kinds of property.

  31. 四川卫校
    May 19th, 2016 at 11:15
    Quote | #31

    WOW 2016-05-19 11:15:12