Originally posted by srikrishna
query from plan table these columns that is
object_name,options,operations.Then it will give some what clear
pciture.Other wise put set autotrace on where you have plan_table
and execute that query then it gives you all statistics of resources
as well as joining tables.

bye,
srikrishna DBA 9iocp