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

Home -> Community -> Usenet -> c.d.o.tools -> Magic number ( 5 * DB_BLOCK_SIZE )

Magic number ( 5 * DB_BLOCK_SIZE )

From: Jonas M <joao_tomas_at_hotmail.com>
Date: Tue, 5 Jun 2001 12:22:20 +0100
Message-ID: <9fifqa$oct$1@venus.telepac.pt> 






Hi



While studying by Oracle Books , I've come accross this tip several times:



you should use uniform extent sizes : multiples of 5 * DB_BLOCK_SIZE



Why do they insist on this value ? I thought the ideal situation would be to
fit all my data ( from a regular table ) in just one extent...
isn't that so ? Is it better to have several extents , and get the data
spread among them ?




Thanx in advance
Received on Tue Jun 05 2001 - 06:22:20 CDT












Original text of this message













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