1、近期trace目录中出现了包含
cdmp关键字的文件夹
2、这些文件夹中文件名包括Bucket关键字
3、查询其中一个文件,主要内容如下:
Trace file /u01/app/oracle/diag/rdbms/easdb/easdb1/trace/cdmp_20220916100401/easdb1_ora_143792_bucket.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Data Mining
and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1
System name: Linux
Node name: mwrac1
Release: 4.1.12-112.16.4.el7uek.x86_64
Version: #2 SMP Mon Mar 12 23:57:12 PDT 2018
Machine: x86_64
Instance name: easdb1
Redo thread mounted by this instance: 1
Oracle process number: 47
Unix process pid: 143792, image: oracle@mwrac1
*** 2022-09-16 10:04:01.774
*** SESSION ID:(1791.23913) 2022-09-16 10:04:01.774
*** 2022-09-16 10:04:01.774
Process diagnostic dump for oracle@mwrac1, OS id=143792,
pid: 47, proc_ser: 243, sid: 1791, sess_ser: 23913
current sql: UPDATE T_LOG_App SET FIsSuccessed = 1 WHERE FID = :1
client details:
O/S info: user: root, term: unknown, ospid: 1234
machine: web1 program: JDBC Thin Client
application name: JDBC Thin Client, hash value=2546894660
Current Wait Stack:
0: waiting for ‘SQLNet message from client’
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=95769 seq_num=30235 snap_id=1
wait times: snap=1 min 11 sec, exc=1 min 11 sec, total=1 min 11 sec
wait times: max=infinite, heur=1 min 11 sec
wait counts: calls=0 os=0
in_wait=1 iflags=0x1a0
Wait State:
fixed_waits=0 flags=0x22 boundary=(nil)/-1
Session Wait History:
elapsed time of 0.000013 sec since current wait
0: waited for 'SQLNet message to client’
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=95768 seq_num=30234 snap_id=1
wait times: snap=0.000003 sec, exc=0.000003 sec, total=0.000003 sec
wait times: max=infinite
wait counts: calls=0 os=0
occurred after 0.000101 sec of elapsed time
1: waited for ‘reliable message’
channel context=0x136151d988, channel handle=0x1411545a08, broadcast message=0x1257cb1b38
wait_id=95767 seq_num=30233 snap_id=1
wait times: snap=0.000618 sec, exc=0.000618 sec, total=0.000618 sec
wait times: max=infinite
wait counts: calls=1 os=1
occurred after 0.000078 sec of elapsed time
2: waited for ‘reliable message’
channel context=0x136151d988, channel handle=0x1411545a08, broadcast message=0x1257cb1208
wait_id=95766 seq_num=30232 snap_id=1
wait times: snap=0.000468 sec, exc=0.000468 sec, total=0.000468 sec
wait times: max=infinite
wait counts: calls=1 os=1
occurred after 0.001207 sec of elapsed time
3: waited for ‘SQLNet message from client’
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=95765 seq_num=30231 snap_id=1
wait times: snap=0.052078 sec, exc=0.052078 sec, total=0.052078 sec
wait times: max=infinite
wait counts: calls=0 os=0
occurred after 0.000013 sec of elapsed time
4: waited for 'SQLNet message to client’
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=95764 seq_num=30230 snap_id=1
wait times: snap=0.000001 sec, exc=0.000001 sec, total=0.000001 sec
wait times: max=infinite
wait counts: calls=0 os=0
occurred after 0.000029 sec of elapsed time
5: waited for ‘log file sync’
buffer#=0xb715, sync scn=0xfa87bc61, =0x0
wait_id=95763 seq_num=30229 snap_id=1
wait times: snap=0.000182 sec, exc=0.000182 sec, total=0.000182 sec
wait times: max=infinite
wait counts: calls=1 os=1
occurred after 0.000050 sec of elapsed time
6: waited for ‘reliable message’
channel context=0x136151d988, channel handle=0x1411545a08, broadcast message=0x1257cb1518
wait_id=95762 seq_num=30228 snap_id=1
wait times: snap=0.000471 sec, exc=0.000471 sec, total=0.000471 sec
wait times: max=infinite
wait counts: calls=1 os=1
occurred after 0.000087 sec of elapsed time
7: waited for ‘reliable message’
channel context=0x136151d988, channel handle=0x1411545a08, broadcast message=0x14115c8a90
wait_id=95761 seq_num=30227 snap_id=1
wait times: snap=0.000448 sec, exc=0.000448 sec, total=0.000448 sec
wait times: max=infinite
wait counts: calls=1 os=1
occurred after 0.001206 sec of elapsed time
8: waited for ‘SQLNet message from client’
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=95760 seq_num=30226 snap_id=1
wait times: snap=0.000892 sec, exc=0.000892 sec, total=0.000892 sec
wait times: max=infinite
wait counts: calls=0 os=0
occurred after 0.000012 sec of elapsed time
9: waited for 'SQLNet message to client’
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=95759 seq_num=30225 snap_id=1
wait times: snap=0.000002 sec, exc=0.000002 sec, total=0.000002 sec
wait times: max=infinite
wait counts: calls=0 os=0
occurred after 0.000030 sec of elapsed time
Sampled Session History of session 1791 serial 23913