[Home] [Help] [Dependency Information]
Object Name: | V_$KEY_VECTOR |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
Cut, paste (and edit) the following text to query this object:
SELECT 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.V_$KEY_VECTOR;
|
|
|