Find accessed partitions
From: amonte <ax.mount_at_gmail.com>
Date: Tue, 14 Sep 2010 19:35:20 +0200
Message-ID: <AANLkTinzPwtrG19MvQBOcu12rsFoO_05a9zMwa9pGwUs_at_mail.gmail.com>
Hi
Date: Tue, 14 Sep 2010 19:35:20 +0200
Message-ID: <AANLkTinzPwtrG19MvQBOcu12rsFoO_05a9zMwa9pGwUs_at_mail.gmail.com>
Hi
I have a query which joins a partition table with some dimensions, when I look the execution plan I can see pstart and pstop shows KEY KEY so pruning is occuring.
Is there a way to find out exactly what partitions are accessed?
I tried using V$SQL_PLAN_STATISTICS_ALL but it shows KEY KEY as well
Alex
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 14 2010 - 12:35:20 CDT