[Home] [Help] [Dependency Information]
Object Name: | OL$HINTS |
---|---|
Object Type: | TABLE |
Owner: | SYSTEM |
Subobject Name: | |
Status: | VALID |
SYSTEM.OL$HINTS is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OL$HNT_NUM | NORMAL | UNIQUE |
OL_NAME
HINT# | |
SYS_IL0000364508C00021$$ | LOB | UNIQUE | SYSTEM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OL_NAME | VARCHAR2 | (128) | ||
HINT# | NUMBER | |||
CATEGORY | VARCHAR2 | (128) | ||
HINT_TYPE | NUMBER | |||
HINT_TEXT | VARCHAR2 | (512) | ||
STAGE# | NUMBER | |||
NODE# | NUMBER | |||
TABLE_NAME | VARCHAR2 | (128) | ||
TABLE_TIN | NUMBER | |||
TABLE_POS | NUMBER | |||
REF_ID | NUMBER | |||
USER_TABLE_NAME | VARCHAR2 | (260) | ||
COST | FLOAT | (22) | ||
CARDINALITY | FLOAT | (22) | ||
BYTES | FLOAT | (22) | ||
HINT_TEXTOFF | NUMBER | |||
HINT_TEXTLEN | NUMBER | |||
JOIN_PRED | VARCHAR2 | (2000) | ||
SPARE1 | NUMBER | |||
SPARE2 | NUMBER | |||
HINT_STRING | CLOB | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT OL_NAME
, HINT#
, CATEGORY
, HINT_TYPE
, HINT_TEXT
, STAGE#
, NODE#
, TABLE_NAME
, TABLE_TIN
, TABLE_POS
, REF_ID
, USER_TABLE_NAME
, COST
, CARDINALITY
, BYTES
, HINT_TEXTOFF
, HINT_TEXTLEN
, JOIN_PRED
, SPARE1
, SPARE2
, HINT_STRING
FROM SYSTEM.OL$HINTS;
SYSTEM.OL$HINTS does not reference any database object
SYSTEM.OL$HINTS is referenced by following:
|
|
|