 |
|
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.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:
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
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
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. |
 |
|
