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 size

Re: SGA size

From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: Wed, 16 Sep 1998 11:55:20 -0700
Message-ID: <Pine.OSF.3.95.980916112258.6526A-100000@gonzo.wolfenet.com>

Well, the SGA is actually composed of more than just the block buffer cache. There's the shared pool, too. In svrmgrl, you can type "show sga" to see all components of the SGA.
--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah

On Wed, 16 Sep 1998, Vinay Joshi wrote:

> Look at db_block_buffers
>
> So you are looking at
> db_block_buffers * db_block_size.
>
> Bertalan GOMBOS wrote in message <35FFE7DE.B652D93C_at_finit.hu>...
> >
> > How can I set the size of SGA? I haven't found any parameter in
> >INIT.ORA which set the SGA size.
Received on Wed Sep 16 1998 - 13:55:20 CDT

Original text of this message

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