Re: Bitmap index partitions and recursive calls

"Pratap" <pratap.deshmukh_at_gmail.com> wrote in message news:1d9841d6-9a79-4b0f-b49e-cf2e83e02ade_at_c22g2000vbb.googlegroups.com...
> Hi,
>
> Oracle 10.2.0.4
>
> What is the relation between partitioned bitmap indexes and number of
> recursive calls shown by Autotrace? I have seen that as the number of
> partitions on a table increase, for a query using bitmap indexes, the
> number of recursive calls also increase. When the number of partitions
> on the table are reduced, the same query shows lower recursive calls.
>
> I have discounted query parsing by running the queries 3 times before
> observing the recursive calls.
>

Have you tried enabling SQL trace and seeing if those recursive calls appear as SQL in the trace file ?

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com