Home » RDBMS Server » Server Administration » Add new data file or extend existing data files ? (Oracle 12 C)
Add new data file or extend existing data files ? [message #677833] Mon, 14 October 2019 17:22 Go to next message
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.
Re: Add new data file or extend existing data files ? [message #677834 is a reply to message #677833] Mon, 14 October 2019 18:14 Go to previous messageGo to next message
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
Re: Add new data file or extend existing data files ? [message #677839 is a reply to message #677833] Tue, 15 October 2019 06:57 Go to previous messageGo to next message
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.
Re: Add new data file or extend existing data files ? [message #677842 is a reply to message #677839] Tue, 15 October 2019 09:35 Go to previous messageGo to next message
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
Re: Add new data file or extend existing data files ? [message #677854 is a reply to message #677842] Tue, 15 October 2019 13:27 Go to previous messageGo to next message
JJPB
Messages: 2
Registered: October 2019
Junior Member
Thanks guys for the input, appreciate that, seems not much difference between the two !
Re: Add new data file or extend existing data files ? [message #677857 is a reply to message #677842] Wed, 16 October 2019 06:32 Go to previous messageGo to next message
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.
Re: Add new data file or extend existing data files ? [message #677868 is a reply to message #677857] Thu, 17 October 2019 07:44 Go to previous messageGo to next message
JPBoileau
Messages: 88
Registered: September 2017
Member
Agreed. I was speaking from my own experience where I currently work.

JP
Re: Add new data file or extend existing data files ? [message #678074 is a reply to message #677868] Thu, 07 November 2019 11:33 Go to previous messageGo to next message
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.
Re: Add new data file or extend existing data files ? [message #678075 is a reply to message #678074] Thu, 07 November 2019 12:01 Go to previous message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

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


Current Time: Tue Mar 19 06:35:26 CDT 2024