Re: Find accessed partitions

By the way anyone used event 10128?



2010/9/14 amonte <ax.mount@xxxxxxxxx>

> 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: