Regarding Data file size [message #208615] |
Mon, 11 December 2006 09:30 |
rahul.priyadarshy
Messages: 28 Registered: December 2005
|
Junior Member |
|
|
Hi,
I need a suggestion from oracle masters.
we have oracle 10G. We have got 600 gb of space.
what should be the optimum size of datafile of the database.any advised value. we have very high transaction rate 600 transaction/minute minimum.
any advice.
Regards
Rahul Priyadarshy
|
|
|
|
|
|
Re: Regarding Data file size [message #208927 is a reply to message #208627] |
Tue, 12 December 2006 11:06 |
dba_blr
Messages: 43 Registered: December 2006
|
Member |
|
|
In an LMT if you have big objects then multiple files (under different mount points) per tablespace may help as Oracle picks extents from all the files in the tablespace in a round robin manner, which enables us to spread I/O in case of FTS.
|
|
|