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

Free Oracle Tips

HTML Text

 Home
 E-mail Us
 Oracle Articles



 Oracle Training
 Oracle News

 Oracle Forum
 Class Catalog


 Our Staff
 Our Prices
 Help Wanted!

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


 SQL Tuning
 Security

 UNIX
 Oracle UNIX
 Linux
 Oracle Linux
 Monitoring
 Remote help

 Remote plans
 Remote
services
 Oracle C++
 Oracle Java
 Apache
 JDeveloper
 App Server

 Applications
 Oracle Forms
 Oracle Portal
 11i Upgrades
 SQL Server
 Oracle Concepts
 HTML-DB Tips
 Software Help

 Remote Help  
 Development  

 Implementation


 Financials Training
 Oracle 11i
 Oracle Apps 11i
 Oracle Workflow
 Oracle AR 11i Class
 Oracle AP 11i class
 Oracle GL 11i class
 Oracle HR 11i class
 Oracle FA 11i class
 11i Project Mgt
 11i procurement
 11i collections


 Oracle Posters
 Oracle Books

 Oracle Tuning Book
 Oracle RAC Book
 Oracle Security
 Easy Oracle Books
 Oracle Scripts
 SQL Server DBA
 SQL Design Patterns
 WISE
 Excel-DB   


 BC Oracle News


 Rednecks!
 Dress code
 Arabian Stallion

 Burleson Arabians
 Guide Horses
 Don Burleson Blog
 Golf & Travel


 Privacy Policy
 

 

 

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

=

 

 

Hit Counter

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


 

Copyright © 1996 -  2007 by Burleson Enterprises, Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.