|
[oracle-l]
||
[Date Prev]
[07-2006 Date Index]
[Date Next]
||
[Thread Prev]
[07-2006 Thread Index]
[Thread Next]
Re: Managing CPU_COUNT for micro-partitioning on AIX
- From: "Connor McDonald" <mcdonald.connor@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 3 Jul 2006 11:15:07 +0800
On 7/3/06, Mark Brinsmead <pythianbrinsmead@xxxxxxxxx> wrote:
"First off, correct me if I'm wrong (I probably am, and I'm sure somebody here
likely
will), but isn't CPU_COUNT mainly used by the database to decide the degree of
parallelism that can/should be used?"
The other thing that is (perhaps) more significant (in systems where
latch contention is an issue), is that with a single CPU box, it makes
no sense to spin for a latch (after all, on a one CPU system, if
someone else has a latch, the only way they'll release it is it I get
off the CPU and give them a chance to get some CPU time)....
--
Connor McDonald
===========================
email: connor_mcdonald@xxxxxxxxx
web: http://www.oracledba.co.uk
"Semper in excremento, sole profundum qui variat"
--
http://www.freelists.org/webpage/oracle-l
|
