Home » RDBMS Server » Server Administration » Datafile Size
Datafile Size [message #217802] Mon, 05 February 2007 11:04 Go to next message
oracle_scorpiongirl
Messages: 39
Registered: November 2005
Member


[Updated on: Mon, 05 February 2007 11:44]

Report message to a moderator

Re: Datafile Size [message #217805 is a reply to message #217802] Mon, 05 February 2007 11:40 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> On Solaris we have a 2G file size limit
This 2gb file limit is for all 32 bit OS.
You must be using 64 bit these days (most probably).
>>is it bad to have a 10G datafile?
Nope. Oracle bigtablespace will support even terabyte datafiles.
>> just curious to know if there are some best practices for the datafile size.
Depends on your environment and your backup architecture.
If you are using too small datafiles, just make sure you are not running out of limits set by MAXDATFILES and DB_FILES.

Re: Datafile Size [message #217808 is a reply to message #217805] Mon, 05 February 2007 11:57 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
WOW...Mahesh...I guess the OP had second thoughts ??
Re: Datafile Size [message #217813 is a reply to message #217808] Mon, 05 February 2007 12:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
LOL~ Brian.
>>I guess the OP had second thoughts ??
I did not quite understand your response first( when i read from from mail box )
Only after i manually looked up thread, i foun the OP has updated the post.
I guess, i did not scare anyone! Embarassed


Re: Datafile Size [message #217817 is a reply to message #217813] Mon, 05 February 2007 14:19 Go to previous messageGo to next message
oracle_scorpiongirl
Messages: 39
Registered: November 2005
Member
Oops.. my bad. I am not sure what I did. I saw an edit button, thought of adding few more comments. But it looks like it erased my original question. Sorry about that :->
You should see it now

Let me re-phrase my question then:
1. What are the pros-cons of having small datafiles vs one large datafile?
(Since I am using ASM, I/0 contention and locks will be handled by ASM. So I cannot say these as a reason to use smaller datafiles.)
2. Is there any specific "limit" for the datafile size when using EMC storage? (does it matter? or do we just have the limits imposed by OS and oracle for the datafile size)?

I understand. When we talk about big tablespace, then I can use a much bigger datafile.

Thanks Smile


Re: Datafile Size [message #217821 is a reply to message #217817] Mon, 05 February 2007 14:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>When we talk about big tablespace, then I can use a much bigger datafi
By saying Bigtablespace what i actually meant is Oracle feature called Bigfile tablespace, which
designed to have several terabytes.

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/tspaces.htm#sthref1165
http://www.oracle-base.com/articles/10g/ImprovedVLDBSupport10g.php

Bigfile feature is quite useful with VLDB kind of usage.

>>What are the pros-cons of having small datafiles vs one large datafile?
As i said before, it depends on your environment.
One generic case is backup/recovery.
Having one big file to bakup, may be a problem and you ***may*** loose the file altogether and have
bigger downtime.
multiple small files are easy to backup and restore. But you do not want thousands of 1Gig files Smile
>>Is there any specific "limit" for the datafile size when using EMC storage
Nothing that i am aware of.
Size does not matter much (unless we are talking about many many small files or one Very big file).
Just make sure that you are spreading the files across the disks.

[Updated on: Mon, 05 February 2007 14:38]

Report message to a moderator

Re: Datafile Size [message #217831 is a reply to message #217821] Mon, 05 February 2007 15:35 Go to previous message
oracle_scorpiongirl
Messages: 39
Registered: November 2005
Member
Thanks Mahender.

I have actually read about bigfile TS (just one LARGE datafile). But never used it before. Thanks for the references. really helped.

Thanks again. Your point about backup made sense too.
Previous Topic: How to set up Oracle XA?
Next Topic: Rollback Segments
Goto Forum:
  


Current Time: Mon Dec 05 06:33:05 CST 2016

Total time taken to generate the page: 0.08802 seconds