Its not immediately obvious to me, but I do have the same behaviour
exhibited here. Once in an index tablespace and one in a tablespace reserved
for LOBs. I must admit I thought that the datafile for a next extent was
chosen on a 'round robin' basis but it appears that this is not *always* the
case, at the moment I'd suspect that this behaviour is either linked to
particular segment types (noting that LOBs have associated indexes) or
perhaps to exp/imp. Unless anyone else already has the answer I think we'd
need to devise a test.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Cupnoodle" <klau_at_cowmama.com> wrote in message news:3dfd1d98_at_shknews01...
> All the tables in that tablespace has same extent sizes.
> Also same extent config on all datafiles.....
>
> any clue?
>
> "Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message
> news:3dfcfb85$0$225$cc9e4d1f_at_news.dial.pipex.com...
> > different extent sizes for the objects in the tablespace?
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > *****************************************
> > Please include version and platform
> > and SQL where applicable
> > It makes life easier and increases the
> > likelihood of a good answer
> > ******************************************
> > "Cupnoodle" <klau_at_cowmama.com> wrote in message
> news:3dfc2d41$1_at_shknews01...
> > > I have a 20G tablespace "striped" accross 15datafiles. But in DBA
> studio,
> > > one of the datafile filled up while others just 40% capacity
> > >
> > > how can that happen??
> > >
> > > Peter
> > >
> > >
> >
> >
>
>
Received on Mon Dec 16 2002 - 05:11:29 CST
