Re: db file sequential read - again
- From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
- To: Mark.Bobak@xxxxxxxxxxxxxxx
- Date: Wed, 14 Mar 2007 13:48:39 +1000
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
