Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 

RPM Server monitoring for UNIX/Linux

The complete UNIX/Linux server monitor tool

 

BC is the only place to get the "RPM - The Remote Preemptive Monitor for Oracle", the only Oracle monitor with proactive abilities to provide "early warning" for pending problems.  BC has more Oracle monitoring experience than anyone else, with the largest and oldest Oracle Remote DBA support. 

BC consultants wrote the book on Oracle tuning with more than 50 bestselling books in-print, including five of the officially authorized Oracle Press books.  We have encapsulated our decades of Oracle monitoring experience into a single package with proactive capabilities to fix problems before they effect your database.

RPM for Oracle is a proactive Oracle monitoring solution, expert techniques that form a preemptive protection layer to ensure continuous availability of all mission-critical Oracle databases.

Why use the RPM ServerPack service?

The RPM ServerPack is not a software package.  Rather, RPM is a combination of proprietary scripts and consulting services, customized according to the demands of your database.

The RPM ServerPack service provides a complete UNIX/Linux monitoring solution for any Oracle database server.  Unlike other expensive UNIX monitors for Oracle database servers, Oracle ServerPack does not have a cumbersome GUI, and all reports can be generated using SQL*Plus from any client. Oracle ServerPack is the ideal choice for UNIX monitoring for Oracle professionals who need an easy and reliable UNIX monitor:

Here is an example of the types of stunning UNIX trend reports that you can produce from the data inside RPM ServerPack:

Because Oracle ServerPack tracks UNIX metrics over time, you can correlate multiple metrics into single reports.

Automated UNIX server exception reports

The ServerPack software produces automatic UNIX server exception reports, which can be e-mailed every morning.  These UNIX exception reports help you quickly identify server bottlenecks, and those times when your UNIX server is stressed.

                                  RPM ServerPack for UNIX
                    UNIX server Exception Report                               

                          Run queue > 8
                  May indicate an overloaded CPU


SERVER_NAME        date hour     runq pg_in pg_ot  usr  sys  idl
------------------ -----------   ---- ----- ----- ---- ---- ----
HPUX-SV4           02/08/14 22      9     6    0   10    2   88
HPUX-SV4           02/08/14 21      9     6    0   10    2   88
HPUX-SV4           02/08/14 15     10     8    0   17    3   81
HPUX-SV4           02/08/13 21     10     4    0   21    3   76
HPUX-SV4           02/08/12 21     13     4    0   20    3   78
HPUX-SV4           02/08/12 20     11     3    0   15    2   84
HPUX-SV4           02/08/12 08     10     6    0   10    2   89
HPUX-SV4           02/08/12 07     12     6    0   10    2   89
HPUX-SV4           02/08/12 06     11     4    0   21    3   77
HPUX-SV4           02/08/12 05     13     4    0   27    4   69
HPUX-SV4           02/08/09 22      9     7    0   10    2   88
HPUX-SV4           02/08/09 21     11     4    0   14    2   84
HPUX-SV4           02/08/09 14      9     4    0   15    3   83
HPUX-SV4           02/08/08 22     12     7    0   10    2   88
HPUX-SV4           02/08/08 21     10     5    0   25    4   71
HPUX-SV4           02/08/08 18     10     4    0    9    2   90
HPUX-SV4           02/08/08 10      9     6    0   10    2   88
HPUX-SV4           02/08/08 07     12     3    0   31    3   67


                           Page_in and Page_out > 50
                       May indicate overloaded RAM memory
             This should be correlated with page-outs and scan rate
 


SERVER_NAME        date hour     runq pg_in pg_ot  usr  sys  idl
------------------ -----------   ---- ----- ----- ---- ---- ----
HPUX-SV4           02/08/12 11      2   130   365   24    3   74
HPUX-SV4           02/08/08 13      2   130   153    9    2   89

 

                            user+system CPU > 70%
             Indicates periods with a fully-loaded CPU subssystem.
                    Periods of 100% utilization are only a
      concern when runqueue values exceeds the number of CPUs on the server.



SERVER_NAME      date        hour    runq pg_in pg_ot  usr  sys  idl
---------------- ------------------- ---- ----- ----- ---- ---- ---
SUN-SV45         02/08/08    10       4    85     0   85   10    6
SUN-SV45         02/08/10    04       2    23     0   78   16    6
SUN-SV45         02/08/10    06       5   844     0   85    9    5
SUN-SV45         02/08/10    15       3   736     0   82   11    7
SUN-SV45         02/08/10    16       0   142     0   93    5    2
SUN-SV45         02/08/11    04       3   433     0   84   15    1
SUN-SV45         02/08/11    05       2   121     0   91    9    0
SUN-SV45         02/08/11    06       4   652     0   90   10    0
SUN-SV45         02/08/11    07       1    82     0   96    4    0
SUN-SV45         02/08/11    08       1   343     0   95    5    0

 


RPM ServerPack Service Features

  • Full OS Support - Supports AIX, HP/UX, Solaris, Windows and Linux
     

  • Complete UNIX/Linux performance details - Captures data on runqueue waits, page-in, page-out, and CPU details.
     

  • No Cumbersome GUI tool - Oracle ServerPack allows you to directly manipulate and summarize the UNIX performance data directly from standard Oracle SQL.
     

  • For the professional - Once the Oracle table is created, a simple UNIX daemon process populates the table with detailed UNIX performance information. Oracle ServerPack Requires rudimentary knowledge of UNIX and Oracle SQL*plus to install and run the reports.
     

  • Fast Results - Immediately after installation you can start getting useful information about the performance of your UNIX server.
     

  • Low Cost - Why spend tens of thousands of dollars on UNIX monitors, when you have have a simple and flexible solution right at your fingertips?
     

  • Guaranteed Results - You receive up to four hours of free expert consulting each month to assist in the installation, configuration and reporting.

 

The RPM ServerPack service is a unique combination of proprietary scripts and consulting services.  After our consultants cobble-together your solution, you get all of the reports on this page, guaranteed.

Click here for details on our UNIX Monitoring

=

 

 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2016

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.