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

本站中文解释

ETS

Oracle视图DBA_HIST_PERSISTENT_SUBSETS对于对内存数据存储技术的定义包括方面来进行查看:

(1)每个内存中的持久子集的标识符,id,创建时间,最新的同步检查点的处理;

(2)每个持久子集的大小,实体行数,哈希键列数,哈希总体值,实体行版本块数,以及索引行版本块数;

(3)每个持久子集的使用限制,如内存使用限制,字符限制,varchar2限制,压缩模式等。

使用Oracle视图DBA_HIST_PERSISTENT_SUBSETS来查看内存存储技术中持久子集的相关信息,可以把它用在优化内存使用限制,调整持久子集的字符数量,减少不必要的类型转换,以及使用压缩模式的更有效的内存存储等方面。

官方英文解释

DBA_HIST_PERSISTENT_SUBS displays Oracle Database AQ persistent queue subscribers historical statistics information.

This view contains snapshots of V$PERSISTENT_SUBSCRIBERS.

Column Datatype NULL Description

SNAP_ID

NUMBER

NOT NULL

Unique snapshot ID

DBID

NUMBER

NOT NULL

Database ID for the snapshot

INSTANCE_NUMBER

NUMBER

NOT NULL

Instance number for the snapshot

QUEUE_SCHEMA

VARCHAR2(128)

NOT NULL

Owner of the queue

QUEUE_NAME

VARCHAR2(128)

NOT NULL

Name of the queue

SUBSCRIBER_ID

NUMBER

NOT NULL

Internal subscriber number

SUBSCRIBER_NAME

VARCHAR2(128)

Name of the subscriber

SUBSCRIBER_ADDRESS

VARCHAR2(1024)

Address of the subscribing agent

SUBSCRIBER_TYPE

VARCHAR2(128)

Type of the subscriber:

  • PROXY – Propagation subscriber

  • SUBSCRIBER – Normal subscriber

  • RECIPIENT – Recipient

FIRST_ACTIVITY_TIME

TIMESTAMP(6)

First subscriber activity time since database startup

ENQUEUED_MSGS

NUMBER

Number of messages enqueued since FIRST_ACTIVITY_TIME

DEQUEUED_MSGS

NUMBER

Number of messages dequeued since FIRST_ACTIVITY_TIME

AVG_MSG_AGE

NUMBER

Average age of messages in the queue

BROWSED_MSGS

NUMBER

Number of messages that have been browsed

EXPIRED_MSGS

NUMBER

Number of messages expired since FIRST_ACTIVITY_TIME

DEQUEUED_MSG_LATENCY

NUMBER

Last dequeued message latency (in seconds)

LAST_ENQUEUE_TIME

TIMESTAMP(6)

Timestamp of the last enqueued message

LAST_DEQUEUE_TIME

TIMESTAMP(6)

Timestamp of the last dequeued message

ELAPSED_DEQUEUE_TIME

NUMBER

Total time spent in dequeue (in hundredths of a second)

DEQUEUE_CPU_TIME

NUMBER

Total CPU time for dequeue (in hundredths of a second)

DEQUEUE_TRANSACTIONS

NUMBER

Number of dequeue transactions

EXECUTION_COUNT

NUMBER

Number of executions of the dequeue index cursor

CON_DBID

NUMBER

The database ID of the PDB for the sampled session

CON_ID

NUMBER

The ID of the container that CON_DBID identifies. 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

See Also:

“V$PERSISTENT_SUBSCRIBERS”


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