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

Object Details

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

[View Source]

Columns

Name	Datatype	Length
INST_ID	NUMBER
SESSION_ID	NUMBER
CON_ID	NUMBER
TRANSLATE_ID	NUMBER
SQL_ID	VARCHAR2	(13)
SQL_EXEC_START	DATE
SQL_EXEC_ID	NUMBER
PROCESS	VARCHAR2	(64)
STATE	VARCHAR2	(8)
TYPE	VARCHAR2	(8)
WIDTH	NUMBER
KEY_DATA_TYPE	VARCHAR2	(13)
JOIN_COLUMN_COUNT	NUMBER
JOIN_KEY_COUNT	NUMBER
DUP_JOIN_KEY_COUNT	NUMBER
MIN_JOIN_KEY	NUMBER
MAX_JOIN_KEY	NUMBER
GROUP_KEY_COUNT	NUMBER
FILTERED	NUMBER
PROBED	NUMBER
ACTIVE	NUMBER
DISABLED	NUMBER
MEMORY_ALLOCATED	NUMBER
JOIN_STRUCTURE_SIZE	NUMBER
FACT_OWNER	VARCHAR2	(30)
FACT_NAME	VARCHAR2	(30)
DIMENSION_OWNER	VARCHAR2	(30)
DIMENSION_NAME	VARCHAR2	(30)

Query Text

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


SELECT INST_ID
,      SESSION_ID
,      CON_ID
,      TRANSLATE_ID
,      SQL_ID
,      SQL_EXEC_START
,      SQL_EXEC_ID
,      PROCESS
,      STATE
,      TYPE
,      WIDTH
,      KEY_DATA_TYPE
,      JOIN_COLUMN_COUNT
,      JOIN_KEY_COUNT
,      DUP_JOIN_KEY_COUNT
,      MIN_JOIN_KEY
,      MAX_JOIN_KEY
,      GROUP_KEY_COUNT
,      FILTERED
,      PROBED
,      ACTIVE
,      DISABLED
,      MEMORY_ALLOCATED
,      JOIN_STRUCTURE_SIZE
,      FACT_OWNER
,      FACT_NAME
,      DIMENSION_OWNER
,      DIMENSION_NAME
FROM SYS.GV_$KEY_VECTOR;

Dependencies

[top of page]

SYS.GV_$KEY_VECTOR references the following:

SYS.GV_$KEY_VECTOR is referenced by following:

PUBLIC: GV$KEY_VECTOR