V$DELETED_OBJECT

V$DELETED_OBJECT displays information about deleted archived logs, datafile 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, datafile 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

Note:

1. There is a bug in 10.2.0.4 and 11.1.0.6 that RMAN resync takes long time when v$deleted_object contains too many rows. The bug will be resolved in 10.2.0.5 (server patch set), 11.1.0.7 (server patch set) and 11.2.

Oracle data dictionary views

Oracle dynamic performance views

V$DBFILE

V$DBFILE displays all datafiles making up the database. This view is retained for historical compatibility. Use of V$DATAFILE is recommended instead.

Column	Datatype	Description
FILE#	NUMBER	File identifier
NAME	VARCHAR2(513)	Name of the file

Note:

SQL> select * from V$DBFILE; FILE# NAME ---------- ------------------------------------------------------------ 1 /u02/oracle_data/mydb/system01.dbf 2 /u02/oracle_data/mydb/undotbs01.dbf 3 /u02/oracle_data/mydb/undotbs02.dbf 4 /u02/oracle_data/mydb/cwmlite01.dbf 5 /u02/oracle_data/mydb/drsys01.dbf 6 /u02/oracle_data/mydb/odm01.dbf 7 /u02/oracle_data/mydb/tools01.dbf 8 /u02/oracle_data/mydb/users01.dbf 9 /u02/oracle_data/mydb/xdb01.dbf 10 /u02/oracle_data/mydb/prod_anal01.dbf 11 /u02/oracle_data/mydb/atlas01.dbf

Oracle data dictionary views

Oracle dynamic performance views