Re: Unevent usage of datafiles within on tablespace

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 18 Dec 2002 23:00:57 +1000
Message-ID: <IcZL9.5762$jM5.16293@newsfeeds.bigpond.com>

Hi Niall,

Don't you just hate those "nasty feelings" :)

England finally winning a game of cricket must surely have put a smile on your face !!

Cheers

Richard
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3e0038ed$0$235$ed9e5944_at_reading.news.pipex.net...
> "Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message
> news:3dff878c$0$245$cc9e4d1f_at_news.dial.pipex.com...
> > I've got a nasty feeling that I've missed something bad here (Like file
25
> > actually being created far later than file 4 in the above eg I'll double
> > check later). anyway for what its worth my two theories were
> <SNIP TEST>
>
> Ah. file 4 created April 2002, file 25 created October 2002. So we have a
> much simpler scenario, Oracle allocates extents in a round robin fashion
as
> expected/documented. This process takes no notice of free space within
> datafiles, so later created datafiles will be emptier than earlier dated
> ones. Sorry if this has consumed too much bandwidth, (and I now have to
> track down why the addition of the datafile in October wasn't documented).
>
>
> --
> 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
>
> ******************************************
>
>
>
Received on Wed Dec 18 2002 - 07:00:57 CST