Re: Cost-Based Optimizer and AIX Virtual Processors

From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Thu, 30 Apr 2009 07:43:12 +0200
Message-ID: <cd8f74560904292243p10e04344vcf858a6c4d24acb3_at_mail.gmail.com>



David,
I'm not familiar with the way AIX handles its Partitions: Does it _show_ the same count of processors to the instance (at startup-time) all the time or does this change? There are a lot of memory parameters derived from cpu_count. Some of them affect the optimizer, too. Can you provide a sample-sql and the execution plans? (maybe even a event 10053 trace of them) - so it might be easier to investigate your particular issue.

best regards,
 Martin

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 30 2009 - 00:43:12 CDT

Original text of this message