Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: v$rowcache DPT
FIXED - count of objects that must always be left in cache
USAGE - size (in items) of cache which have been used
Gocha Mchedlishvili wrote ...
>Does anybody know what are the descriptions of following two fields in
>v$rowcache:
>USAGE and FIXED
>
>In Oracle documenatation they say USAGE is "valid data in cache" and
FIXED
>is "fixed data in cache", but don't say what kind of data it is.
>
>They also give formula for calculating the row cache hit ratio
>it's
>sum(gets-getmisses-usage-fixed)/sum(gets)
>
>Could somebody explain this please?
>
>Thank you
>
>Gocha
>
>
Received on Wed Feb 10 1999 - 13:47:34 CST