Re: ASMM experiences

"hpuxrac" <johnbhurley@xxxxxxxxxxxxx> wrote in message
news:1192108831.427856.221500@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Fair enough but there's a middle ground that many people are
considering. Allow oracle "some degree" of moving memory around but
set minimum sizes for shared_pool, buffer pools etc so that oracle
cannot force certain memory areas to go below those minimum sizes.

In effect you constrain ASMM so that it only has a "reasonable
amount" ( whatever that means in your environment ) of memory to add
or subtract pool definitions with.

In the configuration you describe though it would not probably be
worthwhile to implement like that since the shared pool is likely to
get all of that "reasonable amount" anyway.



There was an interesting range of comments on
http://jonathanlewis.wordpress.com/2006/12/04/resizing-the-sga/

that tend to agree with your view. It's okay to let it be automatic,
just so long as it's reasonably constrained. (Getting the correct
value for "reasonably" is the difficult bit).

--
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html



.

Relevant Pages

  • Re: 2GB limit of memory for Oracle on WIndows 32 bit
    ... Oracle has limit of 2GB memory. ... Pool, PGA, all the rest needs to sit in 'base' memory no matter what. ... bur rest I can use for buffer pools. ...
    (comp.databases.oracle.server)
  • Re: Oracle and small tables
    ... Not true, in fact by placing subject small tables in the "keep" pool, ... Memory is cheap these days. ... I have heard that Oracle is great server for databases which contain ...
    (comp.databases.oracle.server)
  • RE: 2003 SBS stalling randomly
    ... A memory leak occurs in an application using the Volume Shadow Copy Service ... Poolmon displays data that the ... The data is grouped by pool allocation tag. ... Press P twice to display allocations from only the paged pool. ...
    (microsoft.public.windows.server.sbs)
  • RE: 2003 SBS stalling randomly
    ... and I am experiencing the same stalling of SBS 2003 ... memory and Store using upwards of 750 MB of memory. ... The server was unable to allocate from the system nonpaged pool because the ... Press P twice to display allocations from only the paged pool. ...
    (microsoft.public.windows.server.sbs)
  • [RFC PATCH 0/4] (Take 2): transcendent memory ("tmem") for Linux
    ... Normal memory is directly addressable by the kernel, ... Transcendent memory, or "tmem" for short, provides a well-defined API to ... The combination of a 32-bit pool id, a 64-bit object id, and a 32-bit ...
    (Linux-Kernel)