Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Segment Space Management Manual

626932Jun 25 2009 — edited Jun 25 2009

Hi,

For one of our production database we are using the option MANUAL for the Segment space management. the extent allocation is set to uniform and the tablespace is LMT with autoextend on. Could anyone please advice the advatnages if the segment space management is set to auto. Also this tablespace doesnt contains any LOB's.

CREATE TABLESPACE "********" DATAFILE
'****************************************' SIZE 209715200 REUSE
AUTOEXTEND ON NEXT 20971520 MAXSIZE 2097152000
LOGGING ONLINE PERMANENT BLOCKSIZE 16384
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 163840 SEGMENT SPACE MANAGEMENT MANUAL

Thanks in advance.

Regards,
Anand

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 23 2009

Added on Jun 25 2009

#general-database-discussions

3 comments

1,979 views