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

Script: MVRACPDnTap_rcobjectcount.sql

SELECT inst_id INT,
id,
TYPE,
creation_timestamp,
block_count,
column_count,
pin_count,
row_count
FROM gv$result_cache_objects
WHERE inst_id =&& instnum;

INT ID TYPE CREATION_ BLOCK_COUNT COLUMN_COUNT PIN_COUNT ROW_COUNT
---- --- ---------- --------- ----------- ------------ ---------- ----------
1 1 Dependency 20-APR-14 1 0 0 0
1 0 Dependency 20-APR-14 1 0 0 0
1 2 Result 20-APR-14 7 5 0 300

The following output lists all the objects used by the query (dependency) and the query itself stored as a result.
Oracle generates the same CACHE_ID every single time for the exact same query, irrespective of how many times the
query 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;

■ the values found in column OBJECT_NO (OBJNO) correspond to the value of the OBJECT_ID column in the
DBA_OBJECTS view.

Note