eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.V_$BACKUP_ASYNC_IO

Object Details

Object Name:	V_$BACKUP_ASYNC_IO
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
SID	NUMBER
SERIAL	NUMBER
USE_COUNT	NUMBER
RMAN_STATUS_RECID	NUMBER
RMAN_STATUS_STAMP	NUMBER
DEVICE_TYPE	VARCHAR2	(17)
TYPE	VARCHAR2	(9)
STATUS	VARCHAR2	(11)
FILENAME	VARCHAR2	(513)
SET_COUNT	NUMBER
SET_STAMP	NUMBER
BUFFER_SIZE	NUMBER
BUFFER_COUNT	NUMBER
TOTAL_BYTES	NUMBER
OPEN_TIME	DATE
CLOSE_TIME	DATE
ELAPSED_TIME	NUMBER
MAXOPENFILES	NUMBER
BYTES	NUMBER
EFFECTIVE_BYTES_PER_SECOND	NUMBER
IO_COUNT	NUMBER
READY	NUMBER
SHORT_WAITS	NUMBER
SHORT_WAIT_TIME_TOTAL	NUMBER
SHORT_WAIT_TIME_MAX	NUMBER
LONG_WAITS	NUMBER
LONG_WAIT_TIME_TOTAL	NUMBER
LONG_WAIT_TIME_MAX	NUMBER
CON_ID	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SID
,      SERIAL
,      USE_COUNT
,      RMAN_STATUS_RECID
,      RMAN_STATUS_STAMP
,      DEVICE_TYPE
,      TYPE
,      STATUS
,      FILENAME
,      SET_COUNT
,      SET_STAMP
,      BUFFER_SIZE
,      BUFFER_COUNT
,      TOTAL_BYTES
,      OPEN_TIME
,      CLOSE_TIME
,      ELAPSED_TIME
,      MAXOPENFILES
,      BYTES
,      EFFECTIVE_BYTES_PER_SECOND
,      IO_COUNT
,      READY
,      SHORT_WAITS
,      SHORT_WAIT_TIME_TOTAL
,      SHORT_WAIT_TIME_MAX
,      LONG_WAITS
,      LONG_WAIT_TIME_TOTAL
,      LONG_WAIT_TIME_MAX
,      CON_ID
FROM SYS.V_$BACKUP_ASYNC_IO;

Dependencies

[top of page]

SYS.V_$BACKUP_ASYNC_IO references the following:

SYS.V_$BACKUP_ASYNC_IO is referenced by following:

PUBLIC: V$BACKUP_ASYNC_IO