Oracle 视图 V$OSSTAT 官方解释,作用,如何使用详细说明

本站中文解释

Oracle视图V$OSSTAT提供了操作系统监视信息。通过V$OSSTAT,可以查看实例当前操作系统状态,推断实例当前等待的活动、性能、实例服务器系统能力和活动数据量等情况。可以通过此视图跟踪操作系统性能参数,如负载、CPU 使用百分比、系统I/O、网络I/O、内存使用等。

使用方法:

1. 查询操作系统特定性能指标的信息:

SELECT * from V$OSSTAT where statistic# = (select statistic# from V$STATNAME where name = ‘特定性能指标的名字’);

2. 查询操作系统的综合性能:

SELECT b.name, a.value
FROM V$OSSTAT a, V$STATNAME b
WHERE a.statistic# = b.statistic#
ORDER BY b.name;

官方英文解释

V$OSSTAT displays system utilization statistics from the operating system. One row is returned for each system statistic.

Column Datatype Description

STAT_NAME

VARCHAR2(64)

Name of the statistic (see Table 9-3)

VALUE

NUMBER

Instantaneous statistic value

OSSTAT_ID

NUMBER

Statistic ID

COMMENTS

VARCHAR2(64)

Any additional operating system-specific clarifications for the statistic

CUMULATIVE

VARCHAR2(3)

Indicates whether the statistic is cumulative (that is, accumulates over time) (YES) or not (NO)

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

Table 9-3 V$OSSTAT Statistics

Statistic Name Description

NUM_CPUS

Number of CPUs or processors available

IDLE_TIME

Number of hundredths of a second that a processor has been idle, totalled over all processors

BUSY_TIME

Number of hundredths of a second that a processor has been busy executing user or kernel code, totalled over all processors

USER_TIME

Number of hundredths of a second that a processor has been busy executing user code, totalled over all processors

SYS_TIME

Number of hundredths of a second that a processor has been busy executing kernel code, totalled over all processors

IOWAIT_TIME

Number of hundredths of a second that a processor has been waiting for I/O to complete, totalled over all processors

NICE_TIME

Number of hundredths of a second that a processor has been busy executing low-priority user code, totalled over all processors

AVG_IDLE_TIME

Number of hundredths of a second that a processor has been idle, averaged over all processors

AVG_BUSY_TIME

Number of hundredths of a second that a processor has been busy executing user or kernel code, averaged over all processors

AVG_USER_TIME

Number of hundredths of a second that a processor has been busy executing user code, averaged over all processors

AVG_SYS_TIME

Number of hundredths of a second that a processor has been busy executing kernel code, averaged over all processors

AVG_IOWAIT_TIME

Number of hundredths of a second that a processor has been waiting for I/O to complete, averaged over all processors

AVG_NICE_TIME

Number of hundredths of a second that a processor has been busy executing low-priority user code, averaged over all processors

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

VM_IN_BYTES

Total number of bytes of data that have been paged in due to virtual memory paging

VM_OUT_BYTES

Total number of bytes of data that have been paged out due to virtual memory paging

PHYSICAL_MEMORY_BYTES

Total number of bytes of physical memory

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.

NUM_CPU_CORES

Number of CPU cores available (includes subcores of multicore CPUs as well as single-core CPUs)

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)

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_SIZE_DEFAULT

Default size of the TCP send buffer

TCP_SEND_SIZE_MAX

Maximum size of the TCP send buffer

TCP_RECEIVE_SIZE_MIN

Minimum size of the TCP receive buffer

TCP_RECEIVE_SIZE_DEFAULT

Default size of the TCP receive buffer

TCP_RECEIVE_SIZE_MAX

Maximum size of the TCP receive buffer

GLOBAL_SEND_SIZE_MAX

Maximum size of the global send buffer

GLOBAL_RECEIVE_SIZE_MAX

Maximum size of the global receive buffer

Note:

The availability of all statistics except for NUM_CPUS and RSRC_MGR_CPU_WAIT_TIME is subject to the operating system platform on which the Oracle Database is running.


数据运维技术 » Oracle 视图 V$OSSTAT 官方解释,作用,如何使用详细说明