| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: Separate Indexes and Data
But those holes of exactly the right size for new objects to fit into.
Since you'll presumably move it once it gets about 1,000 extents or so that
isn't a huge amount of space that's being wasted.
Jay Miller
Sr. Oracle DBA
-----Original Message-----
Sent: Tuesday, September 30, 2003 4:45 PM
To: Multiple recipients of list ORACLE-L
My criticism of the defrag paper was that it did not address what to do when
a segment grew large enough to belong in a tablespace with a larger uniform
extent size. Moving the segment creates holes in its original tablespace
which may close only in the fullness of time. Physical backups of the files
comprising the original tablespace include this wasted space, this is
compounded by how many days backup you keep available, and the number of
copies of backups.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: JayMiller_at_tdwaterhouse.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 Tue Sep 30 2003 - 18:24:41 CDT
 |
 |