Re: Oracle 8.1.5 Memory Usage

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Thu, 18 Nov 1999 20:46:50 GMT
Message-ID: <383464f8.1296585@news.earthlink.net>

Try SHOW SGA in svrmgrl tool

[WHSE_at_sydney oracle]$svrmgrl

Oracle Server Manager Release 3.1.5.0.0 - Production

Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production

SVRMGR> connect internal
Connected.
SVRMGR> show sga

Total System Global Area                        845454736 bytes
Fixed Size                                          64912 bytes
Variable Size                                    15687680 bytes
Database Buffers                                819200000 bytes
Redo Buffers                                     10502144 bytes
SVRMGR> show parameter java
NAME                                TYPE    VALUE
----------------------------------- -------
------------------------------
java_max_sessionspace_size          integer 0
java_pool_size                      string  20000K
java_soft_sessionspace_limit        integer 0

SVRMGR> Also, Java is eating out some of the memory by default 20M

Also, RTFM!

On Wed, 17 Nov 1999 20:05:36 -0500, "Eric Raskin" <eraskin_at_paslists.com> wrote:

>Ulrik:
>
>Thanks for the answer. I originally had db_block_buffers = 8192. That made
>for a larger SGA in each database and made the memory allocation problem
>worse. But, you're absolutely right. I have to put that back and find a
>different solution.
>
>If my SGA only has 1MB to hold data, why are process sizes approx 60MB
>(55MB - 66MB)?
>
>Any other ideas?
>
> Eric
>
>Ulrik Hoffmann <ulrik_at_hoffmann-kiel.de> wrote in message
>news:80va68$1abc5$1_at_fu-berlin.de...
>> Hi,
>>
>> if the values for the db_block_buffers are true, I would increase
>> them to 10000 !!!!!!!
>>
>> Your database cannot hold any data in memory (just 1 MB
>> (db_block_buffers * db_block_size).
>>
>> Maybe it's the reason for the swapping!
>>
>> Hope it helps,
>>
>> bye
>> Uli
>>
>
>
>

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email

Received on Thu Nov 18 1999 - 14:46:50 CST