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

[Message index]

		Add new data file or extend existing data files ? By: JJPB on Mon, 14 October 2019 17:22
		Re: Add new data file or extend existing data files ? By: BlackSwan on Mon, 14 October 2019 18:14
		Re: Add new data file or extend existing data files ? By: EdStevens on Tue, 15 October 2019 06:57
		Re: Add new data file or extend existing data files ? By: JPBoileau on Tue, 15 October 2019 09:35
		Re: Add new data file or extend existing data files ? By: JJPB on Tue, 15 October 2019 13:27
		Re: Add new data file or extend existing data files ? By: EdStevens on Wed, 16 October 2019 06:32
		Re: Add new data file or extend existing data files ? By: JPBoileau on Thu, 17 October 2019 07:44
		Re: Add new data file or extend existing data files ? By: Bill B on Thu, 07 November 2019 11:33
		Re: Add new data file or extend existing data files ? By: Michel Cadot on Thu, 07 November 2019 12:01

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: Thu Apr 25 23:24:35 CDT 2024