The Buffer cache modification
Hello ,
We have two identical environment test and prod but the result of the request below does not give the same detail, how the changed ?
Please find UAT and PRODUCTION details below
select
size_for_estimate,
buffers_for_estimate,
estd_physical_read_factor,
estd_physical_reads
from
v$db_cache_advice
where
name = 'DEFAULT'
and
block_size = (SELECT value FROM V$PARAMETER
WHERE name = 'db_block_size')
and
advice_status = 'ON'
UAT
80 9835 4,2524 575794595905
160 19670 3,9429 533881783421
240 29505 2,6116 353618444155
320 39340 1,2613 170785388849
400 49175 1,114 150835013897
480 59010 1,0738 145391304940
560 68845 1,0545 142779115819
640 78680 1,0388 140653973823
720 88515 1,0275 139121176121
800 98350 1 135403299792
880 108185 0,9863 133554107576
960 118020 0,9585 129781421897
1040 127855 0,9115 123414279254
1120 137690 0,8625 116791991640
1200 147525 0,8282 112139805774
1280 157360 0,8212 111195736948
1360 167195 0,8186 110840336193
1440 177030 0,8159 110470660267
1520 186865 0,8132 110109042393
1600 196700 0,8106 109751160941
PROD
16 1967 1,0314 12874496
32 3934 1,0108 12617171
48 5901 1 12482583
64 7868 ,9923 12386626
80 9835 ,9892 12347592
96 11802 ,9881 12333937