Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Performance Problems Oracle 8.0.6 on NT 4.0 / Compac-Server

Performance Problems Oracle 8.0.6 on NT 4.0 / Compac-Server

From: Christian Greven <greven.christian_at_baufeldt.de>
Date: Thu, 23 Nov 2000 12:08:03 +0100
Message-ID: <8vitp3$7hq$00$1@news.t-online.com> 






Hi,



any known problems with Oracle 8.0.6 on NT 4.0 / Compac-Server???




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???



Bye,


Christian.
Received on Thu Nov 23 2000 - 05:08:03 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US