Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SGA size
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