!! Please do not post Off Topic to this List !!
Having too many datafiles is not good for performance,
updating datafile headers during checkpointing.
I disagree, unless you have an unreasonable amount, there is minor almost
not noticeable difference.
Tests have been done on many databases
!! Please do not post Off Topic to this List !!
Generally more smaller data files is better than fewer larger ones.
There is no performance problem with having 10 200Mb data files rather than
1 2gb data file. In fact, using 10 200mb data files will help a little when
it comes to file locking.
recipients of list ORACLE-L
Subject: RE: Tablespace (datafile reducing)
!! Please do not post Off Topic to this List !!
Having too many datafiles is not good for performance,
updating datafile headers during checkpointing.
I disagree, unless you have an unreasonable amount
!! Please do not post Off Topic to this List !!
Chris,
Are these tests results published someplace?
Tests have been done on many databases with 3500+ data files and shown the
difference to be insignificant.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent:
!! Please do not post Off Topic to this List !!
There is no performance problem with having 10 200Mb data files rather than
1 2gb data file. In fact, using 10 200mb data files will help a little when
it comes to file locking.
and recovery..
-Original Message-
Spence
Sent: Friday,
PROTECTED]]
Sent: Friday, September 14, 2001 8:50 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Tablespace (datafile reducing)
!! Please do not post Off Topic to this List !!
Having too many datafiles is not good for performance,
updating datafile headers during
!! Please do not post Off Topic to this List !!
Datafile sizing is also dependent on the size of your db. I use 10gb datafile size's
for a 1tb database.
[EMAIL PROTECTED] 09/14/01 09:50AM
!! Please do not post Off Topic to this List !!
Generally more smaller data files is better than fewer
!! Please do not post Off Topic to this List !!
I know a few people (actually on the LazyDBA list) have done tests and each
time they have said the checkpoint time has been insignificantly altered.
I cannot say I have done these tests, and go by the theory of using smaller
data files rather
Chris,
"Generally more smaller data files is better
than fewer larger ones." Can
you pl let me know if there is any paper or something throwing light on
this.
Thanks
Anjan
Gene Sais wrote:
!! Please do not post Off Topic to this List !!
Datafile sizing is also dependent on the size of your db. I
!! Please do not post Off Topic to this List !!
And I have built TB+ sized databases using no datafiles larger than 2 GB. At
this level, larger files are worthy of consideration, but they are certainly not
required - or even critical. It depends...
-Don Granaman
[OraSaurus - Honk if you
!! Please do not post Off Topic to this List !!
Create a new tablespace and move the objects to it using alter table move or
imp/exp. If you need to use the same tablespace then you need to export,
drop tablespace, recreate with one datafile, import. - E
-Original Message-
From:
!! Please do not post Off Topic to this List !!
Kishore,
Having too many datafiles is not good for performance,
updating datafile headers during checkpointing.
If you are on 8i you can create a 2GB tablespace, and use
the alter table move command to move all the tables in that tablespace
to
12 matches
Mail list logo