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

Last updated on AUGUST 19, 2010

Applies to:

Oracle Server - 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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms