--- v_obj.sql --- Query v$result_cache_objects connect / as sysdba col name format a55 select type, namespace,status, scan_count,name from v$result_cache_objects /