The Oracle (tm) Users' Co-Operative FAQ

I have taken over an existing tablespace and need some ideas for setting extent sizes when re-organizing it ?

Author's name: Jonathan Lewis

Author's Email:

Date written: 10th Jan 2002

Oracle version(s): n/a

What should you consider when you have the option for re-organizing a tablespace ?.

Back to index of questions

This question is addressed by the following documents:



Suggested by

Referee's comments

Howard Rogers

Should all extent sizes be the same?

Jonathan Lewis

A short pdf file with an intelligent discussion of the issues. You will need Adobe Acrobat to read this document.

NOTE - The referenced site was closed down by Oracle Australia. in May 2002. This link has been maintained in case Howards gets permission to re-open the site.

Howard Rogers

What is the cause and fix for tablespace fragmentation ?

Jonathan Lewis

One of several “discussion documents” on the Dizwell website that take the time and space to examine Oracle features properly.


Further reading:

Back to top

Back to index of questions