cache_usage

Returns cache usage as a percentage of all objects in the cache to which the table belongs.

Syntax

cache_usage(table_name)

table_name – is the name of a table. The name can be fully qualified (that is, it can include the database and owner name).

Example 1 – Returns percentage of the cache used by the titles tables:

select cache_usage("titles")

----------------------------
                     98.876953

Example 2 – Returns, from the master database, the percentage of the cache used by the authors tables

select cache_usage ("pubs2..authors")

------------------------------------
                             98.876953

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.