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 -> Autoextend switch

Autoextend switch

From: Gary <rooty_hill2002_at_yahoo.com.au>
Date: 12 Jun 2003 23:11:02 -0700
Message-ID: <171bd226.0306122211.50ec871@posting.google.com> 





Hi! 



I was told technically it is not a good idea to switch on AUTOEXTEND
for all tablespaces except for SYSTEM. Practically as a junior Oracle
DBA I am really allured to switch it on for all tablespaces.



Could anybody explain to me why AUTOEXTEND will cause fragmentation or
I/O contention?



Thanks in advance.
Received on Fri Jun 13 2003 - 01:11:02 CDT












Original text of this message













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