Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Extents and Segment space management

Re: Extents and Segment space management

From: <sybrandb_at_yahoo.com>
Date: 31 Jan 2006 03:31:54 -0800
Message-ID: <1138707114.762826.57120@z14g2000cwz.googlegroups.com> 





That the number of extents affects performance is a MYTH. It has been
discussed extensively in this forum.


You won't gain anything by reducing the number of extents to 1. In a
LMT database the storage is ignored or trasnformed anyway.
In a DMT compress=Y results in fragmentation of the free space. Been
there, done that.


-- 
Sybrand Bakker
Senior Oracle DBA


Received on Tue Jan 31 2006 - 05:31:54 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US