<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cuishuaai9230的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cuishuaai9230</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cuishuaai9230]]></copyright><item><title><![CDATA[职称英语考完了，该收收心继续研究Oracle了，呵呵]]></title><link>https://blog.youkuaiyun.com/cuishuaai9230/article/details/100463508</link><guid>https://blog.youkuaiyun.com/cuishuaai9230/article/details/100463508</guid><author>cuishuaai9230</author><pubDate>Fri, 11 Apr 2008 21:27:09 +0800</pubDate><description><![CDATA[[@more@]
                                                            
                    
                       ...]]></description><category></category></item><item><title><![CDATA[使用Oracle分析函数去除重复记录]]></title><link>https://blog.youkuaiyun.com/cuishuaai9230/article/details/100463520</link><guid>https://blog.youkuaiyun.com/cuishuaai9230/article/details/100463520</guid><author>cuishuaai9230</author><pubDate>Fri, 11 Apr 2008 21:25:12 +0800</pubDate><description><![CDATA[1、创建个实验表create table t (a number);insert into t values(1);insert into t values(1);insert into t values(1);insert i...]]></description><category></category></item><item><title><![CDATA[数据库从文件系统转移至ASM实验记录]]></title><link>https://blog.youkuaiyun.com/cuishuaai9230/article/details/100463519</link><guid>https://blog.youkuaiyun.com/cuishuaai9230/article/details/100463519</guid><author>cuishuaai9230</author><pubDate>Fri, 28 Mar 2008 20:32:15 +0800</pubDate><description><![CDATA[实验环境：WinXP SP2数据库版本：10.2.0.1准备迁移的数据库实例名：TESTASM实例名：+ASMASM磁盘组：+TEST创建ASM实例和磁盘组的步骤这里不再重复，请参考：http://woodnan.itpub.n...]]></description><category></category></item><item><title><![CDATA[开始准备职称英语考试了]]></title><link>https://blog.youkuaiyun.com/cuishuaai9230/article/details/100463496</link><guid>https://blog.youkuaiyun.com/cuishuaai9230/article/details/100463496</guid><author>cuishuaai9230</author><pubDate>Mon, 24 Mar 2008 20:24:00 +0800</pubDate><description><![CDATA[要开始准备4月6日的职称英语考试了。英语单词忘了不少了，该背背了，Oracle的实验可能要做的少点了，blog的更新也可能稍微慢点了，呵呵[@more@]
                                    ...]]></description><category></category></item><item><title><![CDATA[使用普通文件创建ASM实例]]></title><link>https://blog.youkuaiyun.com/cuishuaai9230/article/details/100463493</link><guid>https://blog.youkuaiyun.com/cuishuaai9230/article/details/100463493</guid><author>cuishuaai9230</author><pubDate>Sun, 23 Mar 2008 21:56:36 +0800</pubDate><description><![CDATA[平台：WinXP SP2数据库版本：10.2.0.1注：由于itpub的blog会屏蔽反斜杠，以下反斜杠都用斜杠代替了实验需要perl建立文件来模拟asm磁盘，perl解析器可以从下面的地址下载http://www.skycn....]]></description><category></category></item><item><title><![CDATA[Oracle10g BIGFILE表空间带来的好处]]></title><link>https://blog.youkuaiyun.com/cuishuaai9230/article/details/100463494</link><guid>https://blog.youkuaiyun.com/cuishuaai9230/article/details/100463494</guid><author>cuishuaai9230</author><pubDate>Fri, 21 Mar 2008 22:30:18 +0800</pubDate><description><![CDATA[Oracle10g引进了一个新的表空间类型（BIGFILE）。它不像传统的表空间那样最多由1022个文件组成；一个BIGFILE表空间只包含一个数据文件，根据选择的块的大小，最大从32TB至128TB。BIGFILE带来的最大好...]]></description><category></category></item><item><title><![CDATA[使用dbms_stats但不生成histogram的方法]]></title><link>https://blog.youkuaiyun.com/cuishuaai9230/article/details/100463503</link><guid>https://blog.youkuaiyun.com/cuishuaai9230/article/details/100463503</guid><author>cuishuaai9230</author><pubDate>Fri, 21 Mar 2008 22:19:49 +0800</pubDate><description><![CDATA[由于应用开发的问题，数据库存在大量的SQL硬解析，性能出现很大问题。考虑设置参数cursor_sharing=similar解决硬解析问题，但是10g在自动收集统计值会默认收集histogram，依然会影响SQL的解析性能。此问...]]></description><category></category></item><item><title><![CDATA[一条SQL生成九九乘法表]]></title><link>https://blog.youkuaiyun.com/cuishuaai9230/article/details/100463504</link><guid>https://blog.youkuaiyun.com/cuishuaai9230/article/details/100463504</guid><author>cuishuaai9230</author><pubDate>Fri, 21 Mar 2008 21:52:14 +0800</pubDate><description><![CDATA[1
                                                            
                    
                              ...]]></description><category></category></item><item><title><![CDATA[Oracle常用dump命令]]></title><link>https://blog.youkuaiyun.com/cuishuaai9230/article/details/100463492</link><guid>https://blog.youkuaiyun.com/cuishuaai9230/article/details/100463492</guid><author>cuishuaai9230</author><pubDate>Thu, 20 Mar 2008 22:27:04 +0800</pubDate><description><![CDATA[Oracle常用dump命令，记录一下备查[@more@]一.Memory Dumps1).Global AreaALTER SESSION SET EVENTS 'immediate trace name global_are...]]></description><category></category></item><item><title><![CDATA[List of X$ Tables and how the names are derived]]></title><link>https://blog.youkuaiyun.com/cuishuaai9230/article/details/100463490</link><guid>https://blog.youkuaiyun.com/cuishuaai9230/article/details/100463490</guid><author>cuishuaai9230</author><pubDate>Thu, 20 Mar 2008 22:16:13 +0800</pubDate><description><![CDATA[X$表名太不容易记忆了，记录一下备查[@more@][K]ernel Layer [2]-Phase Commit [G]lobal [T]ransaction [E]ntry X$K2GTE - Current 2PC tx ...]]></description><category></category></item><item><title><![CDATA[Truncate table对x$bh的影响]]></title><link>https://blog.youkuaiyun.com/cuishuaai9230/article/details/100463491</link><guid>https://blog.youkuaiyun.com/cuishuaai9230/article/details/100463491</guid><author>cuishuaai9230</author><pubDate>Thu, 20 Mar 2008 21:43:45 +0800</pubDate><description><![CDATA[今天在做实验的时候发现：truncate table后x$bh不会再记录对此table块的访问，具体实验如下：[@more@]SQL&gt;create table t3 ( a number);Table created.SQ...]]></description><category></category></item><item><title><![CDATA[又开始了]]></title><link>https://blog.youkuaiyun.com/cuishuaai9230/article/details/100463502</link><guid>https://blog.youkuaiyun.com/cuishuaai9230/article/details/100463502</guid><author>cuishuaai9230</author><pubDate>Thu, 20 Mar 2008 21:21:48 +0800</pubDate><description><![CDATA[去年曾经在MSN上开过Blog，不过很长时间不更新了，而且那里也太慢了，在喜欢的itpub上重新开个技术性的Blog吧[@more@]
                                              ...]]></description><category></category></item></channel></rss>