Poor performance Oracle 10g on vFiler
2016-04-08 08:18 PM
We are facing currently massive performance issues on one of the Oracle DB running on Solaris 10 Sparc and NetApp vFiler.
Host has 6 databases
5 databases have - separate 5 IP for the unseryling storage volumes and connected to single vFiler.
last 6th one also has got separate IP but the disk ServiceTime is around 20 seconds ( yes seconds ! )
Host has got 02 network interfaces and IPMP is configured in ACTIVE-STANDBY mode
Database version is - 10.2.0.5
1) Is it recommended to use ACTIVE-ACTIVE configuration of IPMP for highly transactional databases which does massive IO? if configured are there any known side effects ?
2) Is there any know bug on Solaris 10 Sparc which might be causing issues here ?( however looks less likely as OS is doing well for other 5 databases on the same host/os)
1 REPLY 1
Re: Poor performance Oracle 10g on vFiler
2016-04-10 10:33 AM
Can you provide any insight into your aggregate configuration and volume layout? E.g. how many disks in the aggregate(s), what volumes are on which aggregates, are there other workloads sharing the same aggr/vol, protocol(s) used, etc. Additionally, what type of workload is seeing the extremely high latency? Is it log files, data files, backup, etc.?
If this post resolved your issue, please help others by selecting ACCEPT AS SOLUTION or adding a KUDO.