On 2004-10-08, Howard J. Rogers <hjr_at_dizwell.com> wrote:
> Marek 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.
>
> This sounds suspiciously like a production environment... and I find it
> difficult to believe that anyone would have actually installed Oracle on
> Mandrake in a production environment.
>
> It's a totally non-certified, unsupported platform, and you are very much on
> your own.
>
> So if you discover that Oracle is somehow artificially restricted in the
> amount of CPU it can consume, it's not really to be wondered at. On the
> other hand, "never" going beyond 15% is a big claim to make... some details
> of how much testing you've done to back that claim up would be needed
> before it is entirely credible. What sort of workload are your sessions
> throwing at the database? How do you know that your sessions don't actually
> need more than 15% of the CPU?
>
> Usual performance tuning rules apply: statspack, oraperf, wait states.
>
> And get a certified combination of O/S and Oracle version.
>
> Regards
> HJR
>
>
--
Negligence will never equal intent, no matter how you
attempt to distort reality to do so. This is what separates |||
the real butchers from average Joes (or Fritzes) caught up in / | \
events not in their control.
Received on Thu Oct 21 2004 - 12:34:32 CDT
