Home » RDBMS Server » Server Administration » Regarding Data file size
Regarding Data file size [message #208615] Mon, 11 December 2006 09:30 Go to next message
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 #208620 is a reply to message #208615] Mon, 11 December 2006 09:37 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
size of datafile primary depends on your backup/recovery strategies.
>> very high transaction rate
What would the the estimated growth?
Start something moderate. spread across different disks.
Re: Regarding Data file size [message #208621 is a reply to message #208620] Mon, 11 December 2006 09:45 Go to previous messageGo to next message
rahul.priyadarshy
Messages: 28
Registered: December 2005
Junior Member
Hi,

Thanks for the reply.
everyday database size will increase by 80 GB.May be this will help you out.
Re: Regarding Data file size [message #208627 is a reply to message #208621] Mon, 11 December 2006 10:02 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>everyday database size will increase by 80 GB.
>>We have got 600 gb of space.
Then you will be maxing out in about 2 weeks?

[Updated on: Mon, 11 December 2006 10:03]

Report message to a moderator

Re: Regarding Data file size [message #208927 is a reply to message #208627] Tue, 12 December 2006 11:06 Go to previous message
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.
Previous Topic: ORA-01555: snapshot too old
Next Topic: System Table DUAL
Goto Forum:
  


Current Time: Tue Dec 06 10:32:57 CST 2016

Total time taken to generate the page: 0.08110 seconds