18~19
Statistic Value End Value
AVG_BUSY_TIME 47,429
AVG_IDLE_TIME 313,174
AVG_IOWAIT_TIME 62
AVG_SYS_TIME 27,730
AVG_USER_TIME 19,515
BUSY_TIME 3,048,022
IDLE_TIME 20,056,377
IOWAIT_TIME 10,894
SYS_TIME 1,786,525
USER_TIME 1,261,497
LOAD 9 11
OS_CPU_WAIT_TIME 3,666,100
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 238,231,552
VM_OUT_BYTES 1,593,458,688
PHYSICAL_MEMORY_BYTES 268,703,891,456
NUM_CPUS 64
NUM_CPU_CORES 16
NUM_LCPUS 64
NUM_VCPUS 16
GLOBAL_RECEIVE_SIZE_MAX 41,943,040
GLOBAL_SEND_SIZE_MAX 41,943,040
TCP_RECEIVE_SIZE_DEFAULT 16,384
TCP_RECEIVE_SIZE_MAX 9,223,372,036,854,775,807
TCP_RECEIVE_SIZE_MIN 4,096
TCP_SEND_SIZE_DEFAULT 16,384
TCP_SEND_SIZE_MAX 9,223,372,036,854,775,807
TCP_SEND_SIZE_MIN 4,096
21~22
Statistic Value End Value
AVG_BUSY_TIME 5,127
AVG_IDLE_TIME 355,978
AVG_IOWAIT_TIME 110
AVG_SYS_TIME 1,054
AVG_USER_TIME 3,897
BUSY_TIME 340,426
IDLE_TIME 22,795,257
IOWAIT_TIME 12,400
SYS_TIME 79,561
USER_TIME 260,865
LOAD 1 1
OS_CPU_WAIT_TIME 423,600
VM_IN_BYTES 325,079,040
VM_OUT_BYTES 297,758,720
PHYSICAL_MEMORY_BYTES 268,703,891,456
NUM_CPUS 64
NUM_CPU_CORES 16
NUM_LCPUS 64
NUM_VCPUS 16
GLOBAL_RECEIVE_SIZE_MAX 41,943,040
GLOBAL_SEND_SIZE_MAX 41,943,040
TCP_RECEIVE_SIZE_DEFAULT 16,384
TCP_RECEIVE_SIZE_MAX 9,223,372,036,854,775,807
TCP_RECEIVE_SIZE_MIN 4,096
TCP_SEND_SIZE_DEFAULT 16,384
TCP_SEND_SIZE_MAX 9,223,372,036,854,775,807
TCP_SEND_SIZE_MIN 4,096
可以看到 VM_OUT_BYTES 确认是前者更多
疑问在于 到底谁用走了内存:
Begin End
Host Mem (MB): 256,256.0 256,256.0
SGA use (MB): 96,338.3 96,338.3
PGA use (MB): 1,149.0 1,417.9
% Host Mem used for SGA+PGA: 38.04 38.15
就AWR的memory statistcs看 SGA+PGA用得并不多,
需要当时的svmon -G + svmon -U oracle 等信息, 或者nmon数据