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

From: Ulrik Hoffmann <ulrik.peer_at_hoffmann-kiel.de>
Date: Thu, 23 Nov 2000 12:10:40 +0100
Message-ID: <8vituu$4oqjr$1@ID-13717.news.dfncis.de>

"Christian Greven" <greven.christian_at_baufeldt.de> schrieb im Newsbeitrag news:8vitp3$7hq$00$1_at_news.t-online.com...
> System 1 with NoName-server: Pentium II 400, 265 ram. My function needs
> about 30 minutes
>
> System 2 with Compac-Server: Pentium III 700, 1000 ram. The same function
> runs since 4 days.
>
> The database on system 1 is an export from system 2.
>
> Analyze indexes and analyze table speeds up same subqueries. One subquery
> got now only 3 minutes, before it was more than 10 hours.
>
> Hase any one an idea???

Hi Christian,

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

Bye
Uli Received on Thu Nov 23 2000 - 05:10:40 CST