Oracle | DBMS_JAVA

Oracle DBMS_JAVA_DUMP Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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