Re: RE: Little competition

Content-Type: text/plain
Content-Transfer-Encoding: 7bit

> PCTFREE and PCTUSED are not part of the storage
> clause.
>
> SQL> create table t1 (c1 number)
> tablespace lmt1 pctfree 20 pctused 30;
>
> Table created.
>
> Lot's
> of potential to go down the wrong path on this one.
> Assumptions!

Maybe it has been already mentioned here, but with ASSM, pctused value is ignored. A "full" block becomes free again when its usage drops below next freeness status. There are 4 freeness statuses for an ASSM table block, representing in 25% increments how full a block (plus two additional statuses for unformatted and logically full blocks).

Tanel.

--=_d8a0420229c6bd96289a528e9ea71e26--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).