RE: System stats

Just wanted to thank everyone for the input. I intend to go over it in detail once things calm down a bit here. We had a bunch of post patching/post refresh issues this past week that I needed to look into.

Jay Miller
Sr. Oracle DBA

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala Sent: Tuesday, April 16, 2019 9:08 AM
To: oracle-l_at_freelists.org
Subject: Re: System stats

On 4/15/19 5:29 AM, Stefan Koehler wrote:
> P.S.: It is kind of amusing that NetApp is praised as the holy grail in this mail history because it was NetApp that removed their performance analysis tool (if I remember correctly it was/is called LaTX or so) from public. You still can capture the perf data but need to upload them to NetApp afterwards for analysis.
>
> Best Regards

Actually, they have brought it back, albeit with a different name:

https://urldefense.proofpoint.com/v2/url?u=https-3A__library.netapp.com_ecmdocs_ECMP1364220_html_GUID-2D08FF3CE3-2D7B5B-2D470F-2D90F3-2DBFA794737EBB.html&d=DwICaQ&c=nulvIAQnC0yOOjC0e0NVa8TOcyq9jNhjZ156R-JJU10&r=aiKV3Uv2Wo7GqYQcis9TSvB1MZslPOnintrOY1rjG58&m=FQKySDrWTW01M2k2zjtpvcs3OZguyKvqr9vfd1k89JI&s=6dm7HEKPM9OthYoQIYXVf3Uv9IrMEXcknpDwzaRokZI&e=

There is also a Nagios plugin:

https://urldefense.proofpoint.com/v2/url?u=https-3A__www.nagios.com_solutions_netapp-2Dmonitoring_&d=DwICaQ&c=nulvIAQnC0yOOjC0e0NVa8TOcyq9jNhjZ156R-JJU10&r=aiKV3Uv2Wo7GqYQcis9TSvB1MZslPOnintrOY1rjG58&m=FQKySDrWTW01M2k2zjtpvcs3OZguyKvqr9vfd1k89JI&s=id7WrXQnkJO7_NpraK_7evi3rbym4PhxXateVtAQ3Ho&e=

And of course, I was only joking. NetApp is not a panacea. There are other decent arrays too. I use virtual Oracle ZFS Appliance at home for testing snapshot features. Even running on top of a Linux box, the performance is OK and I have never had any problems with it. I chose it over NetApp simulator because NetApp simulator was limited to 99 GB at the time. Finally, as for the blktrace, I like this brief introduction:

https://urldefense.proofpoint.com/v2/url?u=http-3A__fibrevillage.com_storage_539-2Dblktrace-2Dand-2Dbtt-2Dexample-2Dto-2Ddebug-2Dand-2Dtune-2Ddisk-2Di-2Do-2Don-2Dlinux&d=DwICaQ&c=nulvIAQnC0yOOjC0e0NVa8TOcyq9jNhjZ156R-JJU10&r=aiKV3Uv2Wo7GqYQcis9TSvB1MZslPOnintrOY1rjG58&m=FQKySDrWTW01M2k2zjtpvcs3OZguyKvqr9vfd1k89JI&s=1UPqLWQFXqPXD1ZcGJkBTxuICzxOEzpRG-FfmjJhpU0&e=

Regards

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217

--
https://urldefense.proofpoint.com/v2/url?u=http-3A__www.freelists.org_webpage_oracle-2Dl&d=DwICaQ&c=nulvIAQnC0yOOjC0e0NVa8TOcyq9jNhjZ156R-JJU10&r=aiKV3Uv2Wo7GqYQcis9TSvB1MZslPOnintrOY1rjG58&m=FQKySDrWTW01M2k2zjtpvcs3OZguyKvqr9vfd1k89JI&s=KX78x806BRR9rOILSoitdFB8Yn5OQtsai-Pd4hxxl2I&e=

†Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^ Received on Thu Apr 25 2019 - 21:34:30 CEST