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 last published in March 2007

Dig Deeper on Oracle database design and architecture

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

Join the conversation

1 comment

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

good info to start googling hash value ..
Cancel

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close