Page History
...
| Oracle | SQL Server | Expression Description |
|---|---|---|
sum(OSSS_LOAD_SUM) / sum(OSSS_SLICES_SUM) | sum(OSSS_LOAD_SUM) / sum(OSSS_SLICES_SUM) | Average server load for a given time range. |
sum(OSSS_PHY_MEM_SUM) * 1024.0 * 1024.0 / sum(OSSS_SLICES_SUM) | sum(OSSS_PHY_MEM_SUM) * 1024.0 * 1024.0 / sum(OSSS_SLICES_SUM) | Server physical memory consumption. |
sum(OSSS_VIR_MEM_SUM) |
...
* 1024.0 * 1024.0 / |
...
sum(OSSS_SLICES_SUM) | sum(OSSS_VIR_MEM_SUM) |
...
* 1024.0 * 1024.0 / |
...
sum(OSSS_SLICES_SUM) | Server virtual memory consumption. |
(sum(OSSS_PHY_MEM_SUM |
...
/ OSSS_TOT_PHY_MEM) / |
...
sum(OSSS_SLICES_SUM)) |
...
* 100.0 | (sum(OSSS_PHY_MEM_SUM |
...
/ OSSS_TOT_PHY_MEM) / |
...
sum(OSSS_SLICES_SUM)) |
...
* 100.0 | Server physical memory utilization |
...
| in percentage from total server physical memory |
...
| . |
(sum(OSSS_VIR_MEM_ |
...
SUM / OSSS_TOT_VIR_MEM) / |
...
sum(OSSS_SLICES_SUM)) |
...
* 100.0 | (sum(OSSS_VIR_MEM_ |
...
SUM / OSSS_TOT_VIR_MEM) / |
...
sum(OSSS_SLICES_SUM)) |
...
* 100.0 | Server virtual memory utilization |
...
| in percentage from total server virtual memory |
...
| . |
(sum(OSSS_USER_CPU_ |
...
SUM / OSSS_NUM_CPUS) / (sum(OSSS_SLICES_SUM) |
...
* 900.0)) * 100.0 | (sum(OSSS_USER_CPU_ |
...
SUM / OSSS_NUM_CPUS) / (sum(OSSS_SLICES_SUM) |
...
* 900.0)) * 100.0 | Server |
...
| user CPU utilization |
...
| in percentage from total available processor power |
...
| . |
(sum(OSSS_SYS_CPU_SUM |
...
/ OSSS_NUM_CPUS) / (sum(OSSS_SLICES_SUM) |
...
* 900.0)) * 100.0 | (sum(OSSS_SYS_CPU_SUM |
...
/ OSSS_NUM_CPUS) / (sum(OSSS_SLICES_SUM) |
...
* 900.0)) * 100.0 | Server |
...
| system CPU utilization |
...
| in percentage from total available processor power |
...
| . |
(sum(OSSS_WAIT_CPU_ |
...
SUM / OSSS_NUM_CPUS) / (sum(OSSS_SLICES_SUM) |
...
* 900.0)) * 100.0 | (sum(OSSS_WAIT_CPU_ |
...
SUM / OSSS_NUM_CPUS) / (sum(OSSS_SLICES_SUM) |
...
* 900.0)) * 100.0 | Server |
...
| wait IO CPU utilization |
...
| in percentage from total available processor power |
...
| . |
(sum(OSSS_OTHER_CPU_S UM / OSSS_NUM_CPUS) / (sum(OSSS_SLICES_SUM) |
...
* 900.0)) * 100.0 | (sum(OSSS_OTHER_CPU_S UM / OSSS_NUM_CPUS) / (sum(OSSS_SLICES_SUM) |
...
* 900.0)) * 100.0 | Server |
...
| other CPU utilization |
...
| in percentage from total available processor power |
...
| . | ||
Sum of above four expressions | Sum of above four expressions | Total |
...
| server CPU utilization |
...
| in percentage from total available processor power |
...
| . |
(sum(OSSS_IO_SUM) * |
...
1024. |
...
0 * 1024.0) / (sum(OSSS_SLICES_SUM) |
...
* 900.0) | (sum(OSSS_IO_SUM) * |
...
1024. |
...
0 * 1024.0) / (sum(OSSS_SLICES_SUM) |
...
* 900.0) | Server |
...
| IO throughput, |
...
| specific as |
...
| IO bytes per second. |
(sum(OSSS_PAGING_SUM) |
...
* 1024.0 * 1024.0) / (sum(OSSS_SLICES_SUM) |
...
* 900.0) | (sum(OSSS_PAGING_SUM) |
...
* 1024.0 * 1024.0) / (sum(OSSS_SLICES_SUM) |
...
* 900.0) | Server |
...
| page faults rate, specified as paging per second. |
...
(sum(OSSS_SWITCH_SUM) |
...
* 1024.0 * 1024.0) / (sum(OSSS_SLICES_SUM) |
...
* 900.0) | (sum(OSSS_SWITCH |
...
_SUM) * 1024.0 * |
...
1024.0) / (sum(OSSS_SLICES_SUM) |
...
* 900.0) | Server |
...
| context switches rate, specified as |
...
| context switches per second. |
PW_OSPS_PROC_STATISTICS_T
...