Tuning the Database - Expert Oracle RAC Performance Diagnostics and Tuning - page 303

Script: MVRACPDnTap_rcobjectcount.sql
SELECT inst_id INT,
id,
TYPE,
creation_timestamp,
block_count,
column_count,
row_count
FROM gv$result_cache_objects
WHERE inst_id =&& instnum;
INT ID TYPE STATUS CREATION_ BLOCK_COUNT COLUMN_COUNT ROW_COUNT
---- --- ---------- -------------------- --------- ----------- ------------ ----------
2 2 Dependency Published 05-AUG-14 1 0 0
2 0 Dependency Published 05-AUG-14 1 0 0
2 1 Result Published 05-AUG-14 1 1 1
The following output lists all the objects used by the query (dependency) and the function stored as a result.
Oracle generates the same CACHE_ID every single time for the exact same function irrespective of how many times the
function is executed and across how many instances in the cluster it is executed from.
Script: MVRACPDnTap_rcobjects.sql
SELECT inst_id INT,
id,
type,
status,
name,
object_no objno,
cache_id,
invalidations invals
FROM gv$result_cache_objects
WHERE inst_id = &&instnum;
Continuing our look at the subsets of data found in the V$RESULT_CACHE_OBJECTS , the following output lists the
current space utilization of the results section for this operation:
Script: MVRACPDnTap_rcutil.sql
SELECT inst_id INT,
id,
type,
block_count blkcnt,
column_count clmcnt,
scan_count,
row_count rcnt,