Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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).Received on Fri Nov 07 2003 - 14:04:31 CST
![]() |
![]() |