[Home] [Help] [Dependency Information]
Object Name: | V_$INSTANCE |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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;
|
|
|