https://docs.oracle.com/en/database/oracle/oracle-database/26/refrn/V-RESULT_CACHE_MEMORY.html
V$RESULT_CACHE_MEMORY displays all the memory blocks and their status.
result cachevmemory
https://www.dell.com/support/kbdoc/en-us/000206307/sds-mdcache-status-is-pending-result?lang=en
Setting and enabling MD_cache in a Protection Domain (PD) results in SDS' FGL metadata cache state in "pending result".
sdsmdcachestatuspending