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

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 7.2 on NT 4.0 SP3 Performance Problem

Re: Oracle 7.2 on NT 4.0 SP3 Performance Problem

From: Steven Teo <teobc_at_hpsgmx18.sgp.hp.com>
Date: Fri, 15 May 1998 20:58:47 +0800
Message-ID: <355C3C05.95AEB2E4@hpsgmx18.sgp.hp.com>


Not sure if you created any indexes?

Wen-tau Yih wrote:

> Hi all,
>
> I wonder any of you have the same experience.
>
> I recently installed Oracle 7.2 on NT 4.0 with SP3
> (AMD K6-200, 96Mega RAM). When I ran the following
> query, I found it cost me more than 1 minutes!
>
> SELECT COUNT(*)
> FROM BASIC B, DOOR D
> WHERE B.DOORNUM=D.DOORNUM;
>
> Both TABLE BASIC and TABLE DOOR have about 14,000
> rows. I've tried the same query in Access on my desktop
> (Pentium-200, 32 Mega RAM), it cost no more than ten seconds!
>
> I believe that Oracle should have better performance. Is
> there any parameter I forgot to tune?
>
> Thx.
>
> Scott Yih
Received on Fri May 15 1998 - 07:58:47 CDT

Original text of this message

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