Re: Extremly slow performance with Oracle and Linux

Can you set autotrace on in sqlplus and see what Oracle is doing? Is the table analyzed? I run 8.0.5 on a old Dell Pentium 90 with 48 MB of RAM and RH 5.2. I just use the demo ORCL database with the small SGA, but I never notice any bottlenecks, except with log buffers.

When I run queries using autotrace, I do notice caching is taking place on subsequent executions of the same query.

Roger wrote in message <7qc2lh$rif$1_at_opal.hamburg.cityline.net>...
>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 - 19:16:10 CDT