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.