BC remote Oracle DBA - Call (800) 766-1884  
Oracle Consulting Oracle Training Development

Remote DBA

Remote DBA Plans  

Remote DBA Service

Remote DBA RAC

   
Remote DBA Oracle Home
Remote DBA Oracle Training
Remote DBA SQL Tuning Consulting
Remote DBA Oracle Tuning Consulting
Remote DBA Data Warehouse Consulting
Remote DBA Oracle Project Management
Remote DBA Oracle Security Assessment
Remote DBA Unix Consulting
Burleson Books
Burleson Articles
Burleson Web Courses
Burleson Qualifications
Oracle Links
Remote DBA Oracle Monitoring
Remote DBA Support Benefits
Remote DBA Plans & Prices
Our Automation Strategy
What We Monitor
Oracle Apps Support
Print Our Brochure
Contact Us (e-mail)
Oracle Job Opportunities
Oracle Consulting Prices





   

 

 

 

Remote DBA services

Remote DBA Support

Remote DBA RAC

Remote DBA Reasons

Remote Oracle Tuning

Remote DBA Links

Oracle DBA Support

Oracle DBA Forum

Oracle Disaster

Oracle Training

Oracle Tuning

Oracle Training

 Remote DBA SQL Server

Remote MSSQL Consulting

Oracle DBA Hosting

Oracle License Negotiation

 

 


 

 

 

 

 
 

Daily Server Alert Report

Oracle Tips by Burleson Consulting

As we noted in Chapter 5, the Oracle Remote DBA is very interested in monitoring conditions on the database servers and web servers. The script that follows is generally run daily to report on exceptional conditions within any server in the Oracle environment. The data is collected in five-minute intervals and reported with hourly averages. When the Remote DBAs find an out-of-bounds server condition, they can run detailed reports that display the data in five-minute intervals.

run_vmstat.ksh

The run_vmstat.ksh driver script submits the vmstat_alert report and e-mails the output to the appropriate staff members.

vmstat_alert.sql

The vmstat_alert.sql report provides information on server conditions that may contribute to poor performance.

The vmstat_alert.sql script gathers the following server information:

  • Run queue waits When the run queue exceeds the number of CPUs, the server is experiencing CPU bottlenecks:

  • run_vmstat.kshThe run_vmstat.ksh driver script submits the vmstat_alert report and e-mails the output to the appropriate staff members.

  • vmstat_alert.sqlThe vmstat_alert.sql report provides information on server conditions that may contribute to poor performance.

The vmstat_alert.sql script gathers the following server information:

  • Run queue waits When the run queue exceeds the number of CPUs, the server is experiencing CPU bottlenecks:

Fri Dec 29                                                             page    1
                                 run queue > 2
                         May indicate an overloaded CPU

SERVER_NAME       date       hour      runq pg_in pg_ot  usr  sys  idl      
----------------- -------------------- ---- ----- ----- ---- ---- ----      
BAD-01            00/12/22    13          6     0     0   62    7   32      
BAD-01            00/12/22    15          3     0     0   82   18    0      
BAD-01            00/12/22    17          3     0     0   76   16    8      
BAD-01            00/12/27    11          3     0     0   77    5   20    

  • RAM swapping When page-in operations exist, the maximum RAM capacity of the server has been exceeded:

Fri Dec 29                                                             page    1
                                  page_in > 1
                         May indicate overloaded memory

SERVER_NAME       date       hour      runq pg_in pg_ot  usr  sys  idl      
----------------- -------------------- ---- ----- ----- ---- ---- ----      
AD-01             00/12/22    14          0    19     0    1    1   97      
AD-01             00/12/26    11          0    32     0    0    0   99      
AD-01             00/12/28    17          0     5     0    0    1   99      
JANETDB           00/12/22    13          0     3     0    1    3   96      
JANETDB           00/12/22    14          0    27     1    6   17   77      
JANETDB           00/12/22    15          0     3     0    1    3   96      
JANETDB           00/12/22    16          0     7     0    3    9   88      
JANETDB           00/12/22    17          0    10     0    4   10   86      
JANETDB           00/12/22    18          0     2     1    1    3   96      
JANETDB           00/12/23    09          0     2     0    1    3   96      
JANETDB           00/12/24    03          0     4     0    1    3   96      
JANETDB           00/12/26    10          0     3     0    1    3   96      
JANETDB           00/12/26    11          0     2    21    8   17   75      
JANETDB           00/12/26    12          0    10    10   13   27   60      
JANETDB           00/12/27    09          0    10     0    1    3   96       
JANETDB           00/12/27    10          0     5     0    1    3   96      
JANETDB           00/12/27    11          0     6     0    1    3   95      
JANETDB           00/12/28    03          0     2     0    1    3   96      
JANETDB           00/12/28    11          0     2     0    1    3   95      
JANETDB           00/12/28    21          0     3     1    2    4   95    

  • High CPU The Remote DBA is often interested in times when the database CPU utilization is greater than 95 percent.

Fri Dec 29                                                             page    1
                               user+system > 70%
                          Indicates an overloaded CPU

SERVER_NAME       date       hour      runq pg_in pg_ot  usr  sys  idl      
----------------- -------------------- ---- ----- ----- ---- ---- ----      
AD-01             00/12/22    08          2     0     0   69    3   28       
AD-01             00/12/22    13         12     0     0   89   11    1      
AD-01             00/12/22    15          0     0     0   63   29    8      
AD-01             00/12/22    17          1     0     0   53   27   20      
AD-01             00/12/26    12          1     0     0   77    4   19      
AD-01             00/12/27    11          3     0     0   86    6    9    

Next, let’s look at a real-time alert script that can warn the Remote DBA about impending problems in the Oracle environment.

This is an excerpt from "Oracle9i High Performance tuning with STATSPACK" by Oracle Press.


 
 
 
Get the Complete
Oracle Tuning Details 

The landmark book "Oracle Tuning: The Definitive Reference Second Edition" has been updated with over 1,500 pages of expert performance tuning tips. It's packed with scripts and tools to hypercharge Oracle 11g performance and you can buy it for 40% off directly from the publisher.
 
 

Expert Remote DBA

BC is America's oldest and largest Remote DBA Oracle support provider.  Get real Remote DBA experts, call
BC Remote DBA today.

 

   

 

Remote DBA Service
 

Oracle Tuning Book

 

Advance SQL Tuning Book 

BC Oracle support

Oracle books by Rampant

Oracle monitoring software

 

 

 

 

 

 

BC Remote Oracle Support

Remote DBA

Remote DBA Services

Copyright © 1996 -  2013 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.



Hit Counter