Oracle DBMS_JAVA_DUMP
Version 19.3

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 Only STANDARD
Documented No
First Available 10gR1
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);

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

Trace file C:\APPS19\diag\rdbms\orabase19\orabase19\trace\orabase19_ora_11684.trc
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Build label: RDBMS_19.3.0.0.0DBRU_WINDOWS.X64_180627.2
Windows NT Version V6.2
ORACLE_HOME = C:\app19
Node name : PERRITO5
CPU : 4 - type 8664, 2 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:11577M/16239M, Ph+PgF:11845M/18671M
Instance name: orabase19
Redo thread mounted by this instance: 1
Oracle process number: 52
Windows thread id: 11684, image: ORACLE.EXE (SHAD)

*** 2019-06-15T21:13:14.568700-06:00 (CDB$ROOT(1))
*** SESSION ID:(8.6236) 2019-06-15T21:13:14.568700-06:00
*** CLIENT ID:() 2019-06-15T21:13:14.568700-06:00
*** SERVICE NAME:(SYS$USERS) 2019-06-15T21:13:14.568700-06:00
*** MODULE NAME:(sqlplus.exe) 2019-06-15T21:13:14.568700-06:00
*** ACTION NAME:() 2019-06-15T21:13:14.568700-06:00
*** CLIENT DRIVER:(SQL*PLUS) 2019-06-15T21:13:14.568700-06:00
*** CONTAINER ID:(1) 2019-06-15T21:13:14.568700-06: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: 0xf8000
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 18c
What's New In 19c

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