Message-Id: <10505.106309@fatcity.com> From: "Nguyen, Long" Date: Tue, 23 May 2000 13:28:46 +1000 Subject: RE: Slow 8.1.6 on win2000 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFC467.01101510 Content-Type: text/plain; charset="iso-8859-1" I have not tried the database but in 816 on win200 sqlplus worksheet accessing a db on Unix is very slow. My PC is a fairly powerful one (600 Mhz, 256 MB RAM). To compare I ran "select * from user_tables" under SYSTEM against a database: sqlplus on Unix tooks 4 seconds sqlplus on Win2000 tooks 1 minute 20 seconds sqlplus worksheet in Win2000 took 10 minutes Oracle has done a poor job here (java stuff!). With heading turned off ("set head off") the results as belows: sqlplus on Unix took less than 2 seconds sqlplus on Win2000 took 6 seconds sqlplus worksheet in Win2000 took 50 seconds During the sqlplus/sqlplus worksheet run on Win2000, CPU is used up as well. Long -----Original Message----- From: Andrey Bronfin [mailto:bronfin@VisualTop.com] Sent: Tuesday, 23 May 2000 2:53 AM To: Multiple recipients of list ORACLE-L Subject: Slow 8.1.6 on win2000 Dear DBAs ! I've just installed 8.1.6 on win2000 and it runs VERY slow , eating up most of the CPU . Is this a known issue ? What should i look at ? TIA . ------_=_NextPart_001_01BFC467.01101510 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I have=20 not tried the database but in 816 on win200 sqlplus worksheet accessing = a db on=20 Unix is very slow. My PC is a fairly powerful one (600 Mhz, 256 MB = RAM). To=20 compare I ran "select * from user_tables" under SYSTEM = against a=20 database:
 
    sqlplus on=20 Unix           &n= bsp;           =20 tooks 4 seconds
    sqlplus on=20 Win2000           = ;      =20 tooks 1 minute 20 seconds
    sqlplus worksheet in=20 Win2000   took 10 minutes
 
Oracle=20 has done a poor job here (java stuff!).
 
With heading turned off ("set head = off") the=20 results as belows:
 
    sqlplus on=20 Unix           &n= bsp;          =20 took less than 2 seconds
    sqlplus on=20 Win2000           = ;      =20 took 6 seconds
    sqlplus worksheet in=20 Win2000    took 50 seconds
 
During=20 the sqlplus/sqlplus worksheet run on Win2000, CPU is used up as=20 well.
 
Long
-----Original Message-----
From: Andrey Bronfin=20 [mailto:bronfin@VisualTop.com]
Sent: Tuesday, 23 May 2000 = 2:53=20 AM
To: Multiple recipients of list = ORACLE-L
Subject: Slow=20 8.1.6 on win2000

Dear DBAs !
 
I've just installed 8.1.6 on win2000 = and=20 it runs VERY slow , eating up most of the CPU .
Is this a known issue ? What should = i look at ?=20
TIA .