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

Related Topics
Built-in Functions
Built-in Packages
DBMS_JAVA
DBMS_JAVA_DEV
DBMS_JAVA_MISC
DBMS_JAVA_TEST
Dumping Oracle
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx