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'

Connect time(ms): 63

Connected to jdbc:oracle:thin:@LarrySERVER:1521:wind
Driver       Oracle JDBC driver
Version      8.1.7.1.0

Query time & data xfer(ms): 62

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

