Re: Extremly slow performance with Oracle and Linux

Gene,

according to "show sga" Oracle needs about 35 MByte Ram. After Oracle has started about 40 MByte are still free. I think this should be enough.

For example: I tested the following query

select sum(vkpreise.preis) as s, count(*) as c from vkprlist, artikel, vkpreise where vkplname like 'B%' and vkprlist.vkplid = vkpreise.vkplid  and vkpreise.produktnr = artikel.produktnr group by artikel.produktnr

This takes Oracle about 3.5 seconds to finish, SQL-Server is below 1 second.

vkpreise has about 10000 records, vkprlist about 300 and artikel about 9000 records.

What is interessting is the fact, that the first time I query SQL-server the query takes about 3 seconds to finish. With Oracle it is always the same time reagrdless how often I repeat the query. It looks as if Oracle doesn't do any caching.

Regards

    Roger

Gene Hubert <ghubert_at_netpath.net> schrieb in im Newsbeitrag: F21CA5E990D45E4E.FCC5180BEE9EECB1.5726943077383D3F_at_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 - 14:49:46 CDT