SGA SIZE

No, Richard was correct, sort of.

'Variable Size' is made up from a number of parameters, but not all on a 1 to 1 basis. They need multiplying (or dividing) by various factors, as follows:-

	shared_pool_size	x 1
       	db_block_buffers	x 362
	log_buffers	 	/ 64
	process			x 6170
	dml_locks		x 180
	db_files			x 449

	plus approx 150k for reasons I have been unable to figure.

Hope that helps
Allan

> ----------
> From: Saar[SMTP:sxmaxoz_at_us.oracle.com]
> Posted At: Monday, June 29, 1998 8:24 PM
> Posted To: server
> Conversation: SGA SIZE
> Subject: Re: SGA SIZE
>
> 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 Wed Jul 01 1998 - 09:50:55 CDT