"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message
news:2687bb95.0402050659.483e8741_at_posting.google.com...
> "Richard Foote" <richard.foote_at_bigpond.com> wrote in message
news:<F9oUb.43144$Wa.33347_at_news-server.bigpond.net.au>...
> > "Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message
> > news:40215d51$0$42$cc9e4d1f_at_news.dial.pipex.com...
> > > "Richard Foote" <richard.foote_at_bigpond.com> wrote in message
> > > news:_U5Ub.42357$Wa.22097_at_news-server.bigpond.net.au...
> > > > "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in
> > message
> > <snip>
> > > > Hi Niall,
> > > >
> >
> > **** Interestingly, once we hit 120 1M extents, Oracle decides enough is
> > enough and it really wants to go back to 8M extents again. Even though
there
> > are a number of 1M chunks of storage still available ***
> >
> > Like I said, a little more digging is required (on my part anyways) !!
> >
> > Cheers
> >
> > Richard
>
> Excellent example, but what version of Oracle was this ran on?
>
> -- Mark D Powell --
reproduces for me on 9204 on windows.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Thu Feb 05 2004 - 10:20:49 CST
