Re: SGA SIZE

From: Saar <sxmaxoz_at_us.oracle.com>
Date: Mon, 29 Jun 1998 12:24:41 -0700
Message-ID: <3597E9F9.26AAD0DB@us.oracle.com>

Richard Woods wrote:

> Your variable size also includes database block buffers.
>

no, that's not correct. database blocks are reported separately:

Total System Global Area     105113228 bytes
Fixed Size                       59020 bytes
Variable Size                 84033536 bytes
Database Buffers              20480000 bytes
Redo Buffers                    540672 bytes

> Vinod Kumar "Vini" Anbalahan wrote:
>
> > HAi
> > Could any one help me on this . I am running ORACLE 7.3.4 on HPUX 10.2
> > . I have set up my shared pool size as 9000000 in my init.ora file . When i
> > start the instance . The variable size is showing me 12000000 . I am not
> > able to understand where is the 3MB coming from .

Try select * from v$sgastat; Most of the stuff in the SGA gets reported in the Variable size.Database block HEADERS are one example, as are various lock structures, etc.

--

 __  _    _  __    _ _   _   _ ___  ______________________________
((  /\\  /\\ ||)  |\V/| /\\ /\\ >/  Principal Performance Engineer

_))//-\\//-\\||\ |||||//-\\\\//<_ Oracle Corporation Digital SBU

////////////////// Drop x's in email (spam) //////////////////////

Received on Mon Jun 29 1998 - 14:24:41 CDT