Oracle PL/SQL/System Tables Views/V db cache advice

Query v$db_cache_advice for factor,

   <source lang="sql">

SQL> col size_for_estimate format 9,999 heading SIZEMB SQL> col ESTD_PHYSICAL_READ_FACTOR format 99.99 heading EST_P_READ_FACTOR SQL> col ESTD_PHYSICAL_READS format 99,999 heading EST_P_READS SQL> col BUFFERS_FOR_ESTIMATE format 99,999 heading #BUFFERS SQL> SQL> select

 2    SIZE_FOR_ESTIMATE
 3   ,SIZE_FACTOR
 4   ,BUFFERS_FOR_ESTIMATE
 5   ,ESTD_PHYSICAL_READ_FACTOR
 6   ,ESTD_PHYSICAL_READS
 7   from v$db_cache_advice
 8  /

SIZEMB SIZE_FACTOR #BUFFERS EST_P_READ_FACTOR EST_P_READS

---

----------- -------- ----------------- -----------

    4           1      499                             0
    8           2      998                             0
   16       .0976    1,996              1.48      90,836
   32       .1951    3,992              1.36      83,188
   48       .2927    5,988              1.31      80,414
   64       .3902    7,984              1.28      78,687
   80       .4878    9,980              1.27      77,977
   96       .5854   11,976              1.26      77,148
  112       .6829   13,972              1.20      73,447
  128       .7805   15,968              1.19      72,746
  144        .878   17,964              1.01      61,880
  160       .9756   19,960              1.00      61,386
  164           1   20,459              1.00      61,347
  176      1.0732   21,956              1.00      61,189
  192      1.1707   23,952               .99      60,893
  208      1.2683   25,948               .97      59,521
  224      1.3659   27,944               .92      56,728
  240      1.4634   29,940               .89      54,547
  256       1.561   31,936               .86      52,938
  272      1.6585   33,932               .81      49,405
  288      1.7561   35,928               .80      49,376
  304      1.8537   37,924               .80      49,336
  320      1.9512   39,920               .75      46,040

23 rows selected. SQL>

 </source>