DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: v$db_cache_advice

Threaded View

  1. #1
    Join Date
    Jul 2001
    Posts
    108

    v$db_cache_advice

    Hello,

    I could not able to understand how to the read the results from the view v$db_cache_advice.
    Here is the output and please let me know how to find the proper buffer_cache value from the following output?

    I have modified the column headings accordingly:v$db_cache_advice

    SizeEstimate SizeFactor BuffersEstimate Estd_PhysicalRead_factor Estd_PhysicalReads

    ------------ ------------- ---------------- ------------------------ ------------------
    48 .1 5955 1.3764 32804
    96 .2 11910 1.2167 28999
    144 .3 17865 1.1849 28240
    192 .4 23820 1.0966 26137
    240 .5 29775 1 23834
    288 .6 35730 1 23834
    336 .7 41685 1 23834
    384 .8 47640 1 23834
    432 .9 53595 1 23834
    480 1.0 59550 1 23834
    528 1.1 65505 1 23834
    576 1.2 71460 1 23834
    624 1.3 77415 1 23834
    672 1.4 83370 1 23834
    720 1.5 89325 1 23834
    768 1.6 95280 1 23834
    816 1.7 101235 1 23834
    864 1.8 107190 1 23834
    912 1.9 113145 1 23834
    960 2.0 119100 1 23834

    Thanks,
    Nikee
    Last edited by Nikee; 11-26-2003 at 04:47 PM.
    -Nikee

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width