Cost-Based Optimizer and AIX Virtual Processors
From: David Barbour <david.barbour1_at_gmail.com>
Date: Wed, 29 Apr 2009 16:12:19 -0400
Message-ID: <69eafc3f0904291312m72359582jd03b57541b995ea9_at_mail.gmail.com>
Has anyone seen execution plans change using virtual processors on AIX? How about VM/Linux or VM/Windows? For the purposes of the optimizer, I'd think they'd all react in a similar manner.
Date: Wed, 29 Apr 2009 16:12:19 -0400
Message-ID: <69eafc3f0904291312m72359582jd03b57541b995ea9_at_mail.gmail.com>
Has anyone seen execution plans change using virtual processors on AIX? How about VM/Linux or VM/Windows? For the purposes of the optimizer, I'd think they'd all react in a similar manner.
We've got several partitions on an AIX system. If a specific instance has a certain allotment of processors (generally >=2) when a query kicks off, it runs differently than when the instance is basically idle (<= 1 processor allocated) and the query starts.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 29 2009 - 15:12:19 CDT