How many control files on one volume?
Hello,
Another question has rissen in my mind:
We have a RAID5-SAN. There is only one huge volume where all data remains. Also the control files. When databases are created, Oracle creates 3 control files in the same directory. It doesn't matter where those files are, because when the volume fails, everything fails.
Question: Because we only have one volume, is it safe to only create two control files?
I ask this, because performance will decrease when the number of control files increase and vice versa.
Creating only one, would be best (performance wise), but I think that's a bit tricky!
A penny for your thoughts...
An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.