OraFAQ Forum: Server Administration » Add new data file or extend existing data files ?

Home » RDBMS Server » Server Administration » Add new data file or extend existing data files ? (Oracle 12 C)

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

Add new data file or extend existing data files ? [message #677833]

Mon, 14 October 2019 17:22

JJPB
Messages: 2
Registered: October 2019

Junior Member

Tablespace is almost full, like to add more space to it either by adding new data file in the same folder or resize the existing data files, just wondering which way is better ? Any difference in terms of performance ? Thanks.

Report message to a moderator

Re: Add new data file or extend existing data files ? [message #677834 is a reply to message #677833]

Mon, 14 October 2019 18:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

IMO, it does not matter

Report message to a moderator

Re: Add new data file or extend existing data files ? [message #677839 is a reply to message #677833]

Tue, 15 October 2019 06:57

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

I would second BlackSwan's statement. I've done it both ways an never detected a difference. My personal preference is to allow a data file to grow to the max size supported by the OS before adding another file. But that's really more about playing to my personal sense of organization and symmetry.

Report message to a moderator

Re: Add new data file or extend existing data files ? [message #677842 is a reply to message #677839]

Tue, 15 October 2019 09:35

JPBoileau
Messages: 88
Registered: September 2017

Member

Back in the days when storage was at a premium and performance was average at best, it made more sense to spread out a tablespace's data files over multiple disks. Nowadays, especially with RAID-0 storage, there isn't much of a gain.

JP

Report message to a moderator

Re: Add new data file or extend existing data files ? [message #677854 is a reply to message #677842]

Tue, 15 October 2019 13:27

JJPB
Messages: 2
Registered: October 2019

Junior Member

Thanks guys for the input, appreciate that, seems not much difference between the two !

Report message to a moderator

Re: Add new data file or extend existing data files ? [message #677857 is a reply to message #677842]

Wed, 16 October 2019 06:32

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

JPBoileau wrote on Tue, 15 October 2019 09:35

Back in the days when storage was at a premium and performance was average at best, it made more sense to spread out a tablespace's data files over multiple disks. Nowadays, especially with RAID-0 storage, there isn't much of a gain.

JP

Don't think it's just RAID-0. It's any system (any RAID, LVM, etc.) that abstracts the physical disks, grouping multiple physical disks into one logical disk. Once you do that, a single file is spread across multiple physical disks, and multiple logical disks may very well be mapping to the same physical disks.

Report message to a moderator

Re: Add new data file or extend existing data files ? [message #677868 is a reply to message #677857]

Thu, 17 October 2019 07:44

JPBoileau
Messages: 88
Registered: September 2017

Member

Agreed. I was speaking from my own experience where I currently work.

JP

Report message to a moderator

Re: Add new data file or extend existing data files ? [message #678074 is a reply to message #677868]

Thu, 07 November 2019 11:33

Bill B
Messages: 1971
Registered: December 2004

Senior Member

I would also look at using BIGFILE. It can get up to 128tb in size (64 bit machine only) and it has one and only 1 datafile per tablespace. It really makes administration and maintenance simple.

Report message to a moderator

Re: Add new data file or extend existing data files ? [message #678075 is a reply to message #678074]

Thu, 07 November 2019 12:01

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

...unless you backup on tape that is smaller than a file.

Report message to a moderator

Previous Topic:	DB12.1 upgrades
Next Topic:	Blank username in v$session , How to find who is connecting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 05 08:23:44 CDT 2025