Re: Performance issues with SSD on DELL servers

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: "Hameed, Amir" <Amir.Hameed@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Sun, 28 Aug 2016 21:39:16 -0400

On 08/28/2016 07:18 PM, Hameed, Amir wrote:


Are you using dNFS?


Probably not, since he has mentioned /etc/fstab and not /etc/oranfstab. He also hasn't mentioned anything that would lead me to the conclusion that there is a problem with the filer.
Regards

*From:*oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Mladen Gogala
*Sent:* Sunday, August 28, 2016 5:20 PM
*To:* oracle-l@xxxxxxxxxxxxx
*Subject:* Re: Performance issues with SSD on DELL servers

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


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

Other related posts: