I’d like to give a shout out to a very good blog post about monitoring Oracle on NFS by Jeremy Schneider.
DISCLAIMER
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.
Pages
- About
- Index of Posts
- Misc
- Papers, Webcasts, etc
- SLOB Resources
- Little Things Doth Crabby Make
Blogroll
- AWS Database Blog
- Bart Sjerps
- Beat Ramseier
- Bertrand Drouvot's blog
- Daniel Westermann
- flashdba
- Franck Pachot
- Frits Hoogland
- Gokhan Atil
- James Morle
- Jan Karremans Blog (Johnnyq72)
- Jason Arneil
- Jonathan Lewis
- Luca Canali's Blog
- Mahmoud Hatem Blog
- Mark Smith
- Martin Bach
- Mauro Pagano
- Nikolay Savvinov
- Noons
- Pardy DBA
- Real World Technologies
- StorageIOblog (Greg Shulz)
- THE ORACLE ALCHEMIST
- The SQL Herald
- Tim Hall
Join 747 other subscribers
Click It
Recent Posts
- VMware Are Serious About Oracle Database Performance Characterization
- Little Things Doth Crabby Make – Part XXIII. IEC 60027 Still Makes Me Crabby!
- Microsoft Shares Oracle Database Direct NFS Capabilities with SLOB Testing Results
- Announcing SLOB 2.5.4
- Announcing SLOB 2.5.3
- (no title)
- Following Various Legal Action Regarding “Oracle Cloud Revenue”
- Announcing SLOB 2.5.2.4
- Announcing SLOB 2.5.2.3
- Announcing SLOB 2.5.2.2
Recent Comments
Fond Memories
11.2.0.4
Automatic Workload Repository
AWR
columnar database
column projection
DBaaS
Exadata
Exadata benchmarks
Exadata ERP
Exadata OLTP
Exadata Storage Grid
Exadata Xeon 5600 Datawarehousing
HP Oracle Database Machine
Netezza
Netezza Oracle
NUMA
numactl
OOW12
OpenWorld
OpenWorld 2011
Oracle
Oracle Database performance XtremIO flash
Oracle Exadata Storage Server
Oracle Exadata Storage Server Software
Oracle I/O Performance
Oracle Performance
Oracle Programmable Storage Server
predicate offload processing
Random I/O
Sandy Bridge
SLOB
SLOB Testing
SUMA
Teradata
whitepaper
X2-2 vs X2-8
Xeon E5
Xeon E5-2600
Xeon E7 Performance
XtremIO
Copyright
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.
Kevin Closson's Blog: Platforms, Databases and Storage 
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?)
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
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.