Oracle教程 2023-02-27

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

、v$archived_log

Oracle视图包括V$ARCHIVE_PROCESSES、v$archived_log二者，主要用于查看归档文件，如果有归档进程正在运行，就使用V$ARCHIVE_PROCESSES视图查看；如果要查看归档文件信息，就使用v$archived_log视图查看。

使用方法：

1、查看归档进程信息：SELECT * FROM v$archive_processes;

2、查看归档文件信息：SELECT * FROM v$archived_log;

V$ARCHIVE_PROCESSES displays the state of the various ARCH processes for the instance.

Column	Datatype	Description
`PROCESS`	`NUMBER`	Identifier for the ARCH process for the instance, numbered from 0-9
`STATUS`	`VARCHAR2(10)`	Status of the ARCH process, displayed as a keyword. Possible values are: `STOPPED`, `SCHEDULED`, `STARTING`, `ACTIVE`, `STOPPING`, and `TERMINATED`.
`LOG_SEQUENCE`	`NUMBER`	This is the online redo log sequence number currently being archived, if `STATE`=”`BUSY`”
`STATE`	`VARCHAR2(4)`	This is the current state of the ARCH process, displayed as a keyword. Possible keywords are `IDLE` or `BUSY`.
`ROLES`	`VARCHAR2(36)`	The list of roles assigned to the archive process. The roles include: `HEART_BEAT`, `NO_FAL`, `NO_SRL`, `CLEAR_LOGS`
`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

分享到：