Find accessed partitions

  • From: amonte <ax.mount@xxxxxxxxx>
  • To: Oracle-L Group <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 14 Sep 2010 19:35:20 +0200

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

Other related posts: