Oracle | DBMS_JAVA

Oracle DBMS_JAVA_DUMP Version 23c

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

      

      cd /opt/oracle/diag/rdbms/free/FREE/trace

      

      ls -lrt

      

      vi FREE_ora_4251.trc

      

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

      Trace file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_ora_4251.trc

      Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release

      Version 23.2.0.0.0

      Build label: RDBMS_23.2.0.0.0_LINUX.X64_230325

      ORACLE_HOME: /opt/oracle/product/23c/dbhomeFree

      System name: Linux

      Node name: localhost.localdomain

      Release: 5.15.0-8.91.4.1.el8uek.x86_64

      Version: #2 SMP Tue Mar 7 18:28:34 PST 2023

      Machine: x86_64

      VM name: KVM CPUID feature flags: 0x01000089

      CLID: P

      Instance name: FREE

      Redo thread mounted by this instance: 1

      Oracle process number: 71

      Unix process pid: 4251, NID: 4026531836, image: oracle@localhost.localdomain 
      (TNS V1-V3)

      

      

      *** 2023-10-12T00:36:52.353889+00:00 (CDB$ROOT(1))

      *** SESSION ID:(277.34121) 2023-10-12T00:36:52.353902+00:00

      *** CLIENT ID:() 2023-10-12T00:36:52.353908+00:00

      *** SERVICE NAME:(SYS$USERS) 2023-10-12T00:36:52.353911+00:00

      *** MODULE NAME:(sqlplus@localhost.localdomain (TNS V1-V3)) 2023-10-

                                                                  12T00:36:52.353915+00:00

      *** ACTION NAME:() 2023-10-12T00:36:52.353919+00:00

      *** CLIENT DRIVER:(SQL*PLUS) 2023-10-12T00:36:52.353922+00:00

      *** CONTAINER ID:(1) 2023-10-12T00:36:52.353925+00:00

      *** CLIENT IP:(N/A) 2023-10-12T00:36:52.353929+00:00

      *** CONNECTION ID:(B3NG2xT4EJngYwEAAH+wrA==) 
      2023-10-12T00:36:52.353937+00:00

      

      

      *** TRACE FILE RECREATED AFTER BEING REMOVED ***

      

      ### 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