Re: Unevent usage of datafiles within on tablespace

Hi Niall/Cupnoodle (chicken or beef ?)

I "think" you may find the reason for this is that the first extent of each segment is placed in the first data file. Therefore by definition the first datafile will fill up quickest and the degree by which it does so depends on how many objects have few extents. In an extreme example, if all your objects have just the one extent, then the first data file will have all the extents allocated to it while the rest have zip.

Cheers

Richard
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3dfdb4e1$0$239$ed9e5944_at_reading.news.pipex.net...
> 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 - 06:28:04 CST