Re: SGA _Variable Size???

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 12 Jan 1999 21:28:45 -0000
Message-ID: <916178136.19434.2.nnrp-08.9e984b29@news.demon.co.uk>

One of the biggest extras could be the db block buffer headers. On Oracle 8 the buffer header accounts for 249-ish bytes of variable

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

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 Tue Jan 12 1999 - 15:28:45 CST