Re: Performance Problems Oracle 8.0.6 on NT 4.0 / Compac-Server

From: Christian Greven <greven.christian_at_baufeldt.de>
Date: Fri, 24 Nov 2000 11:24:56 +0100
Message-ID: <8vlfo9$hkl$03$1@news.t-online.com>

Ulrik Hoffmann <ulrik.peer_at_hoffmann-kiel.de> schrieb in im Newsbeitrag: 8vituu$4oqjr$1_at_ID-13717.news.dfncis.de...
> is the initORCL.ora the same on both systems?
 

> Try select sum(value)/1024/1024 from v$sga
>
> on both systems.
>
> What are the parameters for
> shared_pool_size
> db_block_buffers
> db_block_size
> sort_area_size

On both systems the same:

SUM(VALUE)

---

27.8348846
1 Zeile ausgewählt.
SQLWKS>
SQLWKS> select * from v$sga;

NAME                 VALUE
-------------------- ----------
Fixed Size                52144
Variable Size          22409216
Database Buffers        6553600
Redo Buffers             172032

shared_pool_size = 20000000
db_block_buffers = 800
db_block_size = 8192
sort_area_size = 65536

Bye,
Christian. Received on Fri Nov 24 2000 - 04:24:56 CST