Q
Problem solve Get help with specific problems with your technologies, process and projects.

What is a hash value?

What is a hash value in Oracle?

What is a hash value in Oracle? What is the significance of it?
A "hash value" is not particular to Oracle. Rather, it is a computer science concept. I will briefly explain this concept, but you can read more about hash values at Wikipedia.

Data is often stored in an array, which is a set of consecutive chunks of memory. Oracle's caches are often predefined...

arrays. The array is not big enough to hold everything. So Oracle takes that thing and applies some mathematical function to determine which chunk of memory, or the cell in the array, will hold the thing. This mathematical function is called a "hash function." This function returns an index to the array, which is commonly called the hash value.

Dig Deeper on Oracle database design and architecture

Join the conversation

1 comment

Send me notifications when other members comment.

Please create a username to comment.

good info to start googling hash value ..
Cancel

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close