Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> db buffer cache advisory clarification
Can anyone let me know why the advisory is saying i can so drastically
reduce my PIO's by reducing my db_cache_size?
This was from a statspack 15 minute snap on 9.2.0.3
Buffer Pool Advisory for DB: MERLIN Instance: MERLIN End Snap: 24
-> Only rows with estimated physical reads >0 are displayed
-> ordered by Block Size, Buffers For Estimate
Size for Size Buffers for Est Physical Estimated P Estimate (M) Factr Estimate Read Factor Physical Reads --- ------------ ----- ------------ ------------- ------------------ D 16 .3 1,985 0.06 76,733,864 D 32 .5 3,970 0.03 42,372,246 D 48 .8 5,955 0.01 14,388,875 D 64 1.0 7,940 1.00 1,235,406,218 D 80 1.3 9,925 0.99 1,218,140,869 D 96 1.5 11,910 0.97 1,202,045,787 D 112 1.8 13,895 0.96 1,186,037,878 D 128 2.0 15,880 0.95 1,170,539,124 D 144 2.3 17,865 0.93 1,153,082,843 D 160 2.5 19,850 0.92 1,136,840,124 D 176 2.8 21,835 0.91 1,120,406,916 D 192 3.0 23,820 0.89 1,105,315,871 D 208 3.3 25,805 0.88 1,091,342,049 D 224 3.5 27,790 0.87 1,078,433,638 D 240 3.8 29,775 0.86 1,066,281,869 D 256 4.0 31,760 0.85 1,055,056,082 D 272 4.3 33,745 0.85 1,044,234,271 D 288 4.5 35,730 0.84 1,032,099,896 D 304 4.8 37,715 0.82 1,014,564,963 D 320 5.0 39,700 0.79 973,654,538 ---------------------------------------------------------Received on Thu Mar 23 2006 - 11:41:22 CST