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: What space of a Oracle block is being used?

Re: What space of a Oracle block is being used?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 13 Aug 2002 10:04:56 +0100
Message-ID: <3d58cbb9$0$232$ed9e5944@reading.news.pipex.net>


"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:3d58c34d_at_dnews.tpgi.com.au...
> It's either the nasal hairs growing in my nostrils, or I can smell a new
> Oracle myth in the making: "Use ASSM! All the time! It's brilliant!".
>
> It's not. It's bloody awful for full table scans unless you have freelist
> contention growing as prolifically as my nasal hairs. So there!
>
> Regards
> HJR
Do you have tests (or a pointer to someone elses work) for this statement?

--
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 Tue Aug 13 2002 - 04:04:56 CDT

Original text of this message

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