Re: PCTFREE and PCTUSED

>CREATE TABLESPACE DATA01
>DATAFILE '\data01.dbf' size 8M reuse
>AUTOEXTEND ON NEXT 4096M MAXSIZE 32M
>EXTENT MANAGEMENT LOCAL AUTOALLOCATE
>SEGMENT SPACE MANAGEMENT AUTO
Our prod sys is using 8i on solaris, but I quickly tried that on 9i on my own pc running on XP, before I go try it anywhere else, and it worked.

thx
maa

At 01:59 PM 11/7/2003, you wrote:
>On the other hand, you might have overallocated the space, which would
>leave plenty of blocks on the free list, thus minimizing the impact.
>These things are best seen on "almost full" tables with things like
>row chaining, row migration, waits on ITL entries and other lovely
>things. Looks like you've benn lucky so far. As I've told you before,
>having tablespaces created with "SEGMENT SPACE MANAGEMENT AUTO" option
>takes care of that.
>if your tablespace is created with a command like
>
>"CREATE TABLESPACE DATA01
> DATAFILE '/data01/SID1/data01.dbf' size 8192M reuse
> AUTOEXTEND ON NEXT 4096M MAXSIZE 32769M
> EXTENT MANAGEMENT LOCAL AUTOALLOCATE
> SEGMENT SPACE MANAGEMENT AUTO"
>
>then you can create tables without any additional parameters and
>everything will be kosher.
>The tablespace above requires something called "large files support" from
>the file system
>and cannot be used on FAT file systems or ISO9660-RR/Joliet file system.
>Practically anyhing
>else (UFS,VxFS,ReiserFS,Ext(2|3),XFS,JFS,OCFS,NTFS (scheduled to go away
>when the new virus
>propagataion engine enters production)).
>BTW, what OS and database version do you use?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Maryann Atkinson
  INET: maryann_30_at_yahoo.com

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