Hi
Can someone explain me difference between GETS and PINS columns in V$librarycache.
I know definitions:
GETS: the number of lookups for objects of the namespace
PINS: the number of reads or execution of the objects of the namespace
but this is not enough for me.
The second question:
difference between REQUEST_MISSES and REQUEST_FAILURES from v$shared_pool_reserved, again I know definitions:
REQUEST_MISSES: the number of times the served list didn't have a free piece of memory to satisfy the request, and proceeded to start flushing objects from the LRU list
REQUEST_FAILURES: the number of times that no memory was found to satisfy a request
Thanks
