Re: Oracle 8i 8.1.5.0.0 server size in RAM

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Tue, 20 Apr 1999 17:00:06 +0200
Message-ID: <371C9676.803F7C21@vnl.nl>

Don't kwow where these came from, but

> db_block_buffers=8192

on a (default) block_size of 2k, that would make 16M buffers - still quite a lot. Consider 2MB (1000 for 2k blocks)

> shared_pool_size=52428800

52MB shared pool? What are you running, Oracle apps? How's a (805 large) of 9MB, or a single user Designer size of 18MB

> large_pool_size=70778880

New in 8.1.5? 70MB still seems quite large even for a limit

> java_pool_size=20971520

Heard about that one - seems to be needed for the JVM... Have no idea whether it could be made smaller. You could tru it, tho - do you use the jvm?

> How do I make the size in RAM smaller? (The size of the server processes for 8.0.5 were
> around 21MB - which is far more reasonable considering that I have somewhat limited
> resources).
>
> Thanks in advance for any assistance...
>
> --
> Dave Thompson
> Systems Programmer
> thompd_at_guppi.org

--
Met vriendelijke groet,
kind regards,

Frank van Bortel
Technical consultant Oracle
V&L Informatica BV

Work                           Home
Postbus 545                    Hunzestraat 4
7500 AM Enschede               7555 WB Hengelo
(31)53.434.1500                (31)74.242.5046

Received on Tue Apr 20 1999 - 10:00:06 CDT