| |
 |
|
Oracle Tips by Burleson Consulting
|
The glance process summary screen
The first screen in glance displays the current CPU, memory, disk
and swap consumption, and also reports on the top processes.
The top of the glance screen shows stacked histograms for CPU, disk,
memory and swap. Within each histogram we see two portions, the
system (s) and user (U) values.
The default glance screen is the process screen. Underneath the
histograms, we see a list of all of the top processes on our Oracle
server. These glance screen are from an Oracle Applications system,
and we see the top processes. Here we see multiple tasks of f45runw,
which is the driving task for Oracle SQL*Forms. The tasks on the
process screen are displayed in the order of current CPU consumption
and we also see data on cumulative CPU consumption (Cum CPU) and the
disk I/O rate. In this example, we see high activity for the Oracle
checkpoint background process (ora_ckpt_PR).
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
