I beg to differ with this persons assessment.
Number of datafiles hardly effect performance in any noticable manor. This
can be noted during checkpoint where high count of data files check point
with similar efficiency of low number.
Granted, having 1000 128k data files wouldn't be efficient. Reasonability
on creating datafiles has never posed performance problems I have noticed.
But in short, yes of course there will be some increased time at checkpoint
with more datafiles, it is only common sense, but the time it takes to
update the SCN in the header is so small in comparison of the time it takes
to write out the dirty blocks.
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-----Original Message-----
Sent: Monday, June 11, 2001 2:16 PM
To: Multiple recipients of list ORACLE-L
All,
Awhile back, on the "other" list, there was a discussion regarding the
number of data files that an Oracle database might contain.
Someone posted a warning that too many data files might actually hurt
performance in that it might inflate the amount of work to be done at SCN
update time.
How would I test this? What "wait value" might be too high to indicate that
this is taking too long?
I am not having an immediate problem, but know of a group that might be.
thanks for any help
Tom Mercadante
Oracle Certified Professional
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christopher Spence
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
