Oracle教程 2023-03-31

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

本站中文解释

官方英文解释

相关推荐