Page History
...
The server-level OS statistics summarized by each aggregated invocation.
Column Name | Column Description |
---|---|
OSSS_TIMESTAMP | The time summary. |
OSSS_PWHG_ID | The hour group ID. |
OSSS_SLICES_SUM | The number of 15-minute slices in the time summary that data was reported by the OS agent for this instance. |
OSSS_PWII_INSTANCE_ID | The ID of the OS server instance. |
OSSS_NUM_CPUS | The number of processors on the server. |
OSSS_TOT_PHY_MEM | Installed physical memory on the server, specified in |
...
megabytes. | |
OSSS_TOT_VIR_MEM | The virtual memory configured for the server (physical memory and paging file), specified in |
...
megabytes. | |
OSSS_USER_CPU_SUM | The non-idle processor time spent in user mode, specified in seconds. The user mode is a restricted processing mode designed for applications, environment subsystems, and integral subsystems. |
OSSS_SYS_CPU_SUM | The non-idle processor time spent in privileged mode, specified in seconds. The privileged mode is designed for operating system components and allows direct access to hardware and all memory. |
OSSS_WAIT_CPU_SUM | The amount of time that the processor was idle during which the system had an outstanding disk I/O request, specified in seconds. |
OSSS_OTHER_CPU_SUM | The miscellaneous non-idle processor time, specified in seconds. |
OSSS_SWITCH_SUM | The combined rate at which all processors on the server are switched from one thread to another. |
OSSS_IO_SUM | The total OS I/O consumption on the server, specified in |
...
megabytes. | |
OSSS_PHY_MEM_SUM | The physical memory consumption, specified in |
...
megabytes. | |
OSSS_VIR_MEM_SUM | The virtual memory consumption, specified in |
...
megabytes. | |
OSSS_PAGING_SUM | The total OS paging on the server. |
OSSS_LOAD_SUM | The total server load. |
OSSS_PROC_START |
...
The total number of processes started in this time summary. | |
OSSS_PROC_SUM | The total number of processes running in this time summary. |
Expressions
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.
Oracle SQL Server Expression description
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_SU M / OSSS_NUM_CPUS) / (sum(OSSS_SLICES_SUM)
*900.0)) * 100.0 (sum(OSSS_USER_CPU_SU M / 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_SU M / OSSS_NUM_CPUS) / (sum(OSSS_SLICES_SUM)
*900.0)) * 100.0 (sum(OSSS_WAIT_CPU_SU M / 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 I/O throughput, specified as I/O 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.
Oracle SQL Server Expression description
(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.
...