| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Question about many Oracle Data Files
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: NDATFM_at_labor.state.ny.us
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: ListGuru_at_fatcity.com (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).
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: ListGuru_at_fatcity.com (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). Received on Tue Jun 12 2001 - 17:42:34 CDT
 |
 |