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.GV_$RESUMABLE

Object Details

Object Name:	GV_$RESUMABLE
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
INST_ID	NUMBER
ADDR	RAW	(8)
SID	NUMBER
ENABLED	VARCHAR2	(3)
STATUS	VARCHAR2	(9)
TIMEOUT	NUMBER
SUSPEND_TIME	VARCHAR2	(20)
RESUME_TIME	VARCHAR2	(20)
NAME	VARCHAR2	(4000)
ERROR_NUMBER	NUMBER
ERROR_PARAMETER1	VARCHAR2	(80)
ERROR_PARAMETER2	VARCHAR2	(80)
ERROR_PARAMETER3	VARCHAR2	(80)
ERROR_PARAMETER4	VARCHAR2	(80)
ERROR_PARAMETER5	VARCHAR2	(80)
ERROR_MSG	VARCHAR2	(4000)
CON_ID	NUMBER

Query Text

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


SELECT INST_ID
,      ADDR
,      SID
,      ENABLED
,      STATUS
,      TIMEOUT
,      SUSPEND_TIME
,      RESUME_TIME
,      NAME
,      ERROR_NUMBER
,      ERROR_PARAMETER1
,      ERROR_PARAMETER2
,      ERROR_PARAMETER3
,      ERROR_PARAMETER4
,      ERROR_PARAMETER5
,      ERROR_MSG
,      CON_ID
FROM SYS.GV_$RESUMABLE;

Dependencies

[top of page]

SYS.GV_$RESUMABLE references the following:

SYS.GV_$RESUMABLE is referenced by following:

PUBLIC: GV$RESUMABLE