Find accessed partitions

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: