| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Unevent usage of datafiles within on tablespace
Richard Foote <richard.foote_at_bigpond.com> wrote:
I go thru DbArtisan on all the tables of that tablespace but can't see any extent defined to use a particular datafiles.
Also the datafile which got fill up is not the first one the tablespace.
Can you tell me how can i find out more on that?
Moreover, does a record in a table can't store accross datafile within same tablespace?
Thx
cupnoodle (beef)
> 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
>> 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*
>> 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 >> > > > >> > > > >> > > >> > > >> > >> > >> >>
-- I'm a cup of noodle ---- Work like you don't need the money Love as though you have never been hurt Dance as though no one is watching you Sing as though no one can hear you ----Received on Mon Dec 16 2002 - 19:58:01 CST
 |
 |