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):

    Click to access 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

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.


I work for Amazon Web Services. The opinions I share in this blog are my own. I'm *not* communicating as a spokesperson for Amazon. In other words, I work at Amazon, but this is my own opinion.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 747 other subscribers
Oracle ACE Program Status

Click It

website metrics

Fond Memories


All content is © Kevin Closson and "Kevin Closson's Blog: Platforms, Databases, and Storage", 2006-2015. Unauthorized use and/or duplication of this material without express and written permission from this blog’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Kevin Closson and Kevin Closson's Blog: Platforms, Databases, and Storage with appropriate and specific direction to the original content.

%d bloggers like this: