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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Slow 8.1.6 on win2000

RE: Slow 8.1.6 on win2000

From: Nguyen, Long <Long.Nguyen_at_its.csiro.au>
Date: Tue, 23 May 2000 13:28:46 +1000
Message-Id: <10505.106309@fatcity.com>


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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">

<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D230375502-23052000>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&nbsp;"select * from user_tables"&nbsp;under SYSTEM = against a=20
database:</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D230375502-23052000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D230375502-23052000>&nbsp;&nbsp;&nbsp;&nbsp;sqlplus on=20 Unix&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n= bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 tooks 4 seconds</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D230375502-23052000>&nbsp;&nbsp;&nbsp;&nbsp;sqlplus on=20 Win2000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp= ;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 tooks 1 minute 2</SPAN></FONT><FONT color=3D#0000ff face=3DArial = size=3D2><SPAN=20
class=3D230375502-23052000>0 seconds</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D230375502-23052000>&nbsp;&nbsp;&nbsp; sqlplus worksheet in=20 Win2000&nbsp;&nbsp;&nbsp;took&nbsp;10 minutes</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D230375502-23052000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D230375502-23052000>Oracle=20
has done a poor job here (java stuff!).</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D230375502-23052000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D230375502-23052000>With&nbsp;heading turned off ("set head = off") the=20
results as belows:</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D230375502-23052000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D230375502-23052000>&nbsp;&nbsp;&nbsp; sqlplus on=20 Unix&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n= bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 took less than 2 seconds</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D230375502-23052000>&nbsp;&nbsp;&nbsp; sqlplus on=20 Win2000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp= ;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 took 6 seconds</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D230375502-23052000>&nbsp;&nbsp;&nbsp; sqlplus worksheet in=20 Win2000&nbsp;&nbsp;&nbsp; took 50 seconds</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D230375502-23052000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D230375502-23052000>During=20
the sqlplus/sqlplus worksheet run on Win2000, CPU is used up as=20 well.</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D230375502-23052000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D230375502-23052000></SPAN></FONT><FONT color=3D#0000ff = face=3DArial=20
size=3D2><SPAN class=3D230375502-23052000>Long</SPAN></FONT></DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
  <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT = face=3DTahoma=20
  size=3D2>-----Original Message-----<BR><B>From:</B> Andrey Bronfin=20   [mailto:bronfin_at_VisualTop.com]<BR><B>Sent:</B> Tuesday, 23 May 2000 = 2:53=20
  AM<BR><B>To:</B> Multiple recipients of list = ORACLE-L<BR><B>Subject:</B> Slow=20
  8.1.6 on win2000<BR><BR></DIV></FONT>

  <DIV><FONT face=3DArial size=3D2>Dear DBAs !</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2>I've just installed 8.1.6 on win2000 =
and=20
  it&nbsp;runs VERY slow , eating up most of the CPU .</FONT></DIV>   <DIV><FONT face=3DArial size=3D2>Is this a known issue ? What should = i look at ?=20
  </FONT></DIV>
  <DIV><FONT face=3DArial size=3D2>TIA .</FONT></DIV> Received on Mon May 22 2000 - 22:28:46 CDT

Original text of this message

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