Oracle教程

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

本站中文解释

V$DELETED_OBJECT视图可以查看在当前实例中被删除，但尚未完成清除的对象信息，表示它们仍在datafile中存在着。

V$DELETED_OBJECT的可查看的信息有：

OBJ# : 删除的对象的编号；

TYPE : 删除的对象的类型；

NAME：删除的对象的名称；

OWNER： 删除的对象的拥有者；

ASHINGTON： 删除的对象的以8位的数字形式表示的时间戳下的表格状态；

CREATED： 创建的对象的状态；

DROPPED： 删除的对象的状态；

SPACE： 删除的对象在数据文件中占用的空间；

TS#： 删除的对象所属的文件号；

RLM： 删除的对象的Free-list上的范围；

EXTENTS： 删除的对象向后扩展出多少段；

SEG#： 删除的对象在datafile中直接分配给它的物理地址。

如何使用：

我们可以使用SQL查询语句来访问V$DELETED_OBJECT这个视图。例如，以下语句可用于查看当前实例中被删除的所有表：

SELECT * FROM V$DELETED_OBJECT WHERE OBJECT_TYPE = ‘TABLE’;

官方英文解释

V$DELETED_OBJECT displays information about deleted archived logs, data file copies and backup pieces from the control file.

The only purpose of this view is to optimize the recovery catalog resync operation. When an archived log, data file copy, or backup piece is deleted, the corresponding record is marked deleted.

Column Datatype Description

RECID

NUMBER

Deleted object record ID

STAMP

NUMBER

Deleted object record stamp

TYPE

VARCHAR2(26)

Identifies the type of deleted object:

  • ARCHIVED LOG

  • BACKUP PIECE

  • DATAFILE COPY

  • PROXY COPY

  • BACKUP PIECE AVAILABLE

  • BACKUP PIECE EXPIRED

  • PROXY COPY AVAILABLE

  • PROXY COPY EXPIRED

  • BACKUP PIECE UNAVAILABLE

  • PROXY COPY UNAVAILABLE

  • DATAFILE COPY AVAILABLE

  • DATAFILE COPY EXPIRED

  • DATAFILE COPY UNAVAILABLE

  • ARCHIVED LOG AVAILABLE

  • ARCHIVED LOG EXPIRED

  • ARCHIVED LOG UNAVAILABLE

  • BACKUP SET KEEP OPTIONS

  • BACKUP SET KEEP UNTIL

  • PROXY COPY KEEP OPTIONS

  • PROXY COPY KEEP UNTIL

  • DATAFILE COPY KEEP OPTIONS

  • DATAFILE COPY KEEP UNTIL

  • DATAFILE RENAME ON RESTORE

OBJECT_RECID

NUMBER

Record ID of the deleted object

OBJECT_STAMP

NUMBER

Record timestamp of the deleted object

OBJECT_DATA

NUMBER

Displays additional internal information related to this deleted object. For internal Oracle use only.

SET_STAMP

NUMBER

Set stamp of the deleted object

SET_COUNT

NUMBER

Set count of the deleted object

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$DELETED_OBJECT 官方解释，作用，如何使用详细说明
分享到：

相关推荐