From: steve.adams@ixora.com.au (Steve Adams)
Subject: Re: show sga / what's variable size
Date: 2000/06/06
Message-ID: <393d8e38.133394831@news.eagles.bbs.net.au>#1/1
References: <g92rjs0ndhfrc6a2qlrk3lp9u8fri0kvd8@4ax.com>
X-Complaints-To: abuse@telstra.net
X-Trace: nsw.nnrp.telstra.net 960335294 203.17.124.12 (Wed, 07 Jun 2000 09:48:14 EST)
Organization: Ixora Pty Ltd
NNTP-Posting-Date: Wed, 07 Jun 2000 09:48:14 EST
Newsgroups: comp.databases.oracle.server


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@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.