OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Datafile Size

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Datafile Size [message #217802]

Mon, 05 February 2007 11:04

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

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: Datafile Size [message #217808 is a reply to message #217805]

Mon, 05 February 2007 11:57

ebrian
Messages: 2794
Registered: April 2006

Senior Member

WOW...Mahesh...I guess the OP had second thoughts ??

Report message to a moderator

Re: Datafile Size [message #217813 is a reply to message #217808]

Mon, 05 February 2007 12:20

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Re: Datafile Size [message #217817 is a reply to message #217813]

Mon, 05 February 2007 14:19

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

Report message to a moderator

Re: Datafile Size [message #217821 is a reply to message #217817]

Mon, 05 February 2007 14:36

Mahesh Rajendran
Messages: 10708
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

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.

Report message to a moderator

Previous Topic:	How to set up Oracle XA?
Next Topic:	Rollback Segments

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 05:42:41 CST 2025