Returns cache usage as a percentage of all objects in the cache to which the table belongs.
cache_usage(table_name)
is the name of a table. The name can be fully qualified (that is, it can include the database and owner name).
Returns percentage of the cache used by the titles tables:
select cache_usage("titles")
---------------------------- 98.876953
Retuns, from the master database, the percentage of the cache used by the authors tables
select cache_usage ("pubs2..authors")
------------------------------------ 98.876953
cache_usage provides cache usage as percentage across all the pools of the cache.
cache_usage does not provide any information on how much cache the current object is using, and does not provide information for cache usages of indexes if they are bound to different cache.
In cluster environments – cache_usage provides cache usage of the cache the object is bound to in current node.
Any user can execute cache_usage.
