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: Extremly slow performance with Oracle and Linux

Re: Extremly slow performance with Oracle and Linux

From: Gene Hubert <ghubert_at_netpath.net>
Date: Sun, 29 Aug 1999 18:50:17 GMT
Message-ID: <F21CA5E990D45E4E.FCC5180BEE9EECB1.5726943077383D3F@lp.airnews.net>


Just a guess from very limited info:

You may be telling Oracle to use more memory that is physically available and Oracle's several buffers are being swapped by the OS. You can connect via svrmgr30 and type "show sga" to get a picture of Oracle's total memory usage.

Gene Hubert
SkillsPoint.com
Morrisville, NC

On Sun, 29 Aug 1999 14:10:59 +0200, "Roger" <NOrgSPAM_at_mcs-hh.de> wrote:

>I just installed an Oracle 8.0.5 Server on my Linux Redhat 5.1 computer. It
>works but extremly slow. For example a simple benchmark that takes
>SQL-Server about 6 seconds takes the Oracle server almost 3 MINUTES to
>finish. Besides that I'm doing some data import right now. The Oracle server
>is now running for about 15 minutes and hasn't finished yet. SQL-Server
>needet about 1 minute. What could be the cause of this performance problem ?
>
>Regards
> Roger
>
>
>BTW: The configuration is:
>
>The Linux box is a Compaq Notebook, with 96 MB Ram and a Pentium 233 MHZ
>The SQL-Server runs on a Windows 2000 Beta 3 computer with a Celeron II 300
>MHZ and 64 MB Ram.
>
>
Received on Sun Aug 29 1999 - 13:50:17 CDT

Original text of this message

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