Oracle | DBMS_JAVA

Oracle DBMS_JAVA_DUMP Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Allows a user to request various Java VM dumps from any active database session

AUTHID CURRENT_USER

Constants

Name	Data Type	Value
java_dump_db_interface_info	PLS_INTEGER	1
java_dump_stack	PLS_INTEGER	2
java_dump_memory_manager_state	PLS_INTEGER	4
java_dump_heap	PLS_INTEGER	8
java_dump_threads_and_monitors	PLS_INTEGER	16

Dependencies

STANDARD (only)

Documented No

First Available 10.1

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/dbmsjdmp.sql

DUMP

Dump the Java Memory Manager State dbms_java_dump.dump( request_flags IN PLS_INTEGER, session_id IN PLS_INTEGER DEFAULT NULL, session_serial IN PLS_INTEGER DEFAULT NULL);

exec dbms_java_dump.dump(dbms_java_dump.java_dump_memory_manager_state);

      

      PL/SQL procedure successfully completed.

      

      host

      

      -- to find the dump file look in the {$ORACLE_HOME}, diag, trace directory

      [oracle@test21]$ cd /u01/app/oracle/diag/rdbms/test21db_iad25g/test21db/trace

      [oracle@test21 trace]$ cat test21db_ora_6081.trc

      Trace file /u01/app/oracle/diag/rdbms/test21db_iad25g/test21db/trace/test21db_ora_6081.trc

      Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production

      Version 21.1.0.0.0

      Build label: RDBMS_21.0.0.0.0_LINUX.X64_201030

      ORACLE_HOME: /u01/app/oracle/product/21.0.0.0/dbhome_1

      System name: Linux

      Node name: test21

      Release: 4.1.12-124.43.4.el7uek.x86_64

      Version: #2 SMP Tue Sep 22 12:01:13 PDT 2020

      Machine: x86_64

      VM name: KVM CPUID feature flags: 0x010002fb

      Instance name: test21db

      Redo thread mounted by this instance: 1

      Oracle process number: 82

      Unix process pid: 6081, NID: 4026531836, image: oracle@test21 (TNS V1-V3)

      

      *** 2021-02-13T00:25:31.904862+00:00 (CDB$ROOT(1))

      *** SESSION ID:(31.18022) 2021-02-13T00:25:31.904894+00:00

      *** CLIENT ID:() 2021-02-13T00:25:31.904908+00:00

      *** SERVICE NAME:(SYS$USERS) 2021-02-13T00:25:31.904919+00:00

      *** MODULE NAME:(sqlplus@test21 (TNS V1-V3)) 
      2021-02-13T00:25:31.904931+00:00

      *** ACTION NAME:() 2021-02-13T00:25:31.904944+00:00

      *** CLIENT DRIVER:(SQL*PLUS) 2021-02-13T00:25:31.904955+00:00

      *** CONTAINER ID:(1) 2021-02-13T00:25:31.904966+00:00

      *** CLIENT IP:(N/A) 2021-02-13T00:25:31.904979+00:00

      *** CONNECTION ID:(uy28KukmF73gUxAAAAoGOw==) 
      2021-02-13T00:25:31.904990+00:00

      

      ### MMan Runtime Parameters ###

      Newspace size: 0x100000

      Newspace generation count: 2

      Newspace max. allowable object size: 1024

      Newspace tenure policy: 0

      Runspace max. size: 0xffffffff

      Oldspace max. size: 0x80000000

      Stackmem max. size: 0x20000000

      Session max. size: 0xffffffff

      Session soft limit: 0xffffffff

      Number of calls sinse last session GC: 0x0

      Newspace GC is enabled

      Session GC policy for current call: EOA_SGCP_FIRST_CALL

      Session GC threshold (GC when sessionspace is bigger than this): 0x100000

      Java stack size to use when creating new threads: 0x40000

      Maximum Java stack size: 0x400000