Oracle教程

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

本站中文解释

_HISTORY

Oracle视图V$SESSMETRIC_HISTORY，它用来显示会话的历史性能指标，它记录一段时间内每个活动(Acive)会话的性能指标的值的流动变化报告。通常V$SESSMETRIC_HISTORY视图中的数据是被专业的会话性能外观(Performance Analyzer,位于Enterprise Manager中)收集的。数据可以显示活动事务在给定时间点上的性能差异或者一段时间内两个不同时间上性能上的变化。

使用方法：

1. 首先查询需要查看的会话ID或者其他匹配条件：

SQL> SELECT session_id,serial# FROM V$SESSION WHERE USER_NAME = ”;

2. 运用返回的会话ID和序列号，查询V$SESSMETRIC_HISTORY视图以查看性能指标：

SQL> SELECT * FROM V$SESSMETRIC_HISTORY WHERE session_id= AND serial# = ;

官方英文解释

V$SESSMETRIC displays the metric values for all sessions.

Column Datatype Description

BEGIN_TIME

DATE

Begin time of the interval

END_TIME

DATE

End time of the interval

INTSIZE_CSEC

NUMBER

Interval size (in hundredths of a second)

SESSION_ID

NUMBER

Session ID

SESSION_SERIAL_NUM

NUMBER

Session serial number

CPU

NUMBER

CPU usage

PHYSICAL_READS

NUMBER

Number of physical reads

LOGICAL_READS

NUMBER

Number of logical reads

PGA_MEMORY

NUMBER

PGA size at the end of the interval

HARD_PARSES

NUMBER

Number of hard parses

SOFT_PARSES

NUMBER

Number of soft parses

PHYSICAL_READ_PCT

NUMBER

Physical read ratio

LOGICAL_READ_PCT

NUMBER

Logical read ratio

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


数据运维技术 » Oracle 视图 V$SESSMETRIC 官方解释，作用，如何使用详细说明
分享到：

相关推荐