Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: index rebuilding...

Re: index rebuilding...

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 4 Feb 2003 13:02:46 -0000
Message-ID: <3e3fb9f6$0$248$ed9e5944@reading.news.pipex.net>


"Noons" <nsouto_at_optusnet.com.au.nospam> wrote in message news:Xns9318EB0C520B9mineminemine_at_210.49.20.254...
> Pete Sharman <peter.sharman_at_oracle.com> wrote in
> news:b1m6e30258f_at_drn.newsguy.com and I quote:
> Has anyone here tried to dump the first extent off a LMT,
> table with just one block of data, 64K uniform alloc, 4096
> block size? Ie, 16 blocks/extent? Now, that was a surprise
> for me: Oracle takes an apparently weird choice as to which
> block gets data first! Weird, I tell you. :)

Take a look at http://www.oaktable.net/fullArticle.jsp?id=4 which I think deals with what you are on about about halfway down.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Tue Feb 04 2003 - 07:02:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US