buffer命中率

一般这个命中率在95%左右时，数据库的性能较好。可以通过下面的语句来查询命中率： select 1-(sum(decode(name, 'physical reads', value, 0))/(sum(decode(name, 'db block gets', value, 0))+(sum(decode(name,  'consistent  gets',  value,  0)))))  "Buffer  HitRatio"
from v$sysstat;

下面就是oracle用户进程访问一个数据块的伪代码：

user_process_access_block(block)
{
if (search_lru(block))
{
g_cache_hit++;
return read_block_from_buffer_cache(block);
}
else
{
g_cache_missed++;
search_count = 1;
searched = FALSE;
set_lru_latch_context();
buffer_block = get_lru_from_lru();

do
{
if (block == buffer_block)
{
set_buffer_block(buffer_block, read_block_from_datafile(block);
move_buffer_block_to_mru(buffer_block);
searched = TRUE;
}
 
search_count++;
buffer_block = get_next_from_lru(buffer_block);
}while(!searched && search_count < BUFFER_SEARCH_THRESHOLD)
 
free_lru_latch_context();
 
if (!searched)
{
buffer_block = signal_dbw0_write_dirty_buffer();
set_buffer_block(buffer_block, read_block_from_datafile(block);
move_buffer_block_to_mru(buffer_block);
}

return buffer_block;
}
}

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/13805349/viewspace-233310/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13805349/viewspace-233310/