dimSTAT by examples

Oracle runs best on Sun series.


Last week I was attending Oracle RAC DD4D (deep dive for developers) seminar here in Moscow, Russia. No need to say how useful and full of information this seminar was. Thanks to Dmitry and all presenters!

Among many things we covered performance. Specifically it was Oracle RAC performance. System administrators, DBA and Users all wants to have better and faster system. But before you try to make your system better you have to take a look at your system from all possible angles. Users can tell you about their's personal feelings: “Oh, my program A works so slow”. In DBA's hands there are powerful tools from Oracle and other vendors. But what is in sysadmin's hands? Is it still \*stat commands producing rows of data?

What if you don't have experience looking into \*stat commands output and hardly can remember theirs syntax and even names? In that case all you need is dimSTAT. In this post I will show some screenshots of dimSTAT monitoring four Solaris 10 nodes cluster running Oracle RAC.


The main features of dim_STAT are:

  • A web based user interface

  • All collected data is saved in a central database

  • Multiple data views

  • Interactive (Java) or static graphs (PNG)

  • Real Time monitoring

  • Multi-Host monitoring

  • Post analyzing

  • Statistics integration (Add-On)

  • Professional reporting with automated features

  • One-click STAT-Bookmarks



Here are few examples of what can you see with dimSTAT. All screenshots shown here were taken from different times, so most of them does not correlate. Although shown examples are multi-host you may do analysis per hosts with any details you need.


CPU usage in User context:



CPU Usage in System and User+System:



Storage Read+Write and Network In+Out:




Next two charts will show you network packets In and Out:





Comments:

[Trackback] Oracle parallel query performance on a T5140 - The herbal guide to holistic troubleshooting (tags: solaris oracle) the storage anarchist: 1.028: benchmarketing. badly. ...

Posted by c0t0d0s0.org on October 30, 2008 at 09:00 PM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Roman (pomah) Ivanov, ISV Engineering. Tips how to run Oracle best on Sun. Performance monitoring and tuning for system administrators. OpenSolaris user experience.

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today