ORA-00600 [ktugnb:clschk_kcbnew_14]诊断

1. 故障说明

某个二级系统的历史库经常告警文件系统满,检查数据库alert里主要是如下错误

Mon Feb 20 06:33:02 2017
Errors in file /oracle/diag/rdbms/xxxxxx/xxxxxx2/trace/xxxxxx2_ora_6449.trc  (incident=1059057):
ORA-00600: , : [ktugnb:clschk_kcbnew_14], [0], [1306], [4], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Mon Feb 20 06:35:19 2017
Sweep [inc][1059057]: completed

每个trc文件都比较大,将近360M

$ ls -l /oracle/diag/rdbms/xxxxxx/xxxxxx2/trace/xxxxxx2_ora_6449.trc
-rw-r----- 1 oracle oinstall 368950753 Feb 20 06:35 /oracle/diag/rdbms/xxxxxx/xxxxxx2/trace/xxxxxx2_ora_6449.trc

2. 检查trc文件

观察trc文件,没有发现processstate dump、systemstate dump或进程的error stack。

*** 2017-02-20 06:33:02.164
*** SESSION ID:(8679.41051) 2017-02-20 06:33:02.164
*** CLIENT ID:() 2017-02-20 06:33:02.164
*** SERVICE NAME:(xxxxxx_intf) 2017-02-20 06:33:02.164
*** MODULE NAME:(oracle@bssyc01 (TNS V1-V3)) 2017-02-20 06:33:02.164
*** ACTION NAME:() 2017-02-20 06:33:02.164
 
DDE: Problem Key 'ORA 600 [ktugnb:clschk_kcbnew_14]' was flood controlled (0x6) (incident: 1059057)
ORA-00600: 内部错误代码, 参数: [ktugnb:clschk_kcbnew_14], [0], [1306], [4], [], [], [], [], [], [], [], []
BH (0x867ac8bd8) file#: 512 rdba: 0x80219ac8 (512/2202312) class: 7 ba: 0x866eae000
  set: 53 pool: 3 bsz: 8192 bsi: 0 sflg: 1 pwc: 0,25
  dbwrid: 1 obj: -1 objn: 0 tsn: 5 afn: 512 hint: f
  hash: [0xf1068a9c0,0xf1068a9c0] lru: [0x4a7ad7ee8,0x9c77c9b28]
  lru-flags: on_auxiliary_list
  ckptq: [NULL] fileq: [NULL] objq: [0x4d7926ad0,0x3175b7a70] objaq: [0x1c7ac36e0,0x9c77c9b60]
  st: SCURRENT md: NULL fpin: 'ktewh90: kteopshrink' tch: 1 atm: 2469056213,3134031615
  flags: affinity_lock
  LRBA: [0x0.0.0] LSCN: [0x0.0] HSCN: [0xffff.ffffffff] HSUB: [65535]

在trc中搜索”DUMP REDO”和”END OF REDO DUMP”,发现整个trc文件完全就是在做dump redo

DUMP REDO
 Opcodes *.*
 DBAs (file#, block#):
 (512, 2202312) .
 SCNs: scn: 0x0000.00000000 thru scn: 0xffff.ffffffff
 **NOTE: Only Dumping Redo less then 12 hours**
 Times: 02/19/2017 18:33:02 thru eternity
Initial buffer sizes: read 1024K, overflow 832K, change 805K
 Thread 1 low checkpoint scn: 0x0d51.155eb5c2
 Thread 2 low checkpoint scn: 0x0d51.646e7a48
 Thread 3 low checkpoint scn: 0x0d51.5ea2aca1
 Thread 4 low checkpoint scn: 0x0d51.020d3a8b

3.诊断数据文件、数据块和数据字典

从以上信息来看,感觉不像是坏块造成的问题。使用dbv确认下
检查rdba: 0x80219ac8 (512/2202312),问题数据块是file 512,block 2202312

SQL> set linesize 180 
SQL> column owner format a15
SQL> column segment_type format a20
SQL> column segment_name format a30
SQL> column PARTITION_NAME format a30
SQL> column tablespace_name format a20
SQL> select owner, segment_type, segment_name, PARTITION_NAME, tablespace_name 
  2  from dba_extents
  3  where file_id = 512 and 2202312 between block_id and block_id+blocks-1;

OWNER  SEGMENT_TYPE SEGMENT_NAME            PARTITION_NAME TABLESPACE_NAME
------ ------------ ----------------------- -------------- --------------------
SYS    TYPE2 UNDO   _SYSSMU645_3190730853$                 UNDOTBS2

检查dba_extents,是个UNDO回滚段上的块。

SQL> column name format a60
SQL> set linesize 180
SQL> select name, bytes/1024/1024 from v$datafile where file# = 512;

NAME                                                         BYTES/1024/1024
------------------------------------------------------------ ---------------
/oradata05/xxxxxx/undotbs021.dbf                                       30720

dbv检查文件

$ dbv file=/oradata05/xxxxxx/undotbs021.dbf blocksize=8192

DBVERIFY: Release 11.2.0.4.0 - Production on Mon Feb 20 08:54:56 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

DBVERIFY - Verification starting : FILE = /oradata05/xxxxxx/undotbs021.dbf


DBVERIFY - Verification complete

Total Pages Examined         : 3932160
Total Pages Processed (Data) : 0
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 3932159
Total Pages Processed (Seg)  : 26
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 1
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 1946904664 (3409.1946904664)

dbv没有发现问题,hcheck2也没有发现严重的数据字典问题。

SQL> @hcheck2.sql

Package created.

No errors.

Package body created.

No errors.
HCheck Version 8i-11/2.00

Problem:  Table with Dropped Func Index  - Bug:1805146 / Note:148740.1
Table=SOLYG.OO_ROLE_BAK
Table=SOLYG.BIN$RqXkSWYTvMHgUyJ25IRlug==$0

Problem:  SEG$ bad LISTS/GROUPS (==1) - See Tar:2470806.1
May be Ok for LOBSEGMENT/SECUREFILE in release 11gR1+
Bad SEG$ lists/groups : TS#=1 RFILE#=2 BLK#=26585 TYPE#=8 Lists=2 Groups=1
Bad SEG$ lists/groups : TS#=1 RFILE#=2 BLK#=26769 TYPE#=8 Lists=2 Groups=1
Bad SEG$ lists/groups : TS#=1 RFILE#=2 BLK#=26841 TYPE#=8 Lists=2 Groups=1
Bad SEG$ lists/groups : TS#=1 RFILE#=2 BLK#=28177 TYPE#=8 Lists=2 Groups=1
Bad SEG$ lists/groups : TS#=1 RFILE#=2 BLK#=28217 TYPE#=8 Lists=2 Groups=1
Bad SEG$ lists/groups : TS#=1 RFILE#=2 BLK#=30985 TYPE#=8 Lists=2 Groups=1

Warning: Poor Storage Clauses (see Note:50380.1)
Segment                                           Next      Exts   Pct MaxExtents
TABLE PARTITION INTFNJ.C2B_CHARGE_INFO_DOM        4194304   3726   0   2147483645
LOB PARTITION INTFNJ.SYS_LOB0000116925C00002$$    4194304   23032  0   2147483645
TYPE2 UNDO SYS._SYSSMU938_4231872312$             65536     3238   0   32765
TYPE2 UNDO SYS._SYSSMU937_4041523993$             65536     3062   0   32765
TYPE2 UNDO SYS._SYSSMU936_1221781582$             65536     3332   0   32765
TYPE2 UNDO SYS._SYSSMU935_3146848768$             65536     3291   0   32765
TYPE2 UNDO SYS._SYSSMU934_1866944110$             65536     4227   0   32765
TYPE2 UNDO SYS._SYSSMU933_1024713810$             65536     4878   0   32765
TYPE2 UNDO SYS._SYSSMU931_2810395666$             65536     4111   0   32765
TYPE2 UNDO SYS._SYSSMU930_3908463496$             65536     4142   0   32765
TYPE2 UNDO SYS._SYSSMU929_1585153536$             65536     4979   0   32765
TYPE2 UNDO SYS._SYSSMU927_3170835708$             65536     4637   0   32765
TYPE2 UNDO SYS._SYSSMU926_3723058367$             65536     3177   0   32765
TYPE2 UNDO SYS._SYSSMU925_3291508999$             65536     3051   0   32765
TYPE2 UNDO SYS._SYSSMU924_1596601559$             65536     3134   0   32765
TYPE2 UNDO SYS._SYSSMU923_1667892740$             65536     3774   0   32765
TYPE2 UNDO SYS._SYSSMU922_1849719633$             65536     4779   0   32765
TYPE2 UNDO SYS._SYSSMU921_2192954016$             65536     4139   0   32765
TYPE2 UNDO SYS._SYSSMU920_2725127985$             65536     4223   0   32765
TYPE2 UNDO SYS._SYSSMU918_3573760439$             65536     3244   0   32765
TYPE2 UNDO SYS._SYSSMU917_3379111523$             65536     3287   0   32765
TYPE2 UNDO SYS._SYSSMU916_3515060890$             65536     3749   0   32765
TYPE2 UNDO SYS._SYSSMU915_101131120$              65536     3220   0   32765
TYPE2 UNDO SYS._SYSSMU907_1775234225$             65536     3328   0   32765
TYPE2 UNDO SYS._SYSSMU906_3848693682$             65536     3031   0   32765
TYPE2 UNDO SYS._SYSSMU905_1886865273$             65536     3145   0   32765
TYPE2 UNDO SYS._SYSSMU904_3470903090$             65536     3464   0   32765
TYPE2 UNDO SYS._SYSSMU903_1952562153$             65536     4682   0   32765
TYPE2 UNDO SYS._SYSSMU902_2058577437$             65536     4498   0   32765
TYPE2 UNDO SYS._SYSSMU901_2344113227$             65536     4819   0   32765
TYPE2 UNDO SYS._SYSSMU900_3528337659$             65536     4191   0   32765
TYPE2 UNDO SYS._SYSSMU899_846588242$              65536     3831   0   32765
TYPE2 UNDO SYS._SYSSMU898_704708852$              65536     4559   0   32765
TYPE2 UNDO SYS._SYSSMU897_3636130941$             65536     4840   0   32765
TYPE2 UNDO SYS._SYSSMU895_204505663$              65536     3215   0   32765
TYPE2 UNDO SYS._SYSSMU894_197081962$              65536     3527   0   32765
TYPE2 UNDO SYS._SYSSMU893_2125226544$             65536     3374   0   32765
TYPE2 UNDO SYS._SYSSMU892_1153541173$             65536     4263   0   32765
TYPE2 UNDO SYS._SYSSMU891_2342709071$             65536     4485   0   32765
TYPE2 UNDO SYS._SYSSMU890_1583891555$             65536     4946   0   32765
TYPE2 UNDO SYS._SYSSMU889_2632768257$             65536     4176   0   32765
TYPE2 UNDO SYS._SYSSMU888_3906323271$             65536     3155   0   32765
TYPE2 UNDO SYS._SYSSMU883_1996112263$             65536     3222   0   32765
TYPE2 UNDO SYS._SYSSMU876_949884757$              65536     3090   0   32765
TYPE2 UNDO SYS._SYSSMU875_294084533$              65536     3037   0   32765
TYPE2 UNDO SYS._SYSSMU874_2807643372$             65536     3324   0   32765
TYPE2 UNDO SYS._SYSSMU873_2664038720$             65536     3407   0   32765
TYPE2 UNDO SYS._SYSSMU872_2621922310$             65536     4513   0   32765
TYPE2 UNDO SYS._SYSSMU871_440471646$              65536     4816   0   32765
TYPE2 UNDO SYS._SYSSMU870_3435505414$             65536     4564   0   32765
TYPE2 UNDO SYS._SYSSMU869_3019833272$             65536     4180   0   32765
TYPE2 UNDO SYS._SYSSMU868_4001372436$             65536     3968   0   32765
TYPE2 UNDO SYS._SYSSMU866_2707579196$             65536     4903   0   32765
TYPE2 UNDO SYS._SYSSMU865_3679288437$             65536     3958   0   32765
TYPE2 UNDO SYS._SYSSMU864_582271685$              65536     3409   0   32765
TYPE2 UNDO SYS._SYSSMU863_2321844127$             65536     3719   0   32765
TYPE2 UNDO SYS._SYSSMU862_100644828$              65536     3573   0   32765
TYPE2 UNDO SYS._SYSSMU861_3830381120$             65536     4041   0   32765
TYPE2 UNDO SYS._SYSSMU860_3635191058$             65536     4768   0   32765
TYPE2 UNDO SYS._SYSSMU859_2027211846$             65536     4877   0   32765
TYPE2 UNDO SYS._SYSSMU858_249968420$              65536     4148   0   32765
TYPE2 UNDO SYS._SYSSMU854_3544022160$             65536     3940   0   32765
TYPE2 UNDO SYS._SYSSMU853_1746844385$             65536     3382   0   32765
TYPE2 UNDO SYS._SYSSMU852_92342363$               65536     3226   0   32765
TYPE2 UNDO SYS._SYSSMU845_1221568229$             65536     3417   0   32765
TYPE2 UNDO SYS._SYSSMU843_2443249245$             65536     3230   0   32765
TYPE2 UNDO SYS._SYSSMU842_2906526353$             65536     3347   0   32765
TYPE2 UNDO SYS._SYSSMU841_3016203828$             65536     4519   0   32765
TYPE2 UNDO SYS._SYSSMU840_4062347684$             65536     4373   0   32765
TYPE2 UNDO SYS._SYSSMU839_1542798956$             65536     4641   0   32765
TYPE2 UNDO SYS._SYSSMU838_1208375665$             65536     4122   0   32765
TYPE2 UNDO SYS._SYSSMU837_1081106272$             65536     4024   0   32765
TYPE2 UNDO SYS._SYSSMU836_2314529135$             65536     5026   0   32765
TYPE2 UNDO SYS._SYSSMU835_311786953$              65536     4848   0   32765
TYPE2 UNDO SYS._SYSSMU834_1141185982$             65536     4920   0   32765
TYPE2 UNDO SYS._SYSSMU833_2086282319$             65536     3356   0   32765
TYPE2 UNDO SYS._SYSSMU832_586346200$              65536     3488   0   32765
TYPE2 UNDO SYS._SYSSMU831_2644752394$             65536     3396   0   32765
TYPE2 UNDO SYS._SYSSMU830_2010129040$             65536     4298   0   32765
TYPE2 UNDO SYS._SYSSMU721_2968429371$             65536     3253   0   32765
TYPE2 UNDO SYS._SYSSMU720_1314530767$             65536     3072   0   32765
TYPE2 UNDO SYS._SYSSMU718_146005813$              65536     3487   0   32765
TYPE2 UNDO SYS._SYSSMU717_140527621$              65536     3036   0   32765
TYPE2 UNDO SYS._SYSSMU822_652240805$              65536     3504   0   32765
TYPE2 UNDO SYS._SYSSMU821_3664988286$             65536     3226   0   32765
TYPE2 UNDO SYS._SYSSMU963_3916926274$             65536     4749   0   32765
TYPE2 UNDO SYS._SYSSMU960_1546696045$             65536     4961   0   32765
TYPE2 UNDO SYS._SYSSMU958_3373097762$             65536     4751   0   32765
TYPE2 UNDO SYS._SYSSMU957_779883595$              65536     3351   0   32765
TYPE2 UNDO SYS._SYSSMU955_1107697981$             65536     3344   0   32765
TYPE2 UNDO SYS._SYSSMU951_2172604146$             65536     4278   0   32765
TYPE2 UNDO SYS._SYSSMU812_1492684160$             65536     3107   0   32765
TYPE2 UNDO SYS._SYSSMU690_1242221439$             65536     3268   0   32765
TYPE2 UNDO SYS._SYSSMU687_3405220771$             65536     3297   0   32765
TYPE2 UNDO SYS._SYSSMU686_4019061268$             65536     4494   0   32765
TYPE2 UNDO SYS._SYSSMU685_845122282$              65536     4977   0   32765
TYPE2 UNDO SYS._SYSSMU684_2042847591$             65536     4691   0   32765
TYPE2 UNDO SYS._SYSSMU683_2817064289$             65536     3893   0   32765
TYPE2 UNDO SYS._SYSSMU682_2533401056$             65536     4007   0   32765
TYPE2 UNDO SYS._SYSSMU681_537367350$              65536     5087   0   32765
TYPE2 UNDO SYS._SYSSMU680_3618789411$             65536     4015   0   32765
TYPE2 UNDO SYS._SYSSMU679_3277798746$             65536     4744   0   32765
TYPE2 UNDO SYS._SYSSMU678_1939303496$             65536     3391   0   32765
TYPE2 UNDO SYS._SYSSMU677_1907565566$             65536     3499   0   32765
TYPE2 UNDO SYS._SYSSMU676_1984137816$             65536     3353   0   32765
TYPE2 UNDO SYS._SYSSMU675_841928499$              65536     4034   0   32765
TYPE2 UNDO SYS._SYSSMU674_699725039$              65536     4803   0   32765
TYPE2 UNDO SYS._SYSSMU673_2645343810$             65536     4603   0   32765
TYPE2 UNDO SYS._SYSSMU672_2893885477$             65536     4370   0   32765
TYPE2 UNDO SYS._SYSSMU671_3006873959$             65536     3030   0   32765
TYPE2 UNDO SYS._SYSSMU670_1339746259$             65536     3063   0   32765
TYPE2 UNDO SYS._SYSSMU669_3144845453$             65536     3068   0   32765
TYPE2 UNDO SYS._SYSSMU667_2631341139$             65536     3033   0   32765
TYPE2 UNDO SYS._SYSSMU666_2940587554$             65536     3139   0   32765
TYPE2 UNDO SYS._SYSSMU659_1372182011$             65536     3531   0   32765
TYPE2 UNDO SYS._SYSSMU647_3348747292$             65536     3573   0   32765
TYPE2 UNDO SYS._SYSSMU646_419876432$              65536     3554   0   32765
TYPE2 UNDO SYS._SYSSMU591_1053474162$             65536     4882   0   32765
TYPE2 UNDO SYS._SYSSMU590_2952548938$             65536     4266   0   32765
TYPE2 UNDO SYS._SYSSMU589_1059150673$             65536     3989   0   32765
TYPE2 UNDO SYS._SYSSMU588_791066902$              65536     4580   0   32765
TYPE2 UNDO SYS._SYSSMU587_1206424187$             65536     5118   0   32765
TYPE2 UNDO SYS._SYSSMU586_2893738863$             65536     4866   0   32765
TYPE2 UNDO SYS._SYSSMU585_3395283430$             65536     3411   0   32765
TYPE2 UNDO SYS._SYSSMU584_3523634783$             65536     3493   0   32765
TYPE2 UNDO SYS._SYSSMU583_1423446262$             65536     3437   0   32765
TYPE2 UNDO SYS._SYSSMU582_2795545658$             65536     4213   0   32765
TYPE2 UNDO SYS._SYSSMU581_1508811407$             65536     4940   0   32765
TYPE2 UNDO SYS._SYSSMU580_980330471$              65536     4731   0   32765
TYPE2 UNDO SYS._SYSSMU579_809160346$              65536     3678   0   32765
TYPE2 UNDO SYS._SYSSMU578_801780972$              65536     3065   0   32765
TYPE2 UNDO SYS._SYSSMU577_1297071939$             65536     3091   0   32765
TYPE2 UNDO SYS._SYSSMU576_1788000116$             65536     3248   0   32765
TYPE2 UNDO SYS._SYSSMU575_898229308$              65536     3466   0   32765
TYPE2 UNDO SYS._SYSSMU574_408284076$              65536     3461   0   32765
TYPE2 UNDO SYS._SYSSMU573_2591816604$             65536     3065   0   32765
TYPE2 UNDO SYS._SYSSMU980_2221437149$             65536     3004   0   32765
TYPE2 UNDO SYS._SYSSMU946_503850718$              65536     3283   0   32765
TYPE2 UNDO SYS._SYSSMU827_3112501852$             65536     4028   0   32765
TYPE2 UNDO SYS._SYSSMU20_3674116211$              65536     3050   0   32765
TYPE2 UNDO SYS._SYSSMU17_1385764193$              65536     3806   0   32765
TYPE2 UNDO SYS._SYSSMU16_3958334682$              65536     3256   0   32765
TYPE2 UNDO SYS._SYSSMU15_3859920528$              65536     3146   0   32765
TYPE2 UNDO SYS._SYSSMU969_2483651133$             65536     3258   0   32765
TYPE2 UNDO SYS._SYSSMU966_4067110509$             65536     3124   0   32765
TYPE2 UNDO SYS._SYSSMU965_4068933998$             65536     4542   0   32765
TYPE2 UNDO SYS._SYSSMU964_1651538853$             65536     4224   0   32765
TYPE2 UNDO SYS._SYSSMU962_1063866871$             65536     4064   0   32765
TYPE2 UNDO SYS._SYSSMU961_4285108305$             65536     4063   0   32765
TYPE2 UNDO SYS._SYSSMU956_3136563893$             65536     3531   0   32765
TYPE2 UNDO SYS._SYSSMU954_4228453703$             65536     4143   0   32765
TYPE2 UNDO SYS._SYSSMU953_1501298653$             65536     4687   0   32765
TYPE2 UNDO SYS._SYSSMU952_3671889491$             65536     4720   0   32765
TYPE2 UNDO SYS._SYSSMU950_2880314546$             65536     3336   0   32765
TYPE2 UNDO SYS._SYSSMU949_237801430$              65536     3203   0   32765
TYPE2 UNDO SYS._SYSSMU979_3314667799$             65536     3027   0   32765
TYPE2 UNDO SYS._SYSSMU978_1744451194$             65536     3924   0   32765
TYPE2 UNDO SYS._SYSSMU977_3800545299$             65536     3369   0   32765
TYPE2 UNDO SYS._SYSSMU945_3508247264$             65536     3152   0   32765

Found 8 potential problems and 159 warnings
Contact Oracle Support with the output
to check if the above needs attention or not

PL/SQL procedure successfully completed.

4.Bug 23328319

从0x80219ac8的BH转储来看,问题可能发生在”st: SCURRENT md: NULL fpin: ‘ktewh90: kteopshrink'”,可能是在做shrink操作。

BH (0x867ac8bd8) file#: 512 rdba: 0x80219ac8 (512/2202312) class: 7 ba: 0x866eae000
  set: 53 pool: 3 bsz: 8192 bsi: 0 sflg: 1 pwc: 0,25
  dbwrid: 1 obj: -1 objn: 0 tsn: 5 afn: 512 hint: f
  hash: [0xf1068a9c0,0xf1068a9c0] lru: [0x4a7ad7ee8,0x9c77c9b28]
  lru-flags: on_auxiliary_list
  ckptq: [NULL] fileq: [NULL] objq: [0x4d7926ad0,0x3175b7a70] objaq: [0x1c7ac36e0,0x9c77c9b60]
  st: SCURRENT md: NULL fpin: 'ktewh90: kteopshrink' tch: 1 atm: 2469056213,3134031615
  flags: affinity_lock
  LRBA: [0x0.0.0] LSCN: [0x0.0] HSCN: [0xffff.ffffffff] HSUB: [65535]

在MOS上搜索”ktewh90: kteopshrink”,发现了如下几个BUG:
Bug 25208060 : ORA-00600 [KTUGNB:CLSCHK_KCBNEW_14]
Bug 18521169 : ORA-600[KTUGNB:CLSCHK_KCBNEW_14]
Bug 23328319 : ORA-600 KTUGNB:CLSCHK_KCBNEW_14
这些BUG,暂时没有workround和fix

5.建议

既然没有解决这个bug的办法,只有想其它办法了:

  • 把自动redo dump给禁用了,设置如下Event:
  • SQL> alter system set events '10555 trace name context forever, level 1';
    SQL> alter system set events '10736 trace name context forever, level 2';
    
  • 刷新buffer cache
  • 因为从lru-flags: on_auxiliary_list看,可能问题发生在buffer cache的辅助链上。

    SQL> alter system flush buffer_cache;
    

    从同事的信息来看,这个问题他前面已经看到了,刷buffer_cache无法解决问题。
    设置了10555和10736这两个Event后,trc的生成大小从360M降到几十K,大大缓解了/oracle文件系统的压力。
    从每次ORA-00600 [ktugnb:clschk_kcbnew_14]涉及的数据块来看,基本都是UNDO数据块,新建UNDO表空间切换,再看情况。

    关于紫砂壶

    感悟技术人生
    此条目发表在Oracle故障诊断分类目录,贴了标签。将固定链接加入收藏夹。