v$rowcache DPT

From: Gocha Mchedlishvili <gocham_at_mci2000.com>
Date: Wed, 10 Feb 1999 04:03:39 GMT
Message-ID: <vy7w2.226$mB5.9227@news.cwix.com>

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 Tue Feb 09 1999 - 22:03:39 CST