I never really explored v$db_object_cache before. I did a query just to look around for all objects cached owned by a specific user and the type. This is what I get back. NAME TYPE ------------------------------ ---------------------------- SCHEMA PUB_SUB SCHEMA is actually a username. Why is that cached? What is a type of PUB_SUB? > > From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx> > Date: 2004/05/09 Sun AM 07:32:53 EDT > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------