Query v$db_cache_advice for factor, : V_db_cache_advice « System Tables Views « Oracle PL / SQL






Query v$db_cache_advice for factor,

 

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>

   
  








Related examples in the same category