Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re: Can we identify which sequences are currently loaded into the Shared Pool
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_at_singnet.com.sg>
> Date: 2004/05/09 Sun AM 07:32:53 EDT
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Sun May 09 2004 - 08:19:23 CDT
![]() |
![]() |