Re: Oracle 8.1.5 Memory Usage

From: Eric Raskin <eraskin_at_paslists.com>
Date: Wed, 17 Nov 1999 20:05:36 -0500
Message-ID: <s36nq1iphsq33@corp.supernews.com>

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
>
Received on Wed Nov 17 1999 - 19:05:36 CST