侧边栏壁纸
博主头像
与晚风述往事博主等级

万般皆下品,唯有读书高。

  • 累计撰写 149 篇文章
  • 累计创建 29 个标签
  • 累计收到 7 条评论

目 录CONTENT

文章目录

V$OSSTAT动态性能视图

与晚风述往事
2021-12-01 / 0 评论 / 0 点赞 / 216 阅读 / 4,550 字 / 正在检测是否收录...
温馨提示:
本文最后更新于 2021-12-01,若内容或图片失效,请留言反馈。部分素材来自网络,若不小心影响到您的利益,请联系我们删除。

介绍

V$OSSTAT视图提供了查询系统利用率的方法。

视图详情

字段名 字段类型 描述 备注
STAT_NAME VARCHAR2(64) Name of the statistic 统计的名称
VALUE NUMBER Instantaneous statistic value 瞬时统计的值
OSSTAT_ID NUMBER Statistic ID 表示统计信息的ID
COMMENTS VARCHAR2(64) Any additional OS-specific clarifications for the statistic 对统计的数据的额外说明
CUMULATIVE VARCHAR2(3) Indicates whether the statistic is cumulative (that is, accumulates over time) (YES) or not (NO) 统计的数据是否累计,YES代表累计,NO代表非累计

统计详情

统计名称 统计的描述 统计的额外说明 备注
NUM_CPUS Number of CPUs or processors available Number of active CPUs 可用的CPU数量
IDLE_TIME Number of hundredths of a second that a processor has been idle, totalled over all processors Time (centi-secs) that CPUs have been in the idle state CPU空闲的时间,单位10毫秒(百分之一秒) 统计范围为所有CPU总计
BUSY_TIME Number of hundredths of a second that a processor has been busy executing user or kernel code, totalled over all processors Time (centi-secs) that CPUs have been in the busy state CPU忙碌(运行)的时间,单位10毫秒(百分之一秒) 统计范围为所有CPU总计
USER_TIME Number of hundredths of a second that a processor has been busy executing user code, totalled over all processors Any additional OS-specific clarifications for the statistic CPU处理用户代码的时间,单位10毫秒(百分之一秒) 统计范围为所有CPU总计
SYS_TIME Number of hundredths of a second that a processor has been busy executing kernel code, totalled over all processors Time (centi-secs) spent in the kernel CPU处理内核代码的时间,单位10毫秒(百分之一秒) 统计范围为所有CPU总计
IOWAIT_TIME Number of hundredths of a second that a processor has been waiting for I/O to complete, totalled over all processors Time (centi-secs) spent waiting for IO CPU等待I/O完成的时间,单位10毫秒(百分之一秒) 统计范围为所有CPU总计
NICE_TIME Number of hundredths of a second that a processor has been busy executing low-priority user code, totalled over all processors Time (centi-secs) spend in low-priority user code CPU处理低优先级用户代码的时间,单位10毫秒(百分之一秒) 统计范围为所有CPU总计
AVG_IDLE_TIME Number of hundredths of a second that a processor has been idle, averaged over all processors CPU空闲的时间 统计每个CPU的平均值
AVG_BUSY_TIME Number of hundredths of a second that a processor has been busy executing user or kernel code, averaged over all processors CPU忙碌(运行)的时间 统计每个CPU的平均值
AVG_USER_TIME Number of hundredths of a second that a processor has been busy executing user code, averaged over all processors CPU处理用户代码的时间 统计每个CPU的平均值
AVG_SYS_TIME Number of hundredths of a second that a processor has been busy executing kernel code, averaged over all processors CPU处理内核代码的时间 统计每个CPU的平均值
AVG_IOWAIT_TIME Number of hundredths of a second that a processor has been waiting for I/O to complete, averaged over all processors CPU等待I/O完成的时间 统计每个CPU的平均值
AVG_NICE_TIME Number of hundredths of a second that a processor has been busy executing low-priority user code, averaged over all processors CPU处理低优先级用户代码的时间 统计每个CPU的平均值
OS_CPU_WAIT_TIME Total number of hundredths of a second that processes have been in a ready state, waiting to be selected by the operating system scheduler to run
RSRC_MGR_CPU_WAIT_TIME Total number of hundredths of a second that Oracle processes have been in a ready state, waiting for CPU to be available for their consumer group in the currently active resource plan Time (centi-secs) processes spent in the runnable state waiting 进程处于可运行状态等待的时间,单位10毫秒(百分之一秒)
VM_IN_BYTES Total number of bytes of data that have been paged in due to virtual memory paging Bytes paged in due to virtual memory swapping 因虚拟内存交换而分页的字节数(BYTES)
VM_OUT_BYTES Total number of bytes of data that have been paged out due to virtual memory paging Bytes paged out due to virtual memory swapping 因虚拟内存交换而换出的字节数(BYTES)
PHYSICAL_MEMORY_BYTES Total number of bytes of physical memory Physical memory size in bytes 操作系统物理内存的大小,单位是字节(BYTES)
LOAD Current number of processes that are either running or in the ready state, waiting to be selected by the operating-system scheduler to run. On many platforms, this statistic reflects the average load over the past minute. Number of processes running or waiting on the run queue 运行队列中正在运行或等待的进程数量
NUM_CPU_CORES Number of CPU cores available (includes subcores of multicore CPUs as well as single-core CPUs) Number of CPU cores CPU核数
NUM_CPU_SOCKETS Number of CPU sockets available (represents an absolute count of CPU chips on the system, regardless of multithreading or multi-core architectures) Number of physical CPU sockets 物理CPU的插槽数 不一定准确
NUM_VCPUS Number of virtual CPUs available
NUM_LCPUS Number of logical CPUs available (includes hardware threads if hardware threading is turned on)
TCP_SEND_SIZE_MIN Minimum size of the TCP send buffer TCP Send Buffer Min Size TCP发送缓冲区的最小大小
TCP_SEND_SIZE_DEFAULT Default size of the TCP send buffer TCP Send Buffer Default Size TCP发送缓冲区的默认大小
TCP_SEND_SIZE_MAX Maximum size of the TCP send buffer TCP Send Buffer Max Size TC[发送缓冲区的最大大小
TCP_RECEIVE_SIZE_MIN Minimum size of the TCP receive buffer TCP Receive Buffer Min Size TCP接收缓冲区的最小大小
TCP_RECEIVE_SIZE_DEFAULT Default size of the TCP receive buffer TCP Receive Buffer Min Size TCP接收缓冲区的默认大小
TCP_RECEIVE_SIZE_MAX Maximum size of the TCP receive buffer TCP Receive Buffer Max Size TCP接收缓冲区的最大大小
GLOBAL_SEND_SIZE_MAX Maximum size of the global send buffer Global send size max (net.core.wmem_max) 全局发送缓冲区的最大大小
GLOBAL_RECEIVE_SIZE_MAX Maximum size of the global receive buffer Global receive size max (net.core.rmem_max) 全局接收缓冲区的最大大小
0

评论区