Re: Linux+Oracle performance problem!

From: Mark Clark <nospam_at_thankyou.com>
Date: Fri, 08 Oct 2004 08:40:18 +0100
Message-ID: <hvgcm0pll0r8dsg9e641as7a47l8408e91@4ax.com>

On Fri, 8 Oct 2004 09:03:27 +0200, "Marek" <kasikm_no_spam_at_buziaczek.pl> wrote:

>Hello!
>I've just installed Oracle 9.2 from Linux(64Bit) on Mandrake 10 (2xAMD64 +
>2GB RAM) with kernel 2.6.8.1 appropriate compiled.
>Linux goes good, but Oracle has proble with performance - its newer can go
>more then 15% of processors usage.
>If one user run heavy SQL query - server occupy 15%, if two users - obout 7
>% per query, and so on ....
>What ans where should I configure do to run Oracle on 100% processor usage
>???
>
>Best regards
>Marek.
>

Marek

I suspect this is because Oracle is waiting on other resources. If you want a workload to thrash CPU w/Oracle then try orabm its free...

http://www.linxcel.co.uk/orabm

Mark
http://www.linxcel.co.uk Received on Fri Oct 08 2004 - 02:40:18 CDT