I’d like to give a shout out to a very good blog post about monitoring Oracle on NFS by Jeremy Schneider.
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.
Recent Posts
- Oracle Exadata Storage Server Technical Deep Dive Series – Part II: Requires a Citrix CODEC.
- Oracle Exadata Storage Server Architecture: Impossible To Back Up?
- Oracle Database File System (DBFS) on Exadata Storage Server. Hidden Content?
- Aren’t Customers Choosing Oracle Database Machine?
- Recorded Webcast Available: Exadata Storage Server Technical Deep Dive – Part IV.
- Oracle-Enhancing Solaris Features. Memory Lane.
- Staging Data For ETL/ELT? Flat Files Appear Magically! No, Load Time Starts With Transfer Time.
- Webcast Announcement Clarification. Exadata Technical Deep Dive Part IV.
- Oracle Data Warehouse Performance Issues? Solve It The Old-Fashioned Way With A Third-Party Accelerator!
- Oracle Exadata Storage Server Technical Deep Dive – Part IV
Recent Comments
Blogroll
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.
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.