My Oracle Support Banner

Are XDB-Owned Objects In V$DB_OBJECT_CACHE Normal? (Doc ID 1181323.1)

Last updated on FEBRUARY 24, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 11.2]
Information in this document applies to any platform.


The XDB user has objects cached in the library cache with large values for SHARABLE_MEM:

SQL> select owner, name, type, sharable_mem
  2    from v$db_object_cache
  3    where kept='YES'
  4    and owner = 'XDB';

OWNER      NAME                           TYPE       SHARABLE_MEM
---------- ------------------------------ ---------- ------------
XDB        XDDdDp2q2E99HgQCOCX6FYog==     IFS             4389694
XDB        XDbD/PLZ01TcHgNAgAIIegtw==     IFS             3666694

Is this normal or is it a problem?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.