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

本站中文解释

异步计算在执行的视图

Oracle视图是一种存储SQL查询的数据库对象,可以使用SELECT进行快速访问,实现视图从存储在任何范围内的表或从中检索的数据的视图。

V$AW_OLAP视图用于报告正在处理的排队异步计算作业状态。它可以提供非常有用的信息,它提供异步计算正在执行的一般信息,如实例,耗时,持久性,优先级,以及异步计算作业的状态。

使用V$AW_OLAP视图,可以查看正在执行的异步计算作业的状态,以及相关信息,如运行时间或作业类型等,以便了解它们是如何正在被处理的。

例如,要查看所有正在执行的异步计算任务,可以使用以下SQL查询:SELECT * FROM V$AW_OLAP WHERE STATUS=’RUNNING’。此查询将返回正在执行的所有异步计算任务的状态、时间等信息。

官方英文解释

V$AW_OLAP provides a record of active sessions and their use with analytic workspaces.

A row is generated whenever an analytic workspace is created or attached. The first row for a session is created when the first command is issued. It identifies the SYS.EXPRESS workspace, which is attached automatically to each session. Rows related to a particular analytic workspace are deleted when the workspace is detached from the session or the session ends.

Column Datatype Description

SESSION_ID

NUMBER

A unique numeric identifier for a session

AW_NUMBER

NUMBER

A unique numeric identifier for an analytic workspace. To get the name of the analytic workspace, join this column to the AW_NUMBER column of the USER_AWS view or to the AWSEQ# column of the AW$ table.

ATTACH_MODE

VARCHAR2(10)

READ ONLY or READ WRITE

GENERATION

NUMBER

The generation of an analytic workspace. Each UPDATE creates a new generation. Sessions attaching the same workspace between UPDATE commands share the same generation.

TEMP_SPACE_PAGES

NUMBER

The number of pages stored in temporary segments for the analytic workspace.

TEMP_SPACE_READS

NUMBER

The number of times data has been read from a temporary segment and not from the page pool.

LOB_READS

NUMBER

The number of times data has been read from the table where the analytic workspace is stored (the permanent LOB).

POOL_CHANGED_PAGES

NUMBER

The number of pages in the page pool that have been modified in this analytic workspace.

POOL_UNCHANGED_PAGES

NUMBER

The number of pages in the page pool that have not been modified in this analytic workspace.

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