| General Information |
| Library Note |
Morgan's Library Page Header
|
| 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 |
|
| 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
It appears that entries are made every 5 minutes. |
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 /u01/app/oracle/diagrdbms/asra23ai/ASRA23ai/trace
ls -lrt
vi ASRA23ai_dbrm_91583.trc
-- to find the dump file look in the {$ORACLE_HOME}, diag, trace directory
Trace file /u01/app/oracle/diag/rdbms/asra23ai_qrd_iad/ASRA23ai/trace/ASRA23ai_dbrm_91583.trc
Oracle Database 23ai EE High Perf Release 23.0.0.0.0 - Production
Version 23.4.0.24.05
Build label: RDBMS_23.0.0.0.0_LINUX.X64_240424
ORACLE_HOME: /u01/app/oracle/product/23.0.0.0/dbhome_1
System name: Linux
Node name: asra23c
Release: 5.4.17-2136.326.6.el8uek.x86_64
Version: #2 SMP Thu Nov 30 22:30:37 PST 2023
Machine: x86_64
VM name: KVM CPUID feature flags: 0x01003afb
CLID: O
Instance name: ASRA23ai
Instance number: 1
Redo thread mounted by this instance: 1
Oracle process number: 18
Unix process pid: 91583, NID: 4026531836, image: oracle@asra23c (DBRM)
*** 2024-07-17T13:24:33.353061+00:00 (CDB$ROOT(1))
*** SESSION ID:(309.55381) 2024-07-17T13:24:33.353074+00:00
*** CLIENT ID:() 2024-07-17T13:24:33.353080+00:00
*** SERVICE NAME:(SYS$BACKGROUND) 2024-07-17T13:24:33.353086+00:00
*** MODULE NAME:(sys$abs_timeout) 2024-07-17T13:24:33.353092+00:00
*** ACTION NAME:(DBRM Timeout Actions) 2024-07-17T13:24:33.353098+00:00
*** CLIENT DRIVER:(SERVER) 2024-07-17T13:24:33.353103+00:00
*** CONTAINER ID:(1) 2024-07-17T13:24:33.353109+00:00
*** TRACE FILE RECREATED AFTER BEING REMOVED ***
s: 7 232 0 0.00 0.00 0
r: 0 0 0 0 0 0 0
*** 2024-07-17T13:29:33.639176+00:00 (CDB$ROOT(1))
*** MODULE NAME:(sys$abs_timeout) 2024-07-17T13:29:33.639235+00:00
*** ACTION NAME:(DBRM Timeout Actions) 2024-07-17T13:29:33.639248+00:00
s: 1 218 0 0.00 0.00 0
r: 0 0 0 0 0 0 0
*** 2024-07-17T13:34:33.934580+00:00 (CDB$ROOT(1))
*** MODULE NAME:(sys$abs_timeout) 2024-07-17T13:34:33.934625+00:00
*** ACTION NAME:(DBRM Timeout Actions) 2024-07-17T13:34:33.934634+00:00
s: 1 191 0 0.00 0.00 0
r: 0 0 0 0 0 0 0
... <cut>
*** 2024-07-17T22:00:01.376057+00:00 (CDB$ROOT(1))
*** MODULE NAME:(sys$abs_timeout) 2024-07-17T22:00:01.376097+00:00
*** ACTION NAME:(DBRM Timeout Actions) 2024-07-17T22:00:01.376117+00:00
high_threshold_delta=4
RM_CPU:kgskupdbasethresh(): [0] base=[8-12], dyn=[12-16]
START RESOURCE MANAGER PLAN/CONSUMER GROUP DUMP
CDB DEFAULT_MAINTENANCE_PLAN cpu_count=8.00 cpu_min=8.00 cpu_cnt_plan celladj=ON,0
PDB #1 ORA$AUTOTASK_PLAN dirtype=AUTO ulim=9000 shrs=8
PDB #1 ORA$ROOT_PLAN shrs=168
PDB #2 PDB$SEED dirtype=DEF shrs=80
PDB #3 ASRA23AI_PDB1 dirtype=DEF shrs=80
PDB #3 ASRA23AI_PDB1/DEFAULT_MAINTENANCE_PLAN cpu_min=8.00 celladj=OFF,0
CG ORA$AUTOTASK MGMT_P1=5 MAX_UTILIZATION_LIMIT=90
SHARES=5
CG OTHER_GROUPS MGMT_P1=20 SHARES=20
CG SYS_GROUP MGMT_P1=75 SHARES=75
END RESOURCE MANAGER PLAN/CONSUMER GROUP DUMP
... <truncated>
|