| General Information |
| Purpose |
Allows a user to request various Java VM dumps from any active database session |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsjdmp.sql |
| First Available |
10.1 |
| 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 |
| Security Model |
Owned by SYS with no privileges granted |
| |
| DUMP |
| Lets a session register interest in an alert |
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);
Trace file
c:\oracle\product\diag\rdbms\orabase\orabase\trace\orabase_ora_18732.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1628M/3062M, Ph+PgF:3556M/4947M, VA:1275M/2047M
Instance name: orabase
Redo thread mounted by this instance: 1
Oracle process number: 24
Windows thread id: 18732, image: ORACLE.EXE (SHAD)
*** 2009-08-07 11:20:32.734
*** SESSION ID:(128.820) 2009-08-07 11:20:32.734
*** CLIENT ID:() 2009-08-07 11:20:32.734
*** SERVICE NAME:(SYS$USERS) 2009-08-07 11:20:32.734
*** MODULE NAME:(sqlplusw.exe) 2009-08-07 11:20:32.734
*** ACTION NAME:() 2009-08-07 11:20:32.734
### MMan Runtime Parameters ###
Newspace size: 0x80000
Newspace generation count: 2
Newspace max. allowable object size: 1024
Newspace tenure policy: 0
Runspace max. size: 0xffffffff
Oldspace max. size: 0x10000000
Stackmem max. size: 0x10000000
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 |
|
