Keyword: HASH
jump to Columns back to indexTables
| Table Name | Description |
|---|---|
| ALL_CLUSTER_HASH_EXPRESSIONS | Hash functions for all accessible clusters |
| DBA_CLUSTER_HASH_EXPRESSIONS | Hash functions for all clusters |
| USER_CLUSTER_HASH_EXPRESSIONS | Hash functions for the user's hash clusters |
Columns
| Column Name | Description |
|---|---|
| ACTION_HASH (V$SQL) | |
| ACTION_HASH (GV$SQL) | |
| ACTION_HASH (GV$SESSION) | |
| ACTION_HASH (V$SQLAREA) | |
| ACTION_HASH (V$SESSION) | |
| ACTION_HASH (GV$SQLAREA) | |
| CTYPE_HASHCODE (ALL_REPCOLUMN) | Type hashcode of a column of TYPE |
| CTYPE_HASHCODE (USER_REPCOLUMN) | Type hashcode of a column of TYPE |
| CTYPE_HASHCODE (DBA_REPCOLUMN) | Type hashcode of a column of TYPE |
| FROM_HASH (V$OBJECT_DEPENDENCY) | |
| FROM_HASH (GV$OBJECT_DEPENDENCY) | |
| HASH (GV$ROWCACHE_PARENT) | |
| HASH (GV$ROWCACHE_SUBORDINATE) | |
| HASH (V$ROWCACHE_PARENT) | |
| HASH (V$ROWCACHE_SUBORDINATE) | |
| HASHCODE (USER_TYPE_VERSIONS) | Hashcode of the type |
| HASHCODE (DBA_TYPE_VERSIONS) | Hashcode of the type |
| HASHCODE (ALL_TYPE_VERSIONS) | Hashcode of the type |
| HASHKEYS (DBA_CLUSTERS) | If a hash cluster, the number of hash keys (hash buckets) |
| HASHKEYS (CLU) | If a hash cluster, the number of hash keys (hash buckets) |
| HASHKEYS (ALL_CLUSTERS) | If a hash cluster, the number of hash keys (hash buckets) |
| HASHKEYS (USER_CLUSTERS) | If a hash cluster, the number of hash keys (hash buckets) |
| HASH_EXPRESSION (USER_CLUSTER_HASH_EXPRESSIONS) | Text of hash function of cluster |
| HASH_EXPRESSION (DBA_CLUSTER_HASH_EXPRESSIONS) | Text of hash function of cluster |
| HASH_EXPRESSION (ALL_CLUSTER_HASH_EXPRESSIONS) | Text of hash function of cluster |
| HASH_VALUE (GV$OPEN_CURSOR) | |
| HASH_VALUE (GV$SQLTEXT_WITH_NEWLINES) | |
| HASH_VALUE (V$SQLTEXT) | |
| HASH_VALUE (GV$SQL_PLAN_STATISTICS_ALL) | |
| HASH_VALUE (GV$SQLAREA) | |
| HASH_VALUE (GV$SQL_PLAN) | |
| HASH_VALUE (V$SQL_PLAN_STATISTICS) | |
| HASH_VALUE (V$SQLAREA) | |
| HASH_VALUE (V$OPEN_CURSOR) | |
| HASH_VALUE (V$SQL_WORKAREA) | |
| HASH_VALUE (GV$SQL_REDIRECTION) | |
| HASH_VALUE (V$SQL_PLAN) | |
| HASH_VALUE (V$SQL_PLAN_STATISTICS_ALL) | |
| HASH_VALUE (GV$SQLTEXT) | |
| HASH_VALUE (GV$SQL_WORKAREA) | |
| HASH_VALUE (V$SQL_REDIRECTION) | |
| HASH_VALUE (GV$SQL_PLAN_STATISTICS) | |
| HASH_VALUE (V$SQL_SHARED_MEMORY) | |
| HASH_VALUE (GV$SQL_SHARED_MEMORY) | |
| HASH_VALUE (V$SQL) | |
| HASH_VALUE (V$SQLTEXT_WITH_NEWLINES) | |
| HASH_VALUE (GV$SQL) | |
| HASH_VALUE (V$SQLXS) | |
| LITERAL_HASH_VALUE (V$SQL) | |
| LITERAL_HASH_VALUE (GV$SQL) | |
| MODULE_HASH (GV$SQL) | |
| MODULE_HASH (V$SESSION) | |
| MODULE_HASH (V$SQLAREA) | |
| MODULE_HASH (GV$SESSION) | |
| MODULE_HASH (GV$SQLAREA) | |
| MODULE_HASH (V$SQL) | |
| PLAN_HASH_VALUE (GV$SQL) | |
| PLAN_HASH_VALUE (V$SQL) | |
| PREV_HASH_VALUE (GV$SESSION) | |
| PREV_HASH_VALUE (V$SESSION) | |
| SQL_HASH (GV$VPD_POLICY) | |
| SQL_HASH (V$VPD_POLICY) | |
| SQL_HASH_VALUE (GV$SESSION) | |
| SQL_HASH_VALUE (V$SESSION_LONGOPS) | |
| SQL_HASH_VALUE (GV$SESSION_LONGOPS) | |
| SQL_HASH_VALUE (V$SESSION) | |
| TO_HASH (GV$OBJECT_DEPENDENCY) | |
| TO_HASH (V$OBJECT_DEPENDENCY) | |
| TYPE_HASHCODE (ALL_REPFLAVOR_COLUMNS) | Type hashcode of a column of TYPE |
| TYPE_HASHCODE (USER_REPFLAVOR_COLUMNS) | Type hashcode of a column of TYPE |
| TYPE_HASHCODE (DBA_REPFLAVOR_COLUMNS) | Type hashcode of a column of TYPE |