How many control files on one volume?
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.
Click Here to Expand Forum to Full Width