v$rowcache vs. v$librarycache

From: <kal121_at_yahoo.com>
Date: Wed, 05 May 1999 19:37:05 GMT
Message-ID: <7gq6l1$44c$1@nnrp1.deja.com>

Can somebody please tell what the difference is between the v$rowcache and the v$librarycache?

Also, what is this output really saying?

SQL> select (sum(gets - getmisses - usage - fixed)) / sum(gets) "Row Cache"   2 from v$rowcache;

Row Cache

---

.65192218

My free memory seems more than adequate!

SQL> select * from v$sgastat where name = 'free memory';

POOL        NAME                           BYTES
----------- -------------------------- ---------
shared pool free memory                 95424432

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own    

Received on Wed May 05 1999 - 14:37:05 CDT