DBA_CACHEABLE_NONTABLE_OBJECTS
Columns ___________________________ OWNER -- OBJECT_NAME -- OBJECT_TYPE --
Related:
Simon Sheppard SS64.com