Tuesday, April 10, 2007

Automatic Memory Management( Oracle 11g New Features)

Automatic Memory Management ( Oracle 11g New Features)

Well in 10g SGA can be auto tune and 11g it extended to PGA as well ie SGA and PGA both can auto tune
( i would say , i understood this much only
11g memory management = SGA auto tune + PGA auto tune )

For auto memory, we need to set parameter MEMORY_TARGET and MEMORY_MAX_TARGET. Parameter MEMORY_TARGET is dynamic, we can change the target memory size at any time without restarting the database. The MEMORY_MAX_TARGET serves as an upper limit so that we cannot by mistake set the MEMORY_TARGET size too high. Because certain SGA components eithercannot easily shrink or must remain at a minimum size, the database also prevents you from setting thetarget memory size too low.


If MEMORY_TARGET is set to a non-zero value:

  • If SGA_TARGET and PGA_AGGREGATE_TARGET are set, they will be considered the min value for the sizes of SGA and the PGA respectively. MEMORY_TARGET can take values from SGA_TARGET + PGA_AGGREGATE_TARGET to MEMORY_MAX_SIZE.
  • If SGA_TARGET is set and PGA_AGGREGATE_TARGET is not set, we will still auto-tune both parameters. PGA_AGGREGATE_TARGET will be initialized to a value of (MEMORY_TARGET-SGA_TARGET).
  • If PGA_AGGREGATE_TARGET is set and SGA_TARGET is not set, we will still auto-tune both parameters. SGA_TARGET will be initialized to a value of min(MEMORY_TARGET-PGA_AGGREGATE_TARGET, SGA_MAX_SIZE (if set by the user)) and will auto-tune subcomps.

7 comments:

  1. welcome to the wow power leveling, cheap service site,WoW Gold buy cheap wow gold,wow gold,world of warcraft buy wow power leveling

    ReplyDelete
  2. http://icollaborate.blogspot.com/2007/04/10-skype-tips-for-advanced.html

    ReplyDelete
  3. When the Wow Gold wolf finally found the wow gold cheap hole in the chimney he crawled cheap wow gold down and KERSPLASH right into that kettle of water and that was cheapest wow gold the end of his troubles with the big bad wolf.

    game4power.
    The next day the Buy Wow Goldlittle pig invited hisbuy gold wow mother over . She said "You see it is just as Cheapest wow goldI told you. The way to get along in the world is to do world of warcraft gold things as well as you can." Fortunately for that little pig, he buy cheap wow gold learned that lesson. And he just wow gold lived happily ever after!.

    ReplyDelete
  4. When the Wow Gold wolf finally found the wow gold cheap hole in the chimney he crawled cheap wow gold down and KERSPLASH right into that kettle of water and that was cheapest wow gold the end of his troubles with the big bad wolf.

    game4power.
    The next day the Buy Wow Goldlittle pig invited hisbuy gold wow mother over . She said "You see it is just as Cheapest wow goldI told you. The way to get along in the world is to do world of warcraft gold things as well as you can." Fortunately for that little pig, he buy cheap wow gold learned that lesson. And he just wow gold lived happily ever after!.

    ReplyDelete
  5. very nice blog!
    I was worthless until I was sold
    Once you purchased me,
    You made me Wow Gold.
    Now everyone wants to Buy wow Gold.v

    ReplyDelete
  6. Blogs are so informative where we get lots of information on any topic. Nice job keep it up!!
    _____________________________

    Technology Dissertation

    ReplyDelete
  7. This kind of information is very limited on internet. Nice to find the post related to my searching criteria. Your updated and informative post will be appreciated by blog loving people.

    Online Degree's Dissertation

    ReplyDelete

Google