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 _Variable Size???

Re: SGA _Variable Size???

From: Kenny Gump <kgump_at_mylanlabs.com>
Date: Mon, 11 Jan 1999 08:15:40 -0500
Message-ID: <3699f994.0@news.mountain.net>


There are about 40-50 of the initialization parameters which need space in the SGA. Examples, dml_locks, db_files, etc. If you look, I believe in the Administrators Reference Guide it discusses these.

Kenny Gump
OCP 7.3 DBA



alt_at_interchange.co.uk wrote in message <77cfua$5jl$1_at_nnrp1.dejanews.com>...
>Hi
>
>Could someone please tell me what other elements apart from those in the
>SHARED_SQL_POOL make up the VARIABLE SIZE in the SGA?
>
>For example my SHARED_SQL_POOL size is 9Mb but the variable size is shown
as
>nearly double that at 17.7Mb. How's this figure derived?
>
>Please email response to alt_at_interchange.co.uk
>
>Thanks for the help.
>
>Al
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Jan 11 1999 - 07:15:40 CST

Original text of this message

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