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

From: Ulrik Hoffmann <ulrik.peer_at_hoffmann-kiel.de>
Date: Fri, 24 Nov 2000 16:27:27 +0100
Message-ID: <8vm1ca$53cum$1@ID-13717.news.dfncis.de>

"Christian Greven" <greven.christian_at_baufeldt.de> schrieb im Newsbeitrag news:8vlfo9$hkl$03$1_at_news.t-online.com...
>
> 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
>

Hi,

if your query runs as long as you said, it seems you have lots of data and then inreasing the db_block_buffers( to 2000) can help a bit. You only use 27MB of total RAM, for a production-system, this is not much. How many rows do the tables have? How does the query look like? Does it perform a sort? How many rows are expected to return?

Bye
Uli Received on Fri Nov 24 2000 - 09:27:27 CST