DBA_CLUSTER_HASH_EXPRESSIONS view tips

Oracle Tips by Burleson Consulting

DBA_CLUSTER_HASH_EXPRESSIONS

<< Return to the index

Oracle 11g makes the following comments about the DBA_CLUSTER_HASH_EXPRESSIONS table: "Hash functions for all clusters"

Related notes on DBA_CLUSTER_HASH_EXPRESSIONS:

Column description of the DBA_CLUSTER_HASH_EXPRESSIONS view:

OWNER

Description of DBA_CLUSTER_HASH_EXPRESSIONS.OWNER: "Name of owner of cluster"

CLUSTER_NAME

Description of DBA_CLUSTER_HASH_EXPRESSIONS.CLUSTER_NAME: "Text of hash function of the cluster"

HASH_EXPRESSION

Description of DBA_CLUSTER_HASH_EXPRESSIONS.HASH_EXPRESSION: "Text of hash function of cluster"

DBA_CLUSTER_HASH_EXPRESSIONS View Source

Oracle 11g's data dictionary defines the DBA_CLUSTER_HASH_EXPRESSIONS view using the following source query:

select us.name, o.name, c.condition
from sys.cdef$ c, sys.user$ us, sys.obj$ o
where c.type# = 8
and c.obj# = o.obj#
and us.user# = o.owner#

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.
You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books