 |
 |
 |
|
| Given the number of hash buckets, the file number, and the block number, this simple perl script will generate the hash value, hash the value, and assign it to a hash bucket. This is a great way to learn about how Oracle uses hashing to check if a block is in the Oracle buffer cache as well as issues related to the cache buffer chain structure, latching, and concurrency issues. This is the script presented in OraPub's course, Oracle Performance Firefighting. |
|
|
|
|
|
|
