RE: Little competition

From: Wartiak Rastislav <RWartiak_at_cpoj.cz>
Date: Thu, 11 Dec 2003 04:24:35 -0800
Message-ID: <F001.005D98BE.20031211042435@fatcity.com>

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

> 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: RWartiak_at_cpoj.cz

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).

Received on Thu Dec 11 2003 - 06:24:35 CST