Re: CPU not used when multi-threaded
- From: Christo Kutrovsky <kutrovsky.oracle@xxxxxxxxx>
- To: sjaffarhussain@xxxxxxxxx
- Date: Thu, 19 Jan 2006 11:34:02 -0500
What exactly in the SAR reports that points you to the fact that the
CPU is not used?
Why do you expect it to be used ? Do you have 24 parallel sessions doing work?
Could it be that your DISK is too busy, thus CPU stays idle ?
--
Christo Kutrovsky
Senior Database/System Administrator
The Pythian Group
On 1/18/06, The Human Fly <sjaffarhussain@xxxxxxxxx> wrote:
> List,
>
> For one of our business critical database, we have assigned 12 cpus
> with multi-thread(logical) of 24 cpus. What we have noticed that
> oracle is not using all the CPU avaibale, at least 4 (8 logical) cpus
> are not being utilized. We have checked from OS level using sar report
> to confirm the sam during business peak hours.
> Is there any limitation with oracle not to use many logical CPUs?
>
> Your time and advice is highly appreciated.
>
> --
> Best Regards,
> Syed Jaffar Hussain
> OCP 8i & 9i DBA,
> Banque Saudi Fransi,
> Saudi Arabia
> http://jaffardba.blogspot.com/
> ----------------------------------------------------------------------------------
> "Winners don't do different things. They do things differently."
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Christo Kutrovsky
Senior Database/System Administrator
The Pythian Group
--
//www.freelists.org/webpage/oracle-l
Other related posts:
