Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sga_max_size - pre-allocated at instance startup?

Re: sga_max_size - pre-allocated at instance startup?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sat, 11 Mar 2006 11:01:58 +0800
Message-ID: <44123DA6.F97@yahoo.com>


Jonathan Lewis wrote:
>
> "Mladen Gogala" <gogala_at_sbcglobal.net> wrote in message
> news:pan.2006.03.04.03.21.40.53245_at_sbcglobal.net...
> >
> > Solaris has a perversion called "intimate shared memory, which
> > allows processes to share page table as well as the page contents.
> > From Oracle 7.3 all the way to 8i there was a parameter called
> > "use_intimately_shared_memory", which was supposed to be set to true
> > on Solaris. That parameter would enable Oracle to use XXX-shared
> > memory and gain some performance. Another thing with which many
> > vendors were toying was the post-wait pseudo device, which was
> > faster then the semaphore operations. It was originally developed
> > by SGI but I've seen it on AIX and Solaris as well.
> > I do believe that Oracle was using classic shmget,shmat and similar
> > calls wherever available and would switch to specialized libraries,
> > based on parameters. Of course, I never worked for Oracle and I've
> > never seen the source code, so I don't really know.
> >
> > --
> > http://www.mgogala.com
> >
>
> Talking of intimate shared memory.
>
> Your earlier comment about Solaris being the one Unix
> platform that doesn't allocate the entire memory on startup
> is, I believe, only true if you have MPT enabled ISM
>
> --
> Regards
>
> Jonathan Lewis
> http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
> Cost Based Oracle: Fundamentals
> http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

some useful information in metalink notes 151222.1, 317257.1 and 268884.1

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------
Received on Fri Mar 10 2006 - 21:01:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US