小麦苗微信公众号文章链接地址

原创

小麦苗123 2021-08-19 14:13:42 ©著作权

文章标签 等待事件 oracle 2d 3c 5e 文章分类 Oracle 数据库

©著作权归作者所有：来自51CTO博客作者小麦苗123的原创作品，请联系作者获取转载授权，否则将追究法律责任

小麦苗的微信公众号文章链接地址

201609

发布日期	文章标题	链接地址
2016-09-30
2016-09-29
2016-09-28
2016-09-27
2016-09-26
2016-09-25
2016-09-24
2016-09-23
2016-09-22
2016-09-20
2016-09-19
2016-09-18
2016-09-17
2016-09-16
2016-09-15
2016-09-29
2016-09-14
2016-09-13
2016-09-12
2016-09-11
2016-09-10
2016-09-09
2016-09-08
2016-09-07
2016-09-06
2016-09-05
2016-09-04
2016-09-03
2016-09-02	【故障处理】队列等待之enq: TX - row lock contention	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771450&idx=1&sn=6afa7bb73478fe056e8d68977d54041e&scene=21#wechat_redirect
2016-09-01	【等待事件】User I/O类等待事件（2.10）--所有User I/O类等待事件总结	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771447&idx=1&sn=22ae192f0d8a161f65514339ad763985&scene=21#wechat_redirect

201608

发布日期	文章标题	链接地址
2016-08-31	【等待事件】User I/O类等待事件（2.9）--local write wait	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771443&idx=1&sn=02b4ad5ca03052013b69ae6bcb7e3487&scene=21#wechat_redirect
2016-08-30	【等待事件】User I/O类等待事件（2.8）--read by other session	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771439&idx=1&sn=b3c01eed444cd6e597a63a3ed0687768&scene=21#wechat_redirect
2016-08-29	【等待事件】User I/O类等待事件（2.7）--direct path read/write temp	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771429&idx=1&sn=50b5684e699165a34087db88e07edb34&scene=21#wechat_redirect
2016-08-28	【索引】Oracle之不可见索引和虚拟索引的比对	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771428&idx=1&sn=832bdca6ee41334e51cab312ba8dedc1&scene=21#wechat_redirect
2016-08-27	【等待事件】User I/O类等待事件（2.6）--direct path write（直接路径写、DRW）	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771420&idx=1&sn=458eb18dc26da94debcea62643d15181&scene=21#wechat_redirect
2016-08-26	【等待事件】User I/O类等待事件（2.5）--direct path read（直接路径读、DPR）	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771416&idx=1&sn=b26c3135584c5b60ce14cc0749ac58a7&scene=21#wechat_redirect
2016-08-25	Oracle之不可见索引	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771415&idx=1&sn=55ddcd89bffb1c30a780bae38243d4ca&scene=21#wechat_redirect
2016-08-24	【故障处理】序列cache值过小导致CPU利用率过高	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771414&idx=1&sn=0cbc454bc7d5a513bbca6083958e2f34&scene=21#wechat_redirect
2016-08-23	OCP如何查看历史成绩（2）	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771411&idx=1&sn=4ffe37479e03b75449a779efc799f89e&scene=21#wechat_redirect
2016-08-22	牵手也可以理解成是握手	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771408&idx=1&sn=9d5ef58ce957a1b88325f8d14cea10df&scene=21#wechat_redirect
2016-08-20	【等待事件】User I/O类等待事件（2.4）--db file single write	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771403&idx=1&sn=054dd852dac5ac8837fa251f0e84332e&scene=21#wechat_redirect
2016-08-19	Oracle索引的监控	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771402&idx=1&sn=ba9e7f63b5e3bb87fb67c33371c7f859&scene=21#wechat_redirect
2016-08-18	Oracle之虚拟索引	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771394&idx=1&sn=3bba494f7e2aabe84b47279c8da55663&scene=21#wechat_redirect
2016-08-17	Oracle中如何判断一个字符串是否含有汉字（2）	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771391&idx=1&sn=1cf3b4b59f2eddc20f43cd3469c7ae3b&scene=21#wechat_redirect
2016-08-16	【等待事件】User I/O类等待事件（2.3）--db file parallel read	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771387&idx=1&sn=0037fb89470d8e6dd5ff72714b18a3b7&scene=21#wechat_redirect
2016-08-15	【等待事件】User I/O类等待事件（2.2）--db file scattered read（数据文件离散读）	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771379&idx=1&sn=5887eee02885000c1d293adfd04ee044&scene=21#wechat_redirect
2016-08-29	【等待事件】User I/O类等待事件（2.7）--direct path read/write temp	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771429&idx=1&sn=50b5684e699165a34087db88e07edb34&scene=21#wechat_redirect
2016-08-14	【等待事件】User I/O类等待事件（2.1）--db file sequential read（数据文件顺序读）	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771376&idx=1&sn=42de046e73190f4e265f81bbb6e3ae00&scene=21#wechat_redirect
2016-08-13	【等待事件】等待事件概述（1）--等待事件的源起和分类	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771373&idx=1&sn=1e55af795aae5f641b2c3cc610814ead&scene=21#wechat_redirect
2016-08-12	【故障处理】ORA-12545: Connect failed because target host	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771370&idx=1&sn=a085c1117fcb82448915d0db584e34e9&scene=21#wechat_redirect
2016-08-11	【故障解决】ORA-06502: PL/SQL: numeric or value error	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771366&idx=1&sn=fa09473e79c04720c07f319fd58961a5&scene=21#wechat_redirect
2016-08-10	DUAL系列	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771363&idx=1&sn=bdc67056cd481e6d3cfd0d5a20d16155&scene=21#wechat_redirect
2016-08-09	Oracle如何删除表中重复记录	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771360&idx=1&sn=9c63d6e266a43576f6574e1a61e4d895&scene=21#wechat_redirect
2016-08-08	哪几种情况不能用上索引？	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771357&idx=1&sn=c1525f8cdac8f8b166153cb8ff75416b&scene=21#wechat_redirect
2016-08-07	《Oracle DBA工作笔记》第二章常用工具和问题分析（3）--expdp/impdp系列问题	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771354&idx=1&sn=dd914ae807d7d5d338a1f6209794cc8a&scene=21#wechat_redirect
2016-08-06	《Oracle DBA工作笔记》第二章常用工具和问题分析（2）--exp/imp系列问题	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771353&idx=1&sn=6af100419c77cdb0ee3d6a8f0c770711&scene=21#wechat_redirect
2016-08-05	《Oracle DBA工作笔记》第二章常用工具和问题分析（1）--删库、orabase、sqlplus	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771352&idx=1&sn=c8db17a63509b32d40dab3e842fb454b&scene=21#wechat_redirect
2016-08-04	【故障处理】分布式事务ORA-01591错误解决	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771345&idx=1&sn=33fa21879317f38f617ea73b7dbae517&scene=21#wechat_redirect
2016-08-03	BBED系列之实践（3.7）-- sys.bootstrap$ 对象的恢复	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771342&idx=1&sn=5f10778463946f7d0a0f2a5c0d74b774&scene=21#wechat_redirect
2016-08-02	BBED系列之实践（3.6）-- SYSTEM文件头损坏的恢复	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771339&idx=1&sn=06ebe88f8ee40e204569ee6dcc5e92f2&scene=21#wechat_redirect
2016-08-01	【故障处理】ORA-19809错误处理	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771336&idx=1&sn=49f11666bf29eaa8fe3bdb24567a0cd4&scene=21#wechat_redirect

201607

发布日期	文章标题
2016-07-31	BBED系列之实践（3.5）--丢失归档文件情况下的恢复(2)	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771333&idx=1&sn=0f40b6c461f129e6d6a2b1cd92c76b79&scene=21#wechat_redirect
2016-07-30	BBED系列之实践（3.5）--丢失归档文件情况下的恢复(1)	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771327&idx=1&sn=ce377e2997c96b93eedcb6d4ebf2d315&scene=21#wechat_redirect
2016-07-29	BBED系列之实践（3.4）--坏块恢复（Rman Blockrecover）	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771322&idx=1&sn=11c6a6aaff00405b23828a9512fc7de1&scene=21#wechat_redirect
2016-07-28	BBED系列之实践（3.3）--使用copy命令从旧数据文件中恢复delete的rows	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771319&idx=1&sn=35079edb30e25e9df1b139eb30cb48de&scene=21#wechat_redirect
2016-07-27	BBED系列之实践（3.2）-- 恢复delete的rows 公众号之原创声明、留言、网页模板和赞赏功能	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771316&idx=1&sn=251a0fa3b1dcfc687c465d4bdfabc0ee&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771316&idx=2&sn=cf49534315b49ffdb62cb959dcc593a0&scene=21#wechat_redirect
2016-07-26	BBED系列之实践（3.1）-- 修改数据块中的内容	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771311&idx=1&sn=fb324fe7e19339677a45d42612a2da6a&scene=21#wechat_redirect
2016-07-25	BBED系列之基本命令（2.4）	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771308&idx=1&sn=5259c8849d953f19c34ac2d5b2a20034&scene=21#wechat_redirect
2016-07-24	BBED系列之基本命令（2.3）	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771305&idx=1&sn=945d097a4c1163bac8cb9ba1d1188b4d&scene=21#wechat_redirect
2016-07-23	BBED系列之基本命令（2.2）	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771301&idx=1&sn=2b89f1254b17d220b66c0af299d5b661&scene=21#wechat_redirect
2016-07-22	BBED系列之基本命令（2.1）	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771294&idx=1&sn=c8ef9a99bc737654b20c2a0b7373b7ea&scene=21#wechat_redirect
2016-07-21	BBED系列之编译安装（1）	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771287&idx=1&sn=d5045206000b3d0bfbd21849778635e6&scene=21#wechat_redirect
2016-07-20	Oracle中如何判断一个字符串是否含有汉字	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771284&idx=1&sn=ab4e725c4d4ad448e245e1668ccac382&scene=21#wechat_redirect
2016-07-19	Oracle如何预估将要创建的索引的大小	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771280&idx=1&sn=1a1524f481f434e1d935216b996f1b5a&scene=21#wechat_redirect
2016-07-18	RMAN脚本中使用替换变量--windows 下rman全备脚本	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771277&idx=1&sn=6b56724770774ad9c116d21f4df6993c&scene=21#wechat_redirect
2016-07-17	IPCS和IPCRM使用	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771274&idx=1&sn=72b2ca5606f800edcec3d0b5c264433b&scene=21#wechat_redirect
2016-07-16	OEM使用总结	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771271&idx=1&sn=1dbc35299cbda68c569d263e9020ae89&scene=21#wechat_redirect
2016-07-15	ASM数据文件和FS之间的各种转换方法（1） ASM数据文件和FS之间的各种转换方法（2） ASM数据文件和FS之间的各种转换方法（3） ASM数据文件和FS之间的各种转换方法（4）	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771257&idx=1&sn=241086695d4a44a6756ab93e895c1191&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771264&idx=2&sn=033bac8c5974885ddd8fc846c22bef89&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771264&idx=3&sn=c3c934351d7eb15827ebe5b6c94eefd5&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771264&idx=4&sn=f22d61318f13809db26bacf5a6ec9017&scene=21#wechat_redirect
2016-07-14	Oracle手动建库常见问题	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771257&idx=1&sn=241086695d4a44a6756ab93e895c1191&scene=21#wechat_redirect
2016-07-13	读书笔记--《Oracle DBA工作笔记》第一章	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771254&idx=1&sn=5ed9d67728e70643efd2f908aeb774b4&scene=21#wechat_redirect
2016-07-12	【故障处理】DBCA建库诡异问题处理--rac环境不能创建rac库 dbca静默建库---故障处理总结健康检查脚本的最新版本V5.5.5	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771251&idx=1&sn=945cffff28b420aa3a5228dd6f9ca0f8&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771251&idx=2&sn=6bf1e0a3cda533c2712adc647d95d09b&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771251&idx=3&sn=43bd0267e62d9ba63380a6f09b85f105&scene=21#wechat_redirect
2016-07-11	SQL优化中索引列使用函数之灵异事件	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771245&idx=1&sn=e02e83a713db790a642da2ab7c4c8563&scene=21#wechat_redirect
2016-07-10	itpub写博客2年了回答Q友批量删除表问题	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771238&idx=1&sn=c1286541fb6da5925fdcd0eff9c6f720&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771238&idx=2&sn=054c1f9d12f4b070fce38db943ded867&scene=21#wechat_redirect
2016-07-09	truncate恢复方法集合 gdul恢复truncate的表	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771230&idx=1&sn=52de5e1bf7cf683ba986e7d98252cd18&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771230&idx=2&sn=7411c0bc07ff85a09aa61ff7d9d9c3c7&scene=21#wechat_redirect
2016-07-08	【DG】物理DG中主库的LNSn、NSS、NSA进程的比较	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771227&idx=1&sn=61cb8cdb05f60a6947c521d988b049bf&scene=21#wechat_redirect
2016-07-07	【故障处理】DBCA建库报错CRS-2566 PRCR-1071 PRCR-1006	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771221&idx=1&sn=43fb4e9b76d981bbd4bef587ae7ac9fc&scene=21#wechat_redirect
2016-07-06	脚本分享-- DBCA静默建库	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771218&idx=1&sn=b12e80767d151f4065a557097e3b3652&scene=21#wechat_redirect
2016-07-05	Oracle OCR的备份与恢复 Oracle OCR的备份与恢复(1) Oracle OCR的备份与恢复(2)--如何修复11.2 Grid权限误操作 Oracle OCR的备份与恢复(3)---实验部分	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771215&idx=1&sn=39959fae41c30090bc3aa3d4e72a79bf&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771215&idx=2&sn=15f2161a469d2b0525b4407cc07d82a6&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771215&idx=3&sn=f73223ced21e5f678b7b389a5583cbaf&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771215&idx=4&sn=baf2d038fd85bee680d42230b2e915eb&scene=21#wechat_redirect
2016-07-04	Oracle回收站及flashback drop 回收站及flashback drop实验部分(1) 回收站及flashback drop实验部分(2) 回收站及flashback drop实验部分(3) 回收站及flashback drop实验部分(4)	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771194&idx=1&sn=81e48a5f29c47709aa899dfce5b6c69e&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771194&idx=2&sn=2cde5baa43507cb1ff17d9f5609a1732&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771194&idx=3&sn=349e6caee7d954fdb79f2c4c4e4bc815&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771194&idx=4&sn=5142c893124af432ec9b15b6fe71f035&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771194&idx=5&sn=e7b9888cfd7ef0b2c59aa9026b8ee672&scene=21#wechat_redirect
2016-07-03	【技巧】如何全文搜索oracle官方文档	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771177&idx=1&sn=5929f2e95be8dbe819e4989df0286a74&scene=21#wechat_redirect

About Me：小麦苗●李华荣

● 本文作者：小麦苗，只专注于数据库的技术，更注重技术的运用

●本文在itpub（http://blog.itpub.net/26736162）和个人微信公众号（xiaomaimiaolhr）上有同步更新，推荐pdf文件阅读或博客园地址阅读

●QQ群：230161599 微信群：私聊

●小麦苗分享的其它资料：http://blog.itpub.net/26736162/viewspace-1624453/

● 联系我请加QQ好友(642808185)，注明添加缘由

长按识别二维码或微信客户端扫描下边的二维码来关注小麦苗的微信公众号：xiaomaimiaolhr,学习最实用的数据库技术。

小麦苗微信公众号文章链接地址_3c

一.1 201609

发布日期	文章标题	链接地址
2016-09-30
2016-09-29
2016-09-28
2016-09-27
2016-09-26
2016-09-25
2016-09-24
2016-09-23
2016-09-22
2016-09-20
2016-09-19
2016-09-18
2016-09-17
2016-09-16
2016-09-15
2016-09-29
2016-09-14
2016-09-13
2016-09-12
2016-09-11
2016-09-10
2016-09-09
2016-09-08
2016-09-07
2016-09-06
2016-09-05
2016-09-04
2016-09-03
2016-09-02	【故障处理】队列等待之enq: TX - row lock contention	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771450&idx=1&sn=6afa7bb73478fe056e8d68977d54041e&scene=21#wechat_redirect
2016-09-01	【等待事件】User I/O类等待事件（2.10）--所有User I/O类等待事件总结	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771447&idx=1&sn=22ae192f0d8a161f65514339ad763985&scene=21#wechat_redirect

一.2 201608

发布日期	文章标题	链接地址
2016-08-31	【等待事件】User I/O类等待事件（2.9）--local write wait	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771443&idx=1&sn=02b4ad5ca03052013b69ae6bcb7e3487&scene=21#wechat_redirect
2016-08-30	【等待事件】User I/O类等待事件（2.8）--read by other session	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771439&idx=1&sn=b3c01eed444cd6e597a63a3ed0687768&scene=21#wechat_redirect
2016-08-29	【等待事件】User I/O类等待事件（2.7）--direct path read/write temp	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771429&idx=1&sn=50b5684e699165a34087db88e07edb34&scene=21#wechat_redirect
2016-08-28	【索引】Oracle之不可见索引和虚拟索引的比对	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771428&idx=1&sn=832bdca6ee41334e51cab312ba8dedc1&scene=21#wechat_redirect
2016-08-27	【等待事件】User I/O类等待事件（2.6）--direct path write（直接路径写、DRW）	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771420&idx=1&sn=458eb18dc26da94debcea62643d15181&scene=21#wechat_redirect
2016-08-26	【等待事件】User I/O类等待事件（2.5）--direct path read（直接路径读、DPR）	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771416&idx=1&sn=b26c3135584c5b60ce14cc0749ac58a7&scene=21#wechat_redirect
2016-08-25	Oracle之不可见索引	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771415&idx=1&sn=55ddcd89bffb1c30a780bae38243d4ca&scene=21#wechat_redirect
2016-08-24	【故障处理】序列cache值过小导致CPU利用率过高	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771414&idx=1&sn=0cbc454bc7d5a513bbca6083958e2f34&scene=21#wechat_redirect
2016-08-23	OCP如何查看历史成绩（2）	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771411&idx=1&sn=4ffe37479e03b75449a779efc799f89e&scene=21#wechat_redirect
2016-08-22	牵手也可以理解成是握手	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771408&idx=1&sn=9d5ef58ce957a1b88325f8d14cea10df&scene=21#wechat_redirect
2016-08-20	【等待事件】User I/O类等待事件（2.4）--db file single write	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771403&idx=1&sn=054dd852dac5ac8837fa251f0e84332e&scene=21#wechat_redirect
2016-08-19	Oracle索引的监控	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771402&idx=1&sn=ba9e7f63b5e3bb87fb67c33371c7f859&scene=21#wechat_redirect
2016-08-18	Oracle之虚拟索引	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771394&idx=1&sn=3bba494f7e2aabe84b47279c8da55663&scene=21#wechat_redirect
2016-08-17	Oracle中如何判断一个字符串是否含有汉字（2）	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771391&idx=1&sn=1cf3b4b59f2eddc20f43cd3469c7ae3b&scene=21#wechat_redirect
2016-08-16	【等待事件】User I/O类等待事件（2.3）--db file parallel read	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771387&idx=1&sn=0037fb89470d8e6dd5ff72714b18a3b7&scene=21#wechat_redirect
2016-08-15	【等待事件】User I/O类等待事件（2.2）--db file scattered read（数据文件离散读）	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771379&idx=1&sn=5887eee02885000c1d293adfd04ee044&scene=21#wechat_redirect
2016-08-29	【等待事件】User I/O类等待事件（2.7）--direct path read/write temp	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771429&idx=1&sn=50b5684e699165a34087db88e07edb34&scene=21#wechat_redirect
2016-08-14	【等待事件】User I/O类等待事件（2.1）--db file sequential read（数据文件顺序读）	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771376&idx=1&sn=42de046e73190f4e265f81bbb6e3ae00&scene=21#wechat_redirect
2016-08-13	【等待事件】等待事件概述（1）--等待事件的源起和分类	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771373&idx=1&sn=1e55af795aae5f641b2c3cc610814ead&scene=21#wechat_redirect
2016-08-12	【故障处理】ORA-12545: Connect failed because target host	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771370&idx=1&sn=a085c1117fcb82448915d0db584e34e9&scene=21#wechat_redirect
2016-08-11	【故障解决】ORA-06502: PL/SQL: numeric or value error	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771366&idx=1&sn=fa09473e79c04720c07f319fd58961a5&scene=21#wechat_redirect
2016-08-10	DUAL系列	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771363&idx=1&sn=bdc67056cd481e6d3cfd0d5a20d16155&scene=21#wechat_redirect
2016-08-09	Oracle如何删除表中重复记录	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771360&idx=1&sn=9c63d6e266a43576f6574e1a61e4d895&scene=21#wechat_redirect
2016-08-08	哪几种情况不能用上索引？	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771357&idx=1&sn=c1525f8cdac8f8b166153cb8ff75416b&scene=21#wechat_redirect
2016-08-07	《Oracle DBA工作笔记》第二章常用工具和问题分析（3）--expdp/impdp系列问题	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771354&idx=1&sn=dd914ae807d7d5d338a1f6209794cc8a&scene=21#wechat_redirect
2016-08-06	《Oracle DBA工作笔记》第二章常用工具和问题分析（2）--exp/imp系列问题	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771353&idx=1&sn=6af100419c77cdb0ee3d6a8f0c770711&scene=21#wechat_redirect
2016-08-05	《Oracle DBA工作笔记》第二章常用工具和问题分析（1）--删库、orabase、sqlplus	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771352&idx=1&sn=c8db17a63509b32d40dab3e842fb454b&scene=21#wechat_redirect
2016-08-04	【故障处理】分布式事务ORA-01591错误解决	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771345&idx=1&sn=33fa21879317f38f617ea73b7dbae517&scene=21#wechat_redirect
2016-08-03	BBED系列之实践（3.7）-- sys.bootstrap$ 对象的恢复	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771342&idx=1&sn=5f10778463946f7d0a0f2a5c0d74b774&scene=21#wechat_redirect
2016-08-02	BBED系列之实践（3.6）-- SYSTEM文件头损坏的恢复	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771339&idx=1&sn=06ebe88f8ee40e204569ee6dcc5e92f2&scene=21#wechat_redirect
2016-08-01	【故障处理】ORA-19809错误处理	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771336&idx=1&sn=49f11666bf29eaa8fe3bdb24567a0cd4&scene=21#wechat_redirect

一.3 201607

发布日期	文章标题
2016-07-31	BBED系列之实践（3.5）--丢失归档文件情况下的恢复(2)	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771333&idx=1&sn=0f40b6c461f129e6d6a2b1cd92c76b79&scene=21#wechat_redirect
2016-07-30	BBED系列之实践（3.5）--丢失归档文件情况下的恢复(1)	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771327&idx=1&sn=ce377e2997c96b93eedcb6d4ebf2d315&scene=21#wechat_redirect
2016-07-29	BBED系列之实践（3.4）--坏块恢复（Rman Blockrecover）	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771322&idx=1&sn=11c6a6aaff00405b23828a9512fc7de1&scene=21#wechat_redirect
2016-07-28	BBED系列之实践（3.3）--使用copy命令从旧数据文件中恢复delete的rows	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771319&idx=1&sn=35079edb30e25e9df1b139eb30cb48de&scene=21#wechat_redirect
2016-07-27	BBED系列之实践（3.2）-- 恢复delete的rows 公众号之原创声明、留言、网页模板和赞赏功能	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771316&idx=1&sn=251a0fa3b1dcfc687c465d4bdfabc0ee&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771316&idx=2&sn=cf49534315b49ffdb62cb959dcc593a0&scene=21#wechat_redirect
2016-07-26	BBED系列之实践（3.1）-- 修改数据块中的内容	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771311&idx=1&sn=fb324fe7e19339677a45d42612a2da6a&scene=21#wechat_redirect
2016-07-25	BBED系列之基本命令（2.4）	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771308&idx=1&sn=5259c8849d953f19c34ac2d5b2a20034&scene=21#wechat_redirect
2016-07-24	BBED系列之基本命令（2.3）	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771305&idx=1&sn=945d097a4c1163bac8cb9ba1d1188b4d&scene=21#wechat_redirect
2016-07-23	BBED系列之基本命令（2.2）	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771301&idx=1&sn=2b89f1254b17d220b66c0af299d5b661&scene=21#wechat_redirect
2016-07-22	BBED系列之基本命令（2.1）	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771294&idx=1&sn=c8ef9a99bc737654b20c2a0b7373b7ea&scene=21#wechat_redirect
2016-07-21	BBED系列之编译安装（1）	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771287&idx=1&sn=d5045206000b3d0bfbd21849778635e6&scene=21#wechat_redirect
2016-07-20	Oracle中如何判断一个字符串是否含有汉字	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771284&idx=1&sn=ab4e725c4d4ad448e245e1668ccac382&scene=21#wechat_redirect
2016-07-19	Oracle如何预估将要创建的索引的大小	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771280&idx=1&sn=1a1524f481f434e1d935216b996f1b5a&scene=21#wechat_redirect
2016-07-18	RMAN脚本中使用替换变量--windows 下rman全备脚本	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771277&idx=1&sn=6b56724770774ad9c116d21f4df6993c&scene=21#wechat_redirect
2016-07-17	IPCS和IPCRM使用	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771274&idx=1&sn=72b2ca5606f800edcec3d0b5c264433b&scene=21#wechat_redirect
2016-07-16	OEM使用总结	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771271&idx=1&sn=1dbc35299cbda68c569d263e9020ae89&scene=21#wechat_redirect
2016-07-15	ASM数据文件和FS之间的各种转换方法（1） ASM数据文件和FS之间的各种转换方法（2） ASM数据文件和FS之间的各种转换方法（3） ASM数据文件和FS之间的各种转换方法（4）	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771257&idx=1&sn=241086695d4a44a6756ab93e895c1191&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771264&idx=2&sn=033bac8c5974885ddd8fc846c22bef89&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771264&idx=3&sn=c3c934351d7eb15827ebe5b6c94eefd5&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771264&idx=4&sn=f22d61318f13809db26bacf5a6ec9017&scene=21#wechat_redirect
2016-07-14	Oracle手动建库常见问题	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771257&idx=1&sn=241086695d4a44a6756ab93e895c1191&scene=21#wechat_redirect
2016-07-13	读书笔记--《Oracle DBA工作笔记》第一章	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771254&idx=1&sn=5ed9d67728e70643efd2f908aeb774b4&scene=21#wechat_redirect
2016-07-12	【故障处理】DBCA建库诡异问题处理--rac环境不能创建rac库 dbca静默建库---故障处理总结健康检查脚本的最新版本V5.5.5	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771251&idx=1&sn=945cffff28b420aa3a5228dd6f9ca0f8&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771251&idx=2&sn=6bf1e0a3cda533c2712adc647d95d09b&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771251&idx=3&sn=43bd0267e62d9ba63380a6f09b85f105&scene=21#wechat_redirect
2016-07-11	SQL优化中索引列使用函数之灵异事件	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771245&idx=1&sn=e02e83a713db790a642da2ab7c4c8563&scene=21#wechat_redirect
2016-07-10	itpub写博客2年了回答Q友批量删除表问题	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771238&idx=1&sn=c1286541fb6da5925fdcd0eff9c6f720&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771238&idx=2&sn=054c1f9d12f4b070fce38db943ded867&scene=21#wechat_redirect
2016-07-09	truncate恢复方法集合 gdul恢复truncate的表	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771230&idx=1&sn=52de5e1bf7cf683ba986e7d98252cd18&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771230&idx=2&sn=7411c0bc07ff85a09aa61ff7d9d9c3c7&scene=21#wechat_redirect
2016-07-08	【DG】物理DG中主库的LNSn、NSS、NSA进程的比较	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771227&idx=1&sn=61cb8cdb05f60a6947c521d988b049bf&scene=21#wechat_redirect
2016-07-07	【故障处理】DBCA建库报错CRS-2566 PRCR-1071 PRCR-1006	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771221&idx=1&sn=43fb4e9b76d981bbd4bef587ae7ac9fc&scene=21#wechat_redirect
2016-07-06	脚本分享-- DBCA静默建库	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771218&idx=1&sn=b12e80767d151f4065a557097e3b3652&scene=21#wechat_redirect
2016-07-05	Oracle OCR的备份与恢复 Oracle OCR的备份与恢复(1) Oracle OCR的备份与恢复(2)--如何修复11.2 Grid权限误操作 Oracle OCR的备份与恢复(3)---实验部分	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771215&idx=1&sn=39959fae41c30090bc3aa3d4e72a79bf&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771215&idx=2&sn=15f2161a469d2b0525b4407cc07d82a6&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771215&idx=3&sn=f73223ced21e5f678b7b389a5583cbaf&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771215&idx=4&sn=baf2d038fd85bee680d42230b2e915eb&scene=21#wechat_redirect
2016-07-04	Oracle回收站及flashback drop 回收站及flashback drop实验部分(1) 回收站及flashback drop实验部分(2) 回收站及flashback drop实验部分(3) 回收站及flashback drop实验部分(4)	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771194&idx=1&sn=81e48a5f29c47709aa899dfce5b6c69e&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771194&idx=2&sn=2cde5baa43507cb1ff17d9f5609a1732&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771194&idx=3&sn=349e6caee7d954fdb79f2c4c4e4bc815&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771194&idx=4&sn=5142c893124af432ec9b15b6fe71f035&scene=21#wechat_redirect http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771194&idx=5&sn=e7b9888cfd7ef0b2c59aa9026b8ee672&scene=21#wechat_redirect
2016-07-03	【技巧】如何全文搜索oracle官方文档	http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771177&idx=1&sn=5929f2e95be8dbe819e4989df0286a74&scene=21#wechat_redirect