Greetings,
We recently started testing an F740 in a Sun Solaris 2.6 environment with Oracle 8 The host is a Sun E4000 and has a Sun A1000 disk attached.
Normally, the filers perform far better than direct-attached disk in this setup.
However when we run all the Oracle stuff on the filer, including the directory specified by ORACLE_HOME, the system is sorrowfully slow.
We have another login, which points ORACLE_HOME at a location on the A1000 storage. The Oracle datafiles are all still located on the filer.
In this case, the system is normal (i.e. good and fast). I am at a loss to explain why the location of the ORACLE_HOME would affect things in this way.
During the poor Oracle performance, activity on the filer is minimal (3 - 5%)
When we throw bursts of large file data at the filer (copy from /dev/zero) we get throughputs of about 12 MB/s at utilisations of 50 to 80 percent so the filer seems to be working fine.
Can anyone suggest where to look next ?
regards
John Hope-Bailie source consulting E-mail: johnhb@sourceconsulting.co.za