trace 文件如下:
Dump file /opt/oracle/admin/dbjdgz/bdump/dbjdgz_smon_871.trc
Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
ORACLE_HOME = /opt/oracle/product/8.1.5
System name: SunOS
Node name: jdsn480
Release: 5.9
Version: Generic_112233-05
Machine: sun4u
Instance name: dbjdgz
Redo thread mounted by this instance: 1
Oracle process number: 6
Unix process pid: 871, image: oracle@jdsn480 (SMON)*** SESSION ID:(5.1) 2006.09.26.12.07.24.000
UNDO SEG (BEFORE RECOVERY): usn = 0 Extent Control Header
-----------------------------------------------------------------
Extent Header:: spare1: 0 space2: 0 #extents: 12 #blocks: 299
last map 0x00000000 #maps: 0 offset: 1056
Highwater:: 0x00400bb1 ext#: 11 blk#: 18 ext size: 25
#blocks in seg. hdr's freelists: 0
#blocks below: 0
mapblk 0x00000000 offset: 11
Unlocked
Map Header:: next 0x00000000 #extents: 12 obj#: 0 flag: 0x40000000
Extent Map
-----------------------------------------------------------------
0x00400003 length: 24
0x0040001b length: 25
0x00400183 length: 25
0x0040019c length: 25
0x004001b5 length: 25
0x004001ce length: 25
0x004001e7 length: 25
0x00400200 length: 25
0x00400b6d length: 25
0x00400b86 length: 25
0x004009ec length: 25
0x00400b9f length: 25
TRN CTL:: seq: 0x01e7 chd: 0x0011 ctl: 0x0014 inc: 0x00000000 nfb: 0x0000
mgc: 0x8002 xts: 0x0068 flg: 0x0001 opt: 2147483646 (0x7ffffffe)
uba: 0x00400bb1.01e7.08 scn: 0x0000.28a95b79
Version: 0x01
FREE BLOCK POOL::
uba: 0x00000000.01e7.07 ext: 0xb spc: 0x1d0
uba: 0x00000000.01e5.0a ext: 0x9 spc: 0x38a
uba: 0x00000000.01b0.01 ext: 0x4 spc: 0x724
uba: 0x00000000.0066.07 ext: 0xa spc: 0x514
uba: 0x00000000.0000.00 ext: 0x0 spc: 0x0
TRN TBL::
index state cflags wrap# uel scn dba parent-xid nub
------------------------------------------------------------------------------------------------
0x00 9 0x00 0x03c4 0x000c 0x0000.28a95b7b 0x00400baf 0x0000.000.00000000 0x00000001 0x0000
0x01 9 0x00 0x03c3 0x000a 0x0000.28a95b9f 0x00400bb0 0x0000.000.00000000 0x00000001 0x0000
0x02 9 0x00 0x03c4 0x0014 0x0000.28a95ba7 0x00400bb1 0x0000.000.00000000 0x00000001 0x0000
0x03 9 0x00 0x03c4 0x0013 0x0000.28a95b9c 0x00400bb0 0x0000.000.00000000 0x00000001 0x0000
0x04 9 0x00 0x03c3 0x000e 0x0000.28a95b81 0x00400baf 0x0000.000.00000000 0x00000001 0x0000
0x05 9 0x00 0x03c4 0x0006 0x0000.28a95ba2 0x00400bb1 0x0000.000.00000000 0x00000001 0x0000
0x06 9 0x00 0x03c5 0x0008 0x0000.28a95ba4 0x00400bb1 0x0000.000.00000000 0x00000001 0x0000
0x07 9 0x00 0x03c7 0x0004 0x0000.28a95b7f 0x00400baf 0x0000.000.00000000 0x00000001 0x0000
0x08 9 0x00 0x03c0 0x0010 0x0000.28a95ba5 0x00400bb1 0x0000.000.00000000 0x00000001 0x0000
0x09 9 0x00 0x03ba 0x000b 0x0000.28a95b95 0x00400bb0 0x0000.000.00000000 0x00000002 0x0000
0x0a 9 0x00 0x03c3 0x000d 0x0000.28a95ba0 0x00400bb1 0x0000.000.00000000 0x00000001 0x0000
0x0b 9 0x00 0x03c7 0x0003 0x0000.28a95b9a 0x00400bb0 0x0000.000.00000000 0x00000001 0x0000
0x0c 9 0x00 0x03c5 0x0012 0x0000.28a95b7d 0x00400baf 0x0000.000.00000000 0x00000001 0x0000
0x0d 9 0x00 0x03c4 0x0005 0x0000.28a95ba1 0x00400bb1 0x0000.000.00000000 0x00000001 0x0000
0x0e 9 0x00 0x03c5 0x0009 0x0000.28a95b83 0x00400baf 0x0000.000.00000000 0x00000001 0x0000
0x0f 9 0x00 0x03c5 0x0001 0x0000.28a95b9e 0x00400bb0 0x0000.000.00000000 0x00000001 0x0000
0x10 9 0x00 0x03c7 0x0002 0x0000.28a95ba6 0x00400bb1 0x0000.000.00000000 0x00000001 0x0000
0x11 9 0x00 0x03c4 0x0000 0x0000.28a95b7a 0x00400baf 0x0000.000.00000000 0x00000001 0x0000
0x12 9 0x00 0x03c5 0x0007 0x0000.28a95b7e 0x00400baf 0x0000.000.00000000 0x00000001 0x0000
0x13 9 0x00 0x03c1 0x000f 0x0000.28a95b9d 0x00400bb0 0x0000.000.00000000 0x00000001 0x0000
0x14 9 0x00 0x03c2 0xffff 0x0000.28a95ba8 0x00400bb1 0x0000.000.00000000 0x00000001 0x0000
UNDO SEG (AFTER RECOVERY): usn = 0 Extent Control Header
-----------------------------------------------------------------
Extent Header:: spare1: 0 space2: 0 #extents: 12 #blocks: 299
last map 0x00000000 #maps: 0 offset: 1056
Highwater:: 0x00400bb1 ext#: 11 blk#: 18 ext size: 25
#blocks in seg. hdr's freelists: 0
#blocks below: 0
mapblk 0x00000000 offset: 11
Unlocked
Map Header:: next 0x00000000 #extents: 12 obj#: 0 flag: 0x40000000
Extent Map
-----------------------------------------------------------------
0x00400003 length: 24
0x0040001b length: 25
0x00400183 length: 25
0x0040019c length: 25
0x004001b5 length: 25
0x004001ce length: 25
0x004001e7 length: 25
0x00400200 length: 25
0x00400b6d length: 25
0x00400b86 length: 25
0x004009ec length: 25
0x00400b9f length: 25
TRN CTL:: seq: 0x01e7 chd: 0x0011 ctl: 0x0014 inc: 0x00000000 nfb: 0x0000
mgc: 0x8002 xts: 0x0068 flg: 0x0001 opt: 2147483646 (0x7ffffffe)
uba: 0x00400bb1.01e7.08 scn: 0x0000.28a95b79
Version: 0x01
FREE BLOCK POOL::
uba: 0x00000000.01e7.07 ext: 0xb spc: 0x1d0
uba: 0x00000000.01e5.0a ext: 0x9 spc: 0x38a
uba: 0x00000000.01b0.01 ext: 0x4 spc: 0x724
uba: 0x00000000.0066.07 ext: 0xa spc: 0x514
uba: 0x00000000.0000.00 ext: 0x0 spc: 0x0
TRN TBL:请大家帮忙分析一下。
Dump file /opt/oracle/admin/dbjdgz/bdump/dbjdgz_smon_871.trc
Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
ORACLE_HOME = /opt/oracle/product/8.1.5
System name: SunOS
Node name: jdsn480
Release: 5.9
Version: Generic_112233-05
Machine: sun4u
Instance name: dbjdgz
Redo thread mounted by this instance: 1
Oracle process number: 6
Unix process pid: 871, image: oracle@jdsn480 (SMON)*** SESSION ID:(5.1) 2006.09.26.12.07.24.000
UNDO SEG (BEFORE RECOVERY): usn = 0 Extent Control Header
-----------------------------------------------------------------
Extent Header:: spare1: 0 space2: 0 #extents: 12 #blocks: 299
last map 0x00000000 #maps: 0 offset: 1056
Highwater:: 0x00400bb1 ext#: 11 blk#: 18 ext size: 25
#blocks in seg. hdr's freelists: 0
#blocks below: 0
mapblk 0x00000000 offset: 11
Unlocked
Map Header:: next 0x00000000 #extents: 12 obj#: 0 flag: 0x40000000
Extent Map
-----------------------------------------------------------------
0x00400003 length: 24
0x0040001b length: 25
0x00400183 length: 25
0x0040019c length: 25
0x004001b5 length: 25
0x004001ce length: 25
0x004001e7 length: 25
0x00400200 length: 25
0x00400b6d length: 25
0x00400b86 length: 25
0x004009ec length: 25
0x00400b9f length: 25
TRN CTL:: seq: 0x01e7 chd: 0x0011 ctl: 0x0014 inc: 0x00000000 nfb: 0x0000
mgc: 0x8002 xts: 0x0068 flg: 0x0001 opt: 2147483646 (0x7ffffffe)
uba: 0x00400bb1.01e7.08 scn: 0x0000.28a95b79
Version: 0x01
FREE BLOCK POOL::
uba: 0x00000000.01e7.07 ext: 0xb spc: 0x1d0
uba: 0x00000000.01e5.0a ext: 0x9 spc: 0x38a
uba: 0x00000000.01b0.01 ext: 0x4 spc: 0x724
uba: 0x00000000.0066.07 ext: 0xa spc: 0x514
uba: 0x00000000.0000.00 ext: 0x0 spc: 0x0
TRN TBL::
index state cflags wrap# uel scn dba parent-xid nub
------------------------------------------------------------------------------------------------
0x00 9 0x00 0x03c4 0x000c 0x0000.28a95b7b 0x00400baf 0x0000.000.00000000 0x00000001 0x0000
0x01 9 0x00 0x03c3 0x000a 0x0000.28a95b9f 0x00400bb0 0x0000.000.00000000 0x00000001 0x0000
0x02 9 0x00 0x03c4 0x0014 0x0000.28a95ba7 0x00400bb1 0x0000.000.00000000 0x00000001 0x0000
0x03 9 0x00 0x03c4 0x0013 0x0000.28a95b9c 0x00400bb0 0x0000.000.00000000 0x00000001 0x0000
0x04 9 0x00 0x03c3 0x000e 0x0000.28a95b81 0x00400baf 0x0000.000.00000000 0x00000001 0x0000
0x05 9 0x00 0x03c4 0x0006 0x0000.28a95ba2 0x00400bb1 0x0000.000.00000000 0x00000001 0x0000
0x06 9 0x00 0x03c5 0x0008 0x0000.28a95ba4 0x00400bb1 0x0000.000.00000000 0x00000001 0x0000
0x07 9 0x00 0x03c7 0x0004 0x0000.28a95b7f 0x00400baf 0x0000.000.00000000 0x00000001 0x0000
0x08 9 0x00 0x03c0 0x0010 0x0000.28a95ba5 0x00400bb1 0x0000.000.00000000 0x00000001 0x0000
0x09 9 0x00 0x03ba 0x000b 0x0000.28a95b95 0x00400bb0 0x0000.000.00000000 0x00000002 0x0000
0x0a 9 0x00 0x03c3 0x000d 0x0000.28a95ba0 0x00400bb1 0x0000.000.00000000 0x00000001 0x0000
0x0b 9 0x00 0x03c7 0x0003 0x0000.28a95b9a 0x00400bb0 0x0000.000.00000000 0x00000001 0x0000
0x0c 9 0x00 0x03c5 0x0012 0x0000.28a95b7d 0x00400baf 0x0000.000.00000000 0x00000001 0x0000
0x0d 9 0x00 0x03c4 0x0005 0x0000.28a95ba1 0x00400bb1 0x0000.000.00000000 0x00000001 0x0000
0x0e 9 0x00 0x03c5 0x0009 0x0000.28a95b83 0x00400baf 0x0000.000.00000000 0x00000001 0x0000
0x0f 9 0x00 0x03c5 0x0001 0x0000.28a95b9e 0x00400bb0 0x0000.000.00000000 0x00000001 0x0000
0x10 9 0x00 0x03c7 0x0002 0x0000.28a95ba6 0x00400bb1 0x0000.000.00000000 0x00000001 0x0000
0x11 9 0x00 0x03c4 0x0000 0x0000.28a95b7a 0x00400baf 0x0000.000.00000000 0x00000001 0x0000
0x12 9 0x00 0x03c5 0x0007 0x0000.28a95b7e 0x00400baf 0x0000.000.00000000 0x00000001 0x0000
0x13 9 0x00 0x03c1 0x000f 0x0000.28a95b9d 0x00400bb0 0x0000.000.00000000 0x00000001 0x0000
0x14 9 0x00 0x03c2 0xffff 0x0000.28a95ba8 0x00400bb1 0x0000.000.00000000 0x00000001 0x0000
UNDO SEG (AFTER RECOVERY): usn = 0 Extent Control Header
-----------------------------------------------------------------
Extent Header:: spare1: 0 space2: 0 #extents: 12 #blocks: 299
last map 0x00000000 #maps: 0 offset: 1056
Highwater:: 0x00400bb1 ext#: 11 blk#: 18 ext size: 25
#blocks in seg. hdr's freelists: 0
#blocks below: 0
mapblk 0x00000000 offset: 11
Unlocked
Map Header:: next 0x00000000 #extents: 12 obj#: 0 flag: 0x40000000
Extent Map
-----------------------------------------------------------------
0x00400003 length: 24
0x0040001b length: 25
0x00400183 length: 25
0x0040019c length: 25
0x004001b5 length: 25
0x004001ce length: 25
0x004001e7 length: 25
0x00400200 length: 25
0x00400b6d length: 25
0x00400b86 length: 25
0x004009ec length: 25
0x00400b9f length: 25
TRN CTL:: seq: 0x01e7 chd: 0x0011 ctl: 0x0014 inc: 0x00000000 nfb: 0x0000
mgc: 0x8002 xts: 0x0068 flg: 0x0001 opt: 2147483646 (0x7ffffffe)
uba: 0x00400bb1.01e7.08 scn: 0x0000.28a95b79
Version: 0x01
FREE BLOCK POOL::
uba: 0x00000000.01e7.07 ext: 0xb spc: 0x1d0
uba: 0x00000000.01e5.0a ext: 0x9 spc: 0x38a
uba: 0x00000000.01b0.01 ext: 0x4 spc: 0x724
uba: 0x00000000.0066.07 ext: 0xa spc: 0x514
uba: 0x00000000.0000.00 ext: 0x0 spc: 0x0
TRN TBL:请大家帮忙分析一下。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货