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: Online creation/extension of Tablespaces possible??

Re: Online creation/extension of Tablespaces possible??

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Sat, 11 Sep 2004 23:00:27 +0200
Message-ID: <lpp6k0p0khacimtllnkrnmphed417ma3ln@4ax.com> 





On Sun, 12 Sep 2004 06:44:47 +1000, "Howard J. Rogers"
<hjr_at_dizwell.com> wrote:



>Too many data files in a database are themselves not a terribly good idea

>for efficient checkpoints etc, so I wouldn't want to see 2000 files of 10MB

>each to make a 20GB database, either. 




Which was exactly the context I was implicitly referring to.
I don't think there is much disagreement between us, if I can, I would
limit my datafiles to 2G



--
Sybrand Bakker, Senior Oracle DBA


Received on Sat Sep 11 2004 - 16:00:27 CDT












Original text of this message













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