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_$INSTANCE

Object Details

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

[View Source]

Columns

Name	Datatype	Length
INSTANCE_NUMBER	NUMBER
INSTANCE_NAME	VARCHAR2	(16)
HOST_NAME	VARCHAR2	(64)
VERSION	VARCHAR2	(17)
STARTUP_TIME	DATE
STATUS	VARCHAR2	(12)
PARALLEL	VARCHAR2	(3)
THREAD#	NUMBER
ARCHIVER	VARCHAR2	(7)
LOG_SWITCH_WAIT	VARCHAR2	(15)
LOGINS	VARCHAR2	(10)
SHUTDOWN_PENDING	VARCHAR2	(3)
DATABASE_STATUS	VARCHAR2	(17)
INSTANCE_ROLE	VARCHAR2	(18)
ACTIVE_STATE	VARCHAR2	(9)
BLOCKED	VARCHAR2	(3)
CON_ID	NUMBER
INSTANCE_MODE	VARCHAR2	(11)
EDITION	VARCHAR2	(7)
FAMILY	VARCHAR2	(80)

Query Text

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


SELECT INSTANCE_NUMBER
,      INSTANCE_NAME
,      HOST_NAME
,      VERSION
,      STARTUP_TIME
,      STATUS
,      PARALLEL
,      THREAD#
,      ARCHIVER
,      LOG_SWITCH_WAIT
,      LOGINS
,      SHUTDOWN_PENDING
,      DATABASE_STATUS
,      INSTANCE_ROLE
,      ACTIVE_STATE
,      BLOCKED
,      CON_ID
,      INSTANCE_MODE
,      EDITION
,      FAMILY
FROM SYS.V_$INSTANCE;

Dependencies

[top of page]

SYS.V_$INSTANCE references the following:

SYS.V_$INSTANCE is referenced by following:

DBSNMP: BSLN - show dependent code; BSLN_INTERNAL - show dependent code; BSLN_INTERNAL - show dependent code
PUBLIC: V$INSTANCE