Create/ ADD a Datafile ONLINE

Experts -

This is a simple question to you, but I just wanted to confirm it before changing anything on the live DB.

Question : Can I add more datafiles  to a new drive just got created while system is online? Does it make any performance impact? Do I have to restart the server? Any concerns?

This is the production system.

Thanks,

~Sve.
LVL 18
sventhanAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
yes, that is perfectly possible without any issues in regards to the online system
0
 
Aaron ShiloConnect With a Mentor Chief Database ArchitectCommented:
yes you can add datafiles to exsisting file gorups on an online system with no worries.
no performance degradetion will occour as long as you dont initialize the file with a TOO large value.

Good Luck
0
 
Aaron ShiloChief Database ArchitectCommented:
by large value imean size
0
 
sventhanAuthor Commented:
Thanks for the feedback.
0
All Courses

From novice to tech pro — start learning today.