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

本站中文解释

:

Oracle视图V$AW_LONGOPS用于监控长操作进程(即长时间运行的操作)。它可以帮助查看后台活动的持续时间和所完成的速度。

用法:

1、查看所有长期操作:SELECT * FROM V$AW_LONGOPS;

2、查看具体用户的某个长期操作:SELECT * FROM V$AW_LONGOPS WHERE USERNAME = ‘YOURUSER’ AND OPNAME = ‘SOMETASK’;

3、在需要的时候可以查看某个操作的进度:SELECT PERCENT_COMPLETE FROM V$AW_LONGOPS WHERE OPNAME = ‘SOMETASK’;

4、查看某个操作的可能存在的问题:SELECT ERROR# FROM V$AW_LONGOPS WHERE OPNAME = ‘SOMETASK’;

使用视图V$AW_LONGOPS可以有效地监控正在进行的长期操作进程,并且可以获取各种实时信息,从而调整用户和应用管理策略,实现数据库的有效管理和使用。

官方英文解释

V$AW_LONGOPS displays status information about active SQL cursors initiated in an analytic workspace.

Column Datatype Description

SESSION_ID

NUMBER

Identifier for the session in which the fetch is executing. This table can be joined with V$SESSION to obtain the user name.

CURSOR_NAME

VARCHAR2(64)

Name assigned to the cursor

COMMAND

VARCHAR2(17)

Command that is actively fetching data from relational tables:

  • QUERY

  • FETCH

  • IMPORT

  • EXECUTE

  • UPDATE

  • SOLVE

  • CLEAR

  • LOAD CUBE

  • LOAD DIMENSION

  • DIMENSION COMPILE

STATUS

VARCHAR2(9)

Status of the current operation:

  • EXECUTING – Command has begun executing

  • FETCHING – Data is being fetched into the analytic workspace

  • FINISHED – Command has finished executing. This status appears very briefly before the record disappears from the table.

ROWS_PROCESSED

NUMBER

Number of rows already inserted, updated, or deleted

SEQ_NUMBER

NUMBER

Sequence number in the Cube Build log

SQL_ID

VARCHAR2(13)

SQL ID of the statement

TARGET

VARCHAR2(64)

Operated object name

TARGET_DESC

VARCHAR2(64)

A brief description of the operated object

START_TIME

DATE

Time the command started executing

LAST_UPDATE_TIME

DATE

Last updated time

ELAPSED_SECONDS

NUMBER

Number of seconds between START_TIME and LAST_UPDATE_TIME

SOFAR

NUMBER

Number of units so far

TOTALWORK

NUMBER

Total number of units

UNITS

VARCHAR2(6)

Units description:

  • ROWS

  • NODES

  • VALUES

MESSAGE

VARCHAR2(512)

Message for the user

USERNAME

VARCHAR2(32)

User name

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$AW_LONGOPS 官方解释,作用,如何使用详细说明