有位大侠告诉我:If the buffer cache is too smalll for your system, you will see "free buffer waits" in the v$system_event table. And that is the better place to check.
我查到了数据如下,可我不知道free buffer waits这个值是什么时候才能判断buffer cache够用不够用.能具体说一下吗?比如我的这个值为:
EVENT
TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT TIME_WAITED_MICRO
----------------- ----------- -------------- ----------- ------------ -----------------
free buffer waits 16741
15884 1639155 981.6392E+10
我的SGA为640MB,buffer cache约有520MB,数据量有一个亿条左右,请问我的的buffer cache够不够?差多少?加多少合适呢?谢谢