Life would be worse w/o PCT_FREE.
create table
test_table
(c1 varchar2(1000))
pctfree 20
;
select pct_free from user_tables where table_name='TEST_TABLE'
PCT_FREE
----------
20
rw
> Little competition for you all :)
>
> It's a two part question:
> What's wrong with the following piece of expert analysis ?
> Which well know "Oracle Guru" published this (and continues to
> display it on his web-page) ?
>
>
> "Sadly, Oracle9i doesn't allow you to specify the value for PCTFREE
> if you're using automatic space management. This is a serious
> limitation because Oracle9i can't know in advance about the amount of
> VARCHAR expansion in a table row, leading to excessive row chaining
> and poor access performance."
>
>> create table
> 2 test_table
> 3 (c1 number)
> 4 tablespace
> 5 asm_test
> 6 storage
> 7 ( pctfree 20 pctused 30 )
> 8 ;
>
> ( pctfree 20 pctused 30 )
> *
> ERROR at line 7:
> ORA-02143: invalid STORAGE option
>
> However, here's an important point. While Oracle9i rejects the
> PCTFREE and PCTUSED parameters with locally managed tablespaces with
> automatic space management, it does allow you to enter invalid
> settings for NEXT and FREELISTS settings"
>
>
>
> You've gotta love it !!
>
> Sorry no clues ....
>
> Cheers ;)
>
> Richard
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wartiak Rastislav
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
