Search notes:
v$subcache
gv$subcache
selects from
x$kqlset
.
See also
Oracle Dynamic Performance Views
Index