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
--
http://www.freelists.org/webpage/oracle-l

References:

RE: db file sequential read - again
From: Herring Dave - dherri

RE: db file sequential read - again
From: Mark . Bobak

Re: db file sequential read - again
From: Alexander Fatkulin

Other related posts:

Browse oracle-l