I’d like to give a shout out to a very good blog post about monitoring Oracle on NFS by Jeremy Schneider.
EMC Employee Disclaimer
The opinions and interests expressed on EMC employee blogs are the employees' own and do not necessarily represent EMC's positions, strategies or views. EMC makes no representation or warranties about employee blogs or the accuracy or reliability of such blogs. When you access employee blogs, even though they may contain the EMC logo and content regarding EMC products and services, employee blogs are independent of EMC and EMC does not control their content or operation. In addition, a link to a blog does not mean that EMC endorses that blog or has responsibility for its content or use.
This disclaimer was put into place on March 23, 2011.
Click It
Pages
- About
- Index of Posts
- Misc
- Papers, Webcasts, etc
- Little Things Doth Crabby Make
Recent Posts
- Oracle Exadata Database Machine: Proving 160 Xeon E7 Cores Are As “Slow” As 128 Xeon E5 Cores?
- SLOB 2 — A Significant Update. Links Are Here.
- Announcing EMC WORLD 2013 Flash Related Sessions
- My First Words on Oracle’s SPARC T5 Processor — The World’s Fastest Microprocessor?
- Can Oracle Database Release 2 (11.2.0.3) Properly Count Cores? No. Does It Matter All That Much? Not Really..
- My Oaktable World 2012 Video Session Is Now Online
- Using Linux Perf(1) To Analyze Database Processes – Part I
- Do IT Vendors Ever Do Real “Knowledge Sharing” ?
- Luca Canali’s Wonderful Public Oracle-Related Materials
- My First Words About Oracle Exadata X3 In-Memory Database Machine
Recent Comments
Blogroll
Fond Memories
Tags
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 Exadata Storage Server
Oracle Exadata Storage Server Software
Oracle Programmable Storage Server
predicate offload processing
Sandy Bridge
SUMA
Teradata
X2-2 vs X2-8
Xeon E5
Xeon E5-2600
Xeon E7 Performance
Copyright
All content is © Kevin Closson and "Kevin Closson's Blog: Platforms, Databases, and Storage", 2006-2013. 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.
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):
http://extranet.polyserve.com/kevinblog/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.