Re: wierd performance problem
From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Thu, 10 Jul 2008 13:32:51 -0500
Message-ID: <de807caa0807101132v2c23d40eo849dfa44ca68982a@mail.gmail.com>
Date: Thu, 10 Jul 2008 13:32:51 -0500
Message-ID: <de807caa0807101132v2c23d40eo849dfa44ca68982a@mail.gmail.com>
Dear DBA,
Perhaps the key is that your table is partitioned, but you haven't given Oracle to perform partition pruning. Is it trying to retrieve rows from each partition, then assemble the result? Maybe you could post the explain plan output?
Dennis Williams
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 10 2008 - 13:32:51 CDT