select
size_for_estimate c1,
buffers_for_estimate c2,
estd_physical_read_factor c3,
estd_physical_reads c4
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'
|
C1
|
C2
|
C3
|
C4
|
|
16
|
1012
|
1.6766
|
3937
|
|
32
|
2024
|
1.2043
|
2828
|
|
48
|
3036
|
1.0809
|
2538
|
|
64
|
4048
|
1
|
2348
|
|
80
|
5060
|
1
|
2348
|
|
96
|
6072
|
1
|
2348
|
|
112
|
7084
|
1
|
2348
|
|
128
|
8096
|
1
|
2348
|
|
144
|
9108
|
1
|
2348
|
|
160
|
10120
|
1
|
2348
|
|
176
|
11132
|
1
|
2348
|
|
192
|
12144
|
1
|
2348
|
|
200
|
12650
|
1
|
2348
|
|
208
|
13156
|
1
|
2348
|
|
224
|
14168
|
1
|
2348
|
|
240
|
15180
|
1
|
2348
|
|
256
|
16192
|
1
|
2348
|
|
272
|
17204
|
1
|
2348
|
|
288
|
18216
|
1
|
2348
|
|
304
|
19228
|
1
|
2348
|
|
320
|
20240
|
1
|
2348
|