标签云
asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 kfed MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-01110 ORA-01555 ORA-01578 ORA-08103 ORA-600 2131 ORA-600 2662 ORA-600 2663 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-600 KCLCHKBLK_4 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 Oracle 恢复 ORACLE恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (102)
- 数据库 (1,683)
- DB2 (22)
- MySQL (73)
- Oracle (1,545)
- Data Guard (52)
- EXADATA (8)
- GoldenGate (24)
- ORA-xxxxx (159)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (15)
- ORACLE 21C (3)
- Oracle 23ai (7)
- Oracle ASM (68)
- Oracle Bug (8)
- Oracle RAC (53)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (28)
- Oracle备份恢复 (565)
- Oracle安装升级 (92)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (79)
- PostgreSQL (18)
- PostgreSQL恢复 (6)
- SQL Server (27)
- SQL Server恢复 (8)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (37)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (20)
-
最近发表
- ORA-15411: Failure groups in disk group DATA have different number of disks.
- 断电引起的ORA-08102: 未找到索引关键字, 对象号 39故障处理
- ORA-00227: corrupt block detected in control file
- 手工删除19c rac
- 解决oracle数据文件路径有回车故障
- .wstop扩展名勒索数据库恢复
- Oracle Recovery Tools工具一键解决ORA-00376 ORA-01110故障(文件offline)
- OGG-02771 Input trail file format RELEASE 19.1 is different from previous trail file form at RELEASE 11.2.
- OGG-02246 Source redo compatibility level 19.0.0 requires trail FORMAT 12.2 or higher
- GoldenGate 19安装和打patch
- dd破坏asm磁盘头恢复
- 删除asmlib磁盘导致磁盘组故障恢复
- Kylin Linux 安装19c
- ORA-600 krse_arc_complete.4
- Oracle 19c 202410补丁(RUs+OJVM)
- ntfs MFT损坏(ntfs文件系统故障)导致oracle异常恢复
- .mkp扩展名oracle数据文件加密恢复
- 清空redo,导致ORA-27048: skgfifi: file header information is invalid
- A_H_README_TO_RECOVER勒索恢复
- 通过alert日志分析客户自行对一个数据库恢复的来龙去脉和点评
标签归档:library cache: mutex X
awr创建snapshot等待library cache: mutex X
客户一个11.2.0.4的库,在准备收集awr的时候发现没有snap id
人工创建snapshot发现hang住了
查询该会话等待事件为:library cache: mutex X,查看以前mmon的子进程m000/1的trace信息
Trace file /u01/app/oracle/diag/rdbms/xff/xff/trace/xff_m000_6241.trc Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1 System name: Linux Node name: HIS Release: 5.4.17-2102.201.3.el7uek.x86_64 Version: #2 SMP Fri Apr 23 09:05:55 PDT 2021 Machine: x86_64 VM name: VMWare Version: 6 Instance name: xff Redo thread mounted by this instance: 1 Oracle process number: 5714 Unix process pid: 6241, image: oracle@HIS (M000) *** 2024-06-19 11:44:39.483 *** SESSION ID:(8709.38013) 2024-06-19 11:44:39.483 *** CLIENT ID:() 2024-06-19 11:44:39.483 *** SERVICE NAME:(SYS$BACKGROUND) 2024-06-19 11:44:39.483 *** MODULE NAME:(MMON_SLAVE) 2024-06-19 11:44:39.483 *** ACTION NAME:(Auto-Flush Slave Action) 2024-06-19 11:44:39.483 DDE rules only execution for: ORA 12751 ----- START Event Driven Actions Dump ---- ---- END Event Driven Actions Dump ---- ----- START DDE Actions Dump ----- Executing SYNC actions Executing ASYNC actions ----- START DDE Action: 'ORA_12751_DUMP' (Sync) ----- Runtime exceeded 900 seconds Time limit violation detected at: ksedsts()+465<-kspol_12751_dump()+145<-dbgdaExecuteAction()+1065<-dbgerRunAction()+109<-dbgerRunActions() +4134<-dbgexPhaseII()+1873<-dbgexProcessError()+2680<-dbgeExecuteForError()+88<-dbgePostErrorKGE()+2136<- dbkePostKGE_kgsf()+71<-kgeselv()+276<-kgesecl0()+139<-kgxWait()+1412<-kgxExclusive()+447<- kglGetMutex()+140<-kglGetHandleReference()+69<-kglic0()+319<-kksIterCursorStat()+330<-kewrrtsq_rank_topsql() +240<-kewrbtsq_build_topsql()+128<-kewrftsq_flush_topsql()+679<-kewrft_flush_table()+397<- kewrftec_flush_table_ehdlcx()+766<-kewrfat_flush_all_tables()+1406<-kewrfos_flush_onesnap()+170 <-kewrfsc_flush_snapshot_c()+623<-kewrafs_auto_flush_slave()+769<-kebm_slave_main()+586<-ksvrdp()+1766 <-opirip()+674<-opidrv()+603<-sou2o()+103<-opimai_real()+250<-ssthrdmain()+265<-main()+201 <-__libc_start_main()+245 Current Wait Stack: 0: waiting for 'library cache: mutex X' idn=0x644e2de0, value=0xf3a00000000, where=0x7c wait_id=1189 seq_num=1190 snap_id=1 wait times: snap=3 min 0 sec, exc=3 min 0 sec, total=3 min 0 sec wait times: max=infinite, heur=15 min 3 sec wait counts: calls=16376 os=16376 in_wait=1 iflags=0x15b2 There is at least one session blocking this session. Dumping 1 direct blocker(s): inst: 1, sid: 3898, ser: 47299 Dumping final blocker: inst: 1, sid: 3898, ser: 47299 Wait State: fixed_waits=0 flags=0x22 boundary=(nil)/-1 Session Wait History: elapsed time of 0.000016 sec since current wait 0: waited for 'library cache: mutex X' idn=0x644e2de0, value=0xf3a00000000, where=0x7c wait_id=1188 seq_num=1189 snap_id=1 wait times: snap=12 min 2 sec, exc=12 min 2 sec, total=12 min 2 sec wait times: max=infinite wait counts: calls=65535 os=65535 occurred after 0.327543 sec of elapsed time 1: waited for 'db file sequential read' file#=0x2, block#=0x1a5b, blocks=0x1 wait_id=1187 seq_num=1188 snap_id=1 wait times: snap=0.000420 sec, exc=0.000420 sec, total=0.000420 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000251 sec of elapsed time 2: waited for 'db file sequential read' file#=0x1, block#=0x82e6, blocks=0x1 wait_id=1186 seq_num=1187 snap_id=1 wait times: snap=0.000429 sec, exc=0.000429 sec, total=0.000429 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.001085 sec of elapsed time 3: waited for 'db file sequential read' file#=0x2, block#=0x11344, blocks=0x1 wait_id=1185 seq_num=1186 snap_id=1 wait times: snap=0.000356 sec, exc=0.000356 sec, total=0.000356 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000008 sec of elapsed time 4: waited for 'db file sequential read' file#=0x2, block#=0x19eb, blocks=0x1 wait_id=1184 seq_num=1185 snap_id=1 wait times: snap=0.000397 sec, exc=0.000397 sec, total=0.000397 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000044 sec of elapsed time 5: waited for 'db file sequential read' file#=0x2, block#=0xb1659, blocks=0x1 wait_id=1183 seq_num=1184 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.000010 sec of elapsed time 6: waited for 'db file sequential read' file#=0x2, block#=0xb1658, blocks=0x1 wait_id=1182 seq_num=1183 snap_id=1 wait times: snap=0.000453 sec, exc=0.000453 sec, total=0.000453 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000009 sec of elapsed time 7: waited for 'db file sequential read' file#=0x2, block#=0x19e1, blocks=0x1 wait_id=1181 seq_num=1182 snap_id=1 wait times: snap=0.000388 sec, exc=0.000388 sec, total=0.000388 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000017 sec of elapsed time 8: waited for 'db file sequential read' file#=0x2, block#=0x19e2, blocks=0x1 wait_id=1180 seq_num=1181 snap_id=1 wait times: snap=0.000415 sec, exc=0.000415 sec, total=0.000415 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.004826 sec of elapsed time 9: waited for 'db file sequential read' file#=0x2, block#=0x2ffc0c, blocks=0x1 wait_id=1179 seq_num=1180 snap_id=1 wait times: snap=0.000404 sec, exc=0.000404 sec, total=0.000404 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000007 sec of elapsed time Sampled Session History of session 8709 serial 38013 --------------------------------------------------- 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 --------------------------------------------------- [118 samples, 11:42:39 - 11:44:39] waited for 'library cache: mutex X', seq_num: 1190 p1: 'idn'=0x644e2de0 p2: 'value'=0xf3a00000000 p3: 'where'=0x7c time_waited: >= 120 sec (still in wait) [3 samples, 11:42:39 - 11:42:38] idle wait at each sample --------------------------------------------------- Sampled Session History Summary: longest_non_idle_wait: 'library cache: mutex X' [118 samples, 11:42:39 - 11:44:39] time_waited: >= 120 sec (still in wait) --------------------------------------------------- ----- END DDE Action: 'ORA_12751_DUMP' (SUCCESS, 8 csec) ----- ----- END DDE Actions Dump (total 8 csec) ----- KGX cleanup... KGX Atomic Operation Log 0x1de44da670 Mutex 0x1d113cf7c8(8709, 0) idn 2de0 oper EXCL(6) Library Cache uid 8709 efd 7 whr 49 slp 0 oper=0 pt1=(nil) pt2=(nil) pt3=(nil) pt4=(nil) pt5=(nil) ub4=0 KGX cleanup... KGX Atomic Operation Log 0x1de44da6c8 Mutex 0x1de9468550(3898, 0) idn 644e2de0 oper GET_EXCL(5) Library Cache uid 8709 efd 7 whr 124 slp 16376 oper=0 pt1=0x1de9468410 pt2=(nil) pt3=(nil) pt4=(nil) pt5=(nil) ub4=0 *** KEWRAFM1: Error=12751 encountered by kewrfteh *** KEWRAFS: Error=12751 encountered by Auto Flush Slave. KEBM: MMON slave action policy violation. kewrmafsa_; viol=1; err=12751
一般来说类似这样的系统自动任务被阻塞很可能是由于那种bug导致,找到相关mos文档: library cache: mutex x waits during AWR Flush High Cursor Scan (Doc ID 2382741.1),确认为:Bug 19294556 AWR Flush Waiting For Cursor Scan, Library Cache : Mutex X,目前没有好的workaround,而且在11.2.0.4基础版上没有对应的patch