Trace file /app/oracle/app/oracle/diag/rdbms/xbook/XBOOK/trace/XBOOK_pmon_14051.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /app/oracle/app/oracle/product/11.2.0/dbhome_1
System name: Linux
Node name: linux
Release: 3.10.0-1062.12.1.el7.x86_64
Version: #1 SMP Tue Feb 4 23:02:59 UTC 2020
Machine: x86_64
Instance name: XBOOK
Redo thread mounted by this instance: 1
Oracle process number: 2
Unix process pid: 14051, image: oracle@linux (PMON)
*** 2021-04-01 22:21:54.061
*** SESSION ID:(63.1) 2021-04-01 22:21:54.061
*** CLIENT ID:() 2021-04-01 22:21:54.061
*** SERVICE NAME:(SYS$BACKGROUND) 2021-04-01 22:21:54.061
*** MODULE NAME:() 2021-04-01 22:21:54.061
*** ACTION NAME:() 2021-04-01 22:21:54.061
KGX cleanup...
KGX Atomic Operation Log 0x973e54f0
Mutex 0x979cb6e0(156, 0) idn df0b0a66 oper EXCL
Cursor Pin uid 156 efd 7 whr 10 slp 0
Incident 9623 created, dump file: /app/oracle/app/oracle/diag/rdbms/xbook/XBOOK/incident/incdir_9623/XBOOK_pmon_14051_i9623.trc
ORA-00600: internal error code, arguments: [17112], [0x08E2B0F80], [], [], [], [], [], [], [], [], [], []
PMON: fatal error while deleting s.o. 0x9f49d530 in this tree:
----------------------------------------
SO: 0x9f49d530, type: 2, owner: (nil), flag: INIT/-/-/0x00 if: 0x3 c: 0x3
proc=0x9f49d530, name=process, file=ksu.h LINE:11459, pg=0
(process) Oracle pid:37, ser:67, calls cur/top: 0x9f07c8a8/0x9f07c8a8
flags : (0x1) DEAD
flags2: (0x0), flags3: (0x0)
intr error: 0, call error: 0, sess error: 0, txn error 0
intr queue: empty
ksudlp FALSE at location: 0
(post info) last post received: 0 0 0
last post received-location: No post
last process to post me: none
last post sent: 0 0 26
last post sent-location: ksa2.h LINE:282 ID:ksasnd
last process posted by me: 9f482eb0 1 6
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: 0x9f51de70
O/S info: user: oracle, term: UNKNOWN, ospid: 7006 (DEAD)
OSD pid info: Unix process pid: 7006, image: oracle@linux
Dump of memory from 0x000000009F469668 to 0x000000009F469870
09F469660 00000000 00000000 [........]
09F469670 00000000 00000000 00000000 00000000 [................]
Repeat 31 times
(FOB) flags=2050 fib=0x9e726e40 incno=0 pending i/o cnt=0
fname=/app/oracle/app/oracle/oradata/XBOOK/XIR_MD_IDX.DBF
fno=11 lblksz=8192 fsiz=143872
(FOB) flags=2050 fib=0x9e726828 incno=0 pending i/o cnt=0
fname=/app/oracle/app/oracle/oradata/XBOOK/XIR_MD_DAT.DBF
fno=10 lblksz=8192 fsiz=924672
(FOB) flags=2050 fib=0x9e7231c8 incno=0 pending i/o cnt=0
fname=/app/oracle/app/oracle/oradata/XBOOK/system01.dbf
fno=1 lblksz=8192 fsiz=101120
(FOB) flags=2050 fib=0x9e723de0 incno=0 pending i/o cnt=0
fname=/app/oracle/app/oracle/oradata/XBOOK/undotbs01.dbf
fno=3 lblksz=8192 fsiz=1520000
----------------------------------------
SO: 0x9f748668, type: 4, owner: 0x9f49d530, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
proc=0x9f49d530, name=session, file=ksu.h LINE:11467, pg=0
(session) sid: 156 ser: 205 trans: (nil), creator: 0x9f49d530
flags: (0x45) USR/- flags_idl: (0x1) BSY/-/-/-/-/-
flags2: (0x40008) -/-
DID: , short-term DID:
txn branch: (nil)
oct: 0, prv: 0, sql: (nil), psql: 0x8e56ba90, user: 97/XIR_TRD_FC
ksuxds FALSE at location: 0
service name: XBOOK
client details:
O/S info: user: Administrator, term: WINDOWS, ospid: 3132:9500
machine: WORKGROUP\WINDOWS program: httpd.exe
application name: httpd.exe, hash value=https://bbs.csdn.net/topics/2794960912
Current Wait Stack:
Not in wait; last wait ended 2.708060 sec ago
Wait State:
fixed_waits=0 flags=0x21 boundary=(nil)/-1
Session Wait History:
elapsed time of 2.708079 sec since last wait
0: waited for 'SQL*Net message from client'
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=53155 seq_num=53156 snap_id=1
wait times: snap=0.006616 sec, exc=0.006616 sec, total=0.006616 sec
wait times: max=infinite
wait counts: calls=0 os=0
occurred after 0.000025 sec of elapsed time
1: waited for 'SQL*Net message to client'
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=53154 seq_num=53155 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.000046 sec of elapsed time
2: waited for 'SQL*Net message from client'
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=53153 seq_num=53154 snap_id=1
wait times: snap=0.000742 sec, exc=0.000742 sec, total=0.000742 sec
wait times: max=infinite
wait counts: calls=0 os=0
occurred after 0.000003 sec of elapsed time
3: waited for 'SQL*Net message to client'
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=53152 seq_num=53153 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.000044 sec of elapsed time
4: waited for 'SQL*Net message from client'
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=53151 seq_num=53152 snap_id=1
wait times: snap=0.000896 sec, exc=0.000896 sec, total=0.000896 sec
wait times: max=infinite
wait counts: calls=0 os=0
occurred after 0.000017 sec of elapsed time
5: waited for 'SQL*Net message to client'
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=53150 seq_num=53151 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.001243 sec of elapsed time
6: waited for 'SQL*Net message from client'
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=53149 seq_num=53150 snap_id=1
wait times: snap=0.002193 sec, exc=0.002193 sec, total=0.002193 sec
wait times: max=infinite
wait counts: calls=0 os=0
occurred after 0.000002 sec of elapsed time
7: waited for 'SQL*Net message to client'
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=53148 seq_num=53149 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.000017 sec of elapsed time
8: waited for 'SQL*Net message from client'
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=53147 seq_num=53148 snap_id=1
wait times: snap=0.000733 sec, exc=0.000733 sec, total=0.000733 sec
wait times: max=infinite
wait counts: calls=0 os=0
occurred after 0.000003 sec of elapsed time
9: waited for 'SQL*Net message to client'
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=53146 seq_num=53147 snap_id=1
wait times: snap=0.000000 sec, exc=0.000000 sec, total=0.000000 sec
wait times: max=infinite
wait counts: calls=0 os=0
occurred after 0.000037 sec of elapsed time
Sampled Session History of session 156 serial 205
---------------------------------------------------
The sampled session history is constructed by sampling
the target session every 1 second. The sampling process
captures at each sample if the session is in a non-idle wait,
an idle wait, or not in a wait. If the session is in a
non-idle wait then one interval is shown for all the samples
the session was in the same non-idle wait. If the
session is in an idle wait or not in a wait for
consecutive samples then one interval is shown for all
the consecutive samples. Though we display these consecutive
samples in a single interval the session may NOT be continuously
idle or not in a wait (the sampling process does not know).
The history is displayed in reverse chronological order.
sample interval: 1 sec, max history 120 sec
---------------------------------------------------
[3 samples, 22:21:52 - 22:21:54]
not in wait at each sample
[10 samples, 22:21:42 - 22:21:51]
idle wait at each sample
[1 sample, 22:21:41]
not in wait at each sample
[21 samples, 22:21:20 - 22:21:40]
idle wait at each sample
[1 sample, 22:21:19]
not in wait at each sample
[4 samples, 22:21:15 - 22:21:18]
idle wait at each sample
[1 sample, 22:21:14]
not in wait at each sample
[7 samples, 22:21:07 - 22:21:13]
idle wait at each sample
[2 samples, 22:21:05 - 22:21:06]
not in wait at each sample
[71 samples, 22:19:54 - 22:21:04]
idle wait at each sample
temporary object counter: 0
----------------------------------------
Virtual Thread:
kgskvt: 0x9ee1ff60, sess: 0x9f748668, vc: (nil), proc: 0x9f49d530, id: 156
consumer group cur: OTHER_GROUPS (upd? 0), mapped: DEFAULT_CONSUMER_GROUP, orig:
vt_state: 0x4, vt_flags: 0xA030, blkrun: 0, numa: 1
inwait: 0
location where insched last set: kgskewt
location where insched last cleared: kgskewt3
location where inwait last set: kgskbwt
location where inwait last cleared: kgskewtint2
is_assigned: 1, in_sched: 0 (0)
vt_active: 0 (pending: 0)
used quanta: 8331600 (cg: 8331600) usec
cpu start time: 4091949354
idle time: 0, active time: 2245 (cg: 2245)
cpu yields: 0 (cg: 0), waits: 0 (cg: 0), wait time: 0
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/271676.html
標籤：高級技術