QUOTE (DFiamingo @ Mar 20 2017, 03:18 PM)
I have a client running an EMR software (PCM by Prime Clinical) that gets hammered by an Oracle database with disk reads at 100-200 MBytes per second. 100MB/Sec even when idle.
The system should be sufficent: Dell PowerEdger R710 Dual Xeon X5647 2.93Ghz, 8 CORE, 16 CORES with HT, 32GB Memory, 2TB SATA 7200 in RAID1. 20-30 users.
i manage the hardware but Prime Clinical manages the software.
What if anything can be done to enhance performance on this system?
The EMR company says it's a disk issue so I was thinking about doing a disk image of the RAID1 to a RAID10 to increase the Read/Write performance.
Any other thoughts on how to improve performance?
You may want to have the DBA gather some performance snapshots (AWR if you have the Eneterprise Edition only Diagnostic Pack License or Statspack otherwise) to see what exactly is the system doing that causes i/o during idle hours. It could be excessive auditing or perhaps (if operating on Windows) an overzealous Anti-virus software conflicting with Oracle.