|
|
| |
 |
|
Oracle Tips by Burleson Consulting
|
sar –w: The Memory Switching
and Swapping Activity Report
The sar –w command is especially useful if you suspect that your
database server is experiencing a memory shortage. The following
example shows the swapping activity report that you get from sar:
root> sar -w 5 5
HP-UX corp-hp1 B.11.00 U 9000/800 12/25/00
07:19:33 swpin/s bswin/s swpot/s bswot/s pswch/s
07:19:38 0.00 0.0 0.00 0.0 261
07:19:43 0.00 0.0 0.00 0.0 231
07:19:48 0.00 0.0 0.00 0.0 326
07:19:53 0.00 0.0 0.00 0.0 403
07:19:58 0.00 0.0 0.00 0.0 264
Average 0.00 0.0 0.00 0.0 297
The column descriptions for sar –w are as follows:
* swpin/s?Number of process swap-ins per second.
* swpot/s?Number of process swap-outs per second.
* bswin/s?Number of 512-byte swap-ins per second.
* bswot/s?Number of 512-byte swap-outs per second.
* pswch/s?Number of process context switches per second.
 |
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. |
|
|
|
|
