Re: Extrem slow on Solaris 8

From: rob <rob_at_dsdelft.nl>
Date: Fri, 9 Mar 2001 14:06:01 +0100
Message-ID: <98akjj$977$1@news.tudelft.nl>

> The data in both
> database ist the same (import/export) and the database is running with the
> default settings.

Why run a database on a 256MB 4CPU Sun file with a default init.ora? You are comparing two untuned systems so Oracle for Linux with default settings runs faster than Oracle for Sun Solaris with default settings. A default init.ora on my Solaris box uses only about 4MB for SGA.

Adjust your init.ora setttings so that the SGA uses about 50% of the Physical memory
For example :

shared_pool_size                = 41943040 (40MB)
db_block_size                    = 8192
db_block_buffers                = 10240 (block_size * db_lblock_buffers =

80MB)
db_writers = 4

Let us know what happens.

Etc.
Rob. Received on Fri Mar 09 2001 - 07:06:01 CST