Re: Performance issues with SSD on DELL servers

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Sun, 28 Aug 2016 17:20:26 -0400

On 08/28/2016 04:19 PM, Apps DBA wrote:

Hi,
We are facing a wierd performance issue on our Dell 990 series OVM/OEL 7 servers. The storage is Netapp with SSD's mounted as NFS drives on database and application nodes. We followed the Oracle standards in setting the /etc/fstab appropriately, but the performance sometimes runs with WOW factor and some days goes crazy. We are running R1225 with 12c database. Does anyone know the approach to solve this? Please advise.

Thanks in advance!
A

Well, this is a classic performance tuning problem. First, you need to to figure out where the time is spent. Oracle's trace files and V$SYSTEM_EVENT,V$SESSION_EVENT and V$SESSION_WAIT will tell you that. If you have the appropriate licenses, you can also use V$ACTIVE_SESSION_HISTORY. You will need to figure out where was the time spent when the performance "went crazy".
From what I read, you have a reason to believe that the culprit is NetApp. NetApp has very good monitoring tools, so you should check what the OnTap tools will give you. The reasons may be all over the place and you haven't given enough information to make any reasonable assumption.
Essentially, all tuning problems are the same and need to be resolved in two steps:

1. Figure out where the time is spent
2. Figure out how to spend less time

Oracle has an excellent tuning methodology, with many tools, but it will not be able to dive into the inner working of a NetApp filer. For that, you will have to use NetApp tools.

Regards


--
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2016