<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cixlv48826</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cixlv48826]]></copyright><item><title><![CDATA[博客重新开启]]></title><link>https://blog.youkuaiyun.com/cixlv48826/article/details/100290727</link><guid>https://blog.youkuaiyun.com/cixlv48826/article/details/100290727</guid><author>cixlv48826</author><pubDate>Tue, 12 Dec 2017 10:58:07 +0800</pubDate><description><![CDATA[2017-12-12
                                                            
                    
                     ...]]></description><category></category></item><item><title><![CDATA[【故障诊断】cr块slot notfound解决过程]]></title><link>https://blog.youkuaiyun.com/cixlv48826/article/details/100290735</link><guid>https://blog.youkuaiyun.com/cixlv48826/article/details/100290735</guid><author>cixlv48826</author><pubDate>Wed, 12 Nov 2014 10:18:14 +0800</pubDate><description><![CDATA[在一次严重故障中控制文件重建，强行拉起库，前面的问题解决了（HA引发的血案，涉及他人误操作，具体略）
数据库和应用起来后却遇到大量cr块slot notfound的问题，时间正是业务高峰的白天，一阵头皮发麻，具体报错内容：
...]]></description><category></category></item><item><title><![CDATA[新的开始]]></title><link>https://blog.youkuaiyun.com/cixlv48826/article/details/100290733</link><guid>https://blog.youkuaiyun.com/cixlv48826/article/details/100290733</guid><author>cixlv48826</author><pubDate>Wed, 28 Aug 2013 17:17:53 +0800</pubDate><description><![CDATA[阔别2年，重回上海，老东家，dba


                                                            
                    
        ...]]></description><category></category></item><item><title><![CDATA[UK之旅结束]]></title><link>https://blog.youkuaiyun.com/cixlv48826/article/details/100290729</link><guid>https://blog.youkuaiyun.com/cixlv48826/article/details/100290729</guid><author>cixlv48826</author><pubDate>Fri, 28 Jun 2013 01:14:17 +0800</pubDate><description><![CDATA[明天回国。

                                                            
                    
                       ...]]></description><category></category></item><item><title><![CDATA[【gg notes】config gg for windows x86 32bit ,two node]]></title><link>https://blog.youkuaiyun.com/cixlv48826/article/details/100290718</link><guid>https://blog.youkuaiyun.com/cixlv48826/article/details/100290718</guid><author>cixlv48826</author><pubDate>Tue, 16 Apr 2013 04:31:59 +0800</pubDate><description><![CDATA[Let's improve the single node configuration sample to two nodes of win x86 32-bit 
In fact, we are still in the...]]></description><category></category></item><item><title><![CDATA[【gg notes】config gg for windows x86 32bit ,single node]]></title><link>https://blog.youkuaiyun.com/cixlv48826/article/details/100290730</link><guid>https://blog.youkuaiyun.com/cixlv48826/article/details/100290730</guid><author>cixlv48826</author><pubDate>Tue, 16 Apr 2013 02:18:47 +0800</pubDate><description><![CDATA[1, Prepare the install environment
OS: windows XP(x86-32-bit)
DB: Oracle11R2
GG: ggs_Windows_x86_ora11g_32bit
...]]></description><category></category></item><item><title><![CDATA[人生有起伏，心态放平常]]></title><link>https://blog.youkuaiyun.com/cixlv48826/article/details/100290728</link><guid>https://blog.youkuaiyun.com/cixlv48826/article/details/100290728</guid><author>cixlv48826</author><pubDate>Mon, 01 Apr 2013 09:44:19 +0800</pubDate><description><![CDATA[2013-4-1
                                                            
                    
                       ...]]></description><category></category></item><item><title><![CDATA[2013]]></title><link>https://blog.youkuaiyun.com/cixlv48826/article/details/100290726</link><guid>https://blog.youkuaiyun.com/cixlv48826/article/details/100290726</guid><author>cixlv48826</author><pubDate>Tue, 05 Feb 2013 10:21:18 +0800</pubDate><description><![CDATA[千里之行始于足下。

2013.2.5
                                                            
                    
         ...]]></description><category></category></item><item><title><![CDATA[【dbms包】dbms_redefinition]]></title><link>https://blog.youkuaiyun.com/cixlv48826/article/details/100290715</link><guid>https://blog.youkuaiyun.com/cixlv48826/article/details/100290715</guid><author>cixlv48826</author><pubDate>Wed, 28 Nov 2012 00:33:29 +0800</pubDate><description><![CDATA[see
http://space.itpub.net/704188/viewspace-154137
                                                            
 ...]]></description><category></category></item><item><title><![CDATA[skip_unusable_indexes]]></title><link>https://blog.youkuaiyun.com/cixlv48826/article/details/100290713</link><guid>https://blog.youkuaiyun.com/cixlv48826/article/details/100290713</guid><author>cixlv48826</author><pubDate>Wed, 28 Nov 2012 00:24:48 +0800</pubDate><description><![CDATA[1，alter index ind_index_test_name unusable ;
alter session set skip_unusable_indexes = true;
修改后，插入数据并不会维护索引，而执...]]></description><category></category></item><item><title><![CDATA[index rebuild online的问题]]></title><link>https://blog.youkuaiyun.com/cixlv48826/article/details/100290722</link><guid>https://blog.youkuaiyun.com/cixlv48826/article/details/100290722</guid><author>cixlv48826</author><pubDate>Tue, 27 Nov 2012 18:42:58 +0800</pubDate><description><![CDATA[意外cancel掉了一个正在rebuild的索引，单Smon并没有及时清理rebuild索引时创建的临时对象（sys.ind$等），否则再操作的时候会报错：ora-08104

10g开始可以使用dbms_repair.o...]]></description><category></category></item><item><title><![CDATA[【性能调整】等待事件read by other session]]></title><link>https://blog.youkuaiyun.com/cixlv48826/article/details/100290720</link><guid>https://blog.youkuaiyun.com/cixlv48826/article/details/100290720</guid><author>cixlv48826</author><pubDate>Thu, 15 Nov 2012 00:19:03 +0800</pubDate><description><![CDATA[read by other session
This event occurs when a session requests a buffer that is currently being read into the bu...]]></description><category></category></item><item><title><![CDATA[【性能调整】11g导出导入的几个问题]]></title><link>https://blog.youkuaiyun.com/cixlv48826/article/details/100290716</link><guid>https://blog.youkuaiyun.com/cixlv48826/article/details/100290716</guid><author>cixlv48826</author><pubDate>Mon, 17 Sep 2012 15:02:19 +0800</pubDate><description><![CDATA[1，Error: ORA-39059 (ORA-39059)Text: dump file set is incomplete ---------------------------------------------...]]></description><category></category></item><item><title><![CDATA[海量数据转换迁移的代码自动生成]]></title><link>https://blog.youkuaiyun.com/cixlv48826/article/details/100290712</link><guid>https://blog.youkuaiyun.com/cixlv48826/article/details/100290712</guid><author>cixlv48826</author><pubDate>Fri, 31 Aug 2012 14:32:30 +0800</pubDate><description><![CDATA[系统软硬件升级或者迁移中的数据迁移工作是一项涉及范围很广的工作，往往在源库有数百上千个业务表需要根据一定的模型规则映射到新的数据库中，模型的映射与业务密切相关。通常我们将业务划分为多个域，域内表一级映射可以归纳为以下模型：1，...]]></description><category></category></item><item><title><![CDATA[【性能调整】海量数据的性能设计]]></title><link>https://blog.youkuaiyun.com/cixlv48826/article/details/100290709</link><guid>https://blog.youkuaiyun.com/cixlv48826/article/details/100290709</guid><author>cixlv48826</author><pubDate>Thu, 30 Aug 2012 14:37:21 +0800</pubDate><description><![CDATA[1，业务类型分析与代码结构优化a)业务类型分析读为主：大而少的查询（理解业务，合理使用临时表并分区，优化大查询的关联，避免过度嵌套，避免大量的索引使用，查询合并减少同一大表的访问次数）小而多的查询（索引优化，重用...]]></description><category></category></item><item><title><![CDATA[【性能调整】等待事件 enq: SQ - contention]]></title><link>https://blog.youkuaiyun.com/cixlv48826/article/details/100290721</link><guid>https://blog.youkuaiyun.com/cixlv48826/article/details/100290721</guid><author>cixlv48826</author><pubDate>Thu, 23 Aug 2012 16:22:11 +0800</pubDate><description><![CDATA[这个一般是序列号缓冲设置过小导致的，同时出现的一般还会有队列的一下等待，这是由于sequence的机制导致的，大数据量插入的时候需要考虑好实现方法，如没有更好的方法，要调大缓冲值
                        ...]]></description><category></category></item><item><title><![CDATA[◎长沙]]></title><link>https://blog.youkuaiyun.com/cixlv48826/article/details/100290717</link><guid>https://blog.youkuaiyun.com/cixlv48826/article/details/100290717</guid><author>cixlv48826</author><pubDate>Tue, 10 Jul 2012 13:54:55 +0800</pubDate><description><![CDATA[7月4号回国了，@长沙
开始弄一下postgresql相关内容，过段时间再试用一下DM7。
                                                            
      ...]]></description><category></category></item><item><title><![CDATA[【hangs】impdp hangs]]></title><link>https://blog.youkuaiyun.com/cixlv48826/article/details/100290714</link><guid>https://blog.youkuaiyun.com/cixlv48826/article/details/100290714</guid><author>cixlv48826</author><pubDate>Tue, 19 Jun 2012 02:00:42 +0800</pubDate><description><![CDATA[问题场景：一个比较小的表分了近200个区，使用impdp导入不到100M的数据的时候，导入很快可以成功，但是状态始终停在'WORK WAITING',查clert.log和impdp.log并无报错信息出现;查awr报表，显示r...]]></description><category></category></item><item><title><![CDATA[危机也意味着转机]]></title><link>https://blog.youkuaiyun.com/cixlv48826/article/details/100290710</link><guid>https://blog.youkuaiyun.com/cixlv48826/article/details/100290710</guid><author>cixlv48826</author><pubDate>Wed, 13 Jun 2012 23:20:54 +0800</pubDate><description><![CDATA[鉴于目前的状态，论坛的一个兄弟说的这句话，也许对我现在正合适：危机也意味着转机
2012-06-13
                                                            
 ...]]></description><category></category></item><item><title><![CDATA[【Brussels】戒烟周记4]]></title><link>https://blog.youkuaiyun.com/cixlv48826/article/details/100290708</link><guid>https://blog.youkuaiyun.com/cixlv48826/article/details/100290708</guid><author>cixlv48826</author><pubDate>Fri, 08 Jun 2012 02:18:03 +0800</pubDate><description><![CDATA[4 weeks
以后不再记录。
                                                            
                    
               ...]]></description><category></category></item></channel></rss>