Re: Cost-Based Optimizer and AIX Virtual Processors

From: Martin Berger <>
Date: Thu, 30 Apr 2009 07:43:12 +0200
Message-ID: <>

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,

Received on Thu Apr 30 2009 - 00:43:12 CDT

Original text of this message