-
I just can't remember exactly but I can recall to read somewhere about the redo log should not be in the same place as rollback ???? or redo log shouldn't not be the same location with archive log ????
I think for sure redo log can't be in the same location with archive. what about rollback and redo ????
Please advise
-
well it depends how you have created your mount points and file systems, if you put all disks under same mounting point and stuff everything together in RAID-0 even you put RBS, DATA, INDEX, REDO, ARCHIVE whatever in different directories or file systems you wont yield any positive results
I would isolate redo logs if possible in seperate disks from database since they are pretty i/o intensive files