I am currently baffled by an Oracle RDBMS Archive performance
problem/limitation which is caused by my system configuration.
I have a Solaris system which regardless of Oracle version (7.1.x,
7.2.x and YES 7.3.2) produces Archive log files at an exceptionally
slow rate. This rate is approximately 12-15Mb per minute. Comparable
non-Sun machines are yielding 35-45Mb per minute. I have had prior
experiences with SUN Solaris machines which also produced
35-45Mb/minute, but not being a Systems person, I don't recall those
configurations very well.
This impediment is quite substantial when you consider that I wish to
utilize 250Mb Redo log files.
Has anyone had better results utilizing presto-serve, Solaris
Fast-Writes (NVRAM), or most preferably, configured their machine to
perform better than what I'm experiencing ?
Please keep in mind that the Archive log file destination MUST be a
Unix file system...Raw will just not work.
Any help would be greatly appreciated.