Sorry, the additional join condition should be nvl(partition_name, segment_name)=nvl(subobject_name, object_name) (or something like that - accounting for non-composite objects) or else we end up having only partitioned objects. again, sorry for the inconvenience. On 3/14/07, Alexander Fatkulin <afatkulin@xxxxxxxxx> wrote:
Mark, you forgot to include v$segment_statistics.subobject_name = dba_segments.partition_name in join conditions.
-- Alexander Fatkulin -- http://www.freelists.org/webpage/oracle-l