Re: show sga / what's variable size

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: 2000/06/06
Message-ID: <393d8e38.133394831@news.eagles.bbs.net.au>#1/1

Hi Doug,

It is largely the "permanent memory" for the fixed tables, such as the buffer headers, processes, sessions, transactions, enqueue resources, and so on. The size is dependent on all those parameter settings. You can see the permanent memory in X$KSMSP. It is explained more fully in my book.

Regards,
Steve Adams

http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/

On Tue, 06 Jun 2000 19:30:52 -0400, Doug Cowles <dcowles_at_i84.net> wrote:

>When doing a show sga.. the variable size appears to be about 2MB
>bigger than shared pool setting as I size the pool up and down.. why?
>What's the 2 MB?
>Oracle 8.1.5 on AIX 4.3.2.
Received on Tue Jun 06 2000 - 00:00:00 CDT