A Good Blog Post About Monitoring Oracle Over NFS

I’d like to give a shout out to a very good blog post about monitoring Oracle on NFS by Jeremy Schneider.

3 Responses to “A Good Blog Post About Monitoring Oracle Over NFS”


  1. 1 Jeremy Schneider June 14, 2007 at 11:18 pm

    Thanks for the ping!

    Have a quick question: iptraf was a nice way to monitor throughput – but do you know any way to measure latencies at the OS level for NFS? For block devices iostat reports it in the “await” and “svctm” columns (the former includes time in the request queue) – but I’m not sure how I could do this with NFS devices and it’s a piece of information I’d really like to know. Oracle reports some figures for datafiles but I’d like to see figures from a lower level and I don’t think Oracle measures latencies on files such as online logs, archive logs, or control files. (Or does it?)

  2. 2 kevinclosson June 15, 2007 at 1:19 am

    Excellent question Jeremy and one for which I’ve been investigating a solution ala the Oracle Disk Manager I/O stats in PolyServe (HP) ODM (see page 9 of the following referenced doc):

    http://extranet.polyserve.com/kevinblog/PolyServe_ODM_usrgd.pdf

  3. 3 Alex Gorbachev June 15, 2007 at 3:00 am

    Jeremy, you can collect some summary stats from V$SESSTAT, V$SESSION_EVENT, V$SYSSTAT and V$SYSTEM_EVENT. For example, you can see log file parallel write numbers for LGWR and etc. Not a lot of details but something.


Leave a Reply




Disclaimer

The views expressed on this blog are my own and do not reflect the views of Oracle Corporation. The views and opinions expressed by visitors on this blog are theirs, not mine.
All information and materials provided here are provided "as-is"; Oracle disclaims all express and implied warranties, including, the implied warranties of merchantability or fitness for a particular use. Oracle shall not be liable for any damages, including, direct, indirect, incidental, special or consequential damages for loss of profits, revenue, data or data use, incurred by you or any third party in connection with the use of this information or these materials.
website metrics