Re: Find accessed partitions
From: amonte <ax.mount_at_gmail.com>
Date: Tue, 14 Sep 2010 19:39:43 +0200
Message-ID: <AANLkTi=rraBqCO2cT7Pb=7W5Rvi2AtKPqMa3z4UUsAVx_at_mail.gmail.com>
By the way anyone used event 10128?
Date: Tue, 14 Sep 2010 19:39:43 +0200
Message-ID: <AANLkTi=rraBqCO2cT7Pb=7W5Rvi2AtKPqMa3z4UUsAVx_at_mail.gmail.com>
By the way anyone used event 10128?
2010/9/14 amonte <ax.mount_at_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:39:43 CDT