Q

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.

This was first published in March 2007

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

1 comment

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close