Re: SGA size

Fabio <fabio_at_denhaag.org> wrote in message news:<slrna4o0v2.1ro.fabio_at_tigru.nl>...
> Hello,
>
> I think my question is rather easy, but couldn't find it in the 8.1.7
> docs. Wat sum determines the size of the SGA? One of them is
> db_block_buffers. En the others?

Off the top of my head: shared_pool, log_buffers, and java pool would be the three other main users of SGA space.

Try querying v$sga and look to see what it says in case I missed any.

• Mark D Powell --