Ask about Tuning db buffer cache in oracle 9.2.0.4 64 bit on Unix
Hi all,
I have been read about tuning database buffer cache. There are some question that I need to help:
I used bellow script to select data from v$db_cache_advice
selectsize_for_estimate c1 ,buffers_for_estimate c2 ,estd_physical_read_factor c3,estd_physical_reads c4fromv$db_cache_advicewherename = 'DEFAULT'andblock_size = (SELECT value FROM V$PARAMETERWHERE name = 'db_block_size')andadvice_status = 'ON';
Result is:
Belong document, current size of db buffer cache is : 5120 MB ? Am I right ? And I need determine cache hit ratio , I'm going to use :c1 c2 c3 c4------- -------- --------- ----------------512 60872 11.3453 239467218111024 121744 8.6482 182539528781536 182616 5.9248 125056152512048 243488 4.0334 85134205652560 304360 2.6868 56709960163072 365232 1.8299 38623110203584 426104 1.3412 28308698734096 486976 1.2011 25351333134608 547848 1.0932 23073385775120 608720 1.0083 21281574995184 616329 1 21107135605632 669592 0.9422 19886236536144 730464 0.8914 18814829446656 791336 0.8518 17978525237168 852208 0.8208 17324416627680 913080 0.8039 16968475878192 973952 0.7894 16661017018704 1034824 0.7763 16384884589216 1095696 0.7637 16120440609728 1156568 0.7514 158596379610240 1217440 0.7392 1560325359
0