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 10.2.0.1 to 11.2.0.1 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Goal

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?

Solution

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
Goal
Solution
References


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