<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[congming0455的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/congming0455</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; congming0455]]></copyright><item><title><![CDATA[Ora-01775 looping chain of synonyms]]></title><link>https://blog.youkuaiyun.com/congming0455/article/details/100420710</link><guid>https://blog.youkuaiyun.com/congming0455/article/details/100420710</guid><author>congming0455</author><pubDate>Wed, 13 Jan 2010 12:17:57 +0800</pubDate><description><![CDATA[SQL&gt; CREATE synonym s1 FOR s2;
同义词已创建。
SQL&gt; CREATE synonym s2 FOR s3;
同义词已创建。
SQL&gt; CREATE synonym s3 ...]]></description><category></category></item><item><title><![CDATA[DATAGUARD三种保护模式]]></title><link>https://blog.youkuaiyun.com/congming0455/article/details/100420745</link><guid>https://blog.youkuaiyun.com/congming0455/article/details/100420745</guid><author>congming0455</author><pubDate>Mon, 11 Jan 2010 10:25:35 +0800</pubDate><description><![CDATA[http://space.itpub.net/12020513/viewspace-619715
                                                            
    ...]]></description><category></category></item><item><title><![CDATA[我又回来了，重新拾起——SGA参数调整]]></title><link>https://blog.youkuaiyun.com/congming0455/article/details/100420748</link><guid>https://blog.youkuaiyun.com/congming0455/article/details/100420748</guid><author>congming0455</author><pubDate>Mon, 28 Dec 2009 10:36:41 +0800</pubDate><description><![CDATA[距离上次的日志更新已经有三个多月的时间，对于自己的间断有一些原因，有一些惭愧，总是有这样那样的原因导致中断。oracle是我的根本，还是要一如既往的坚持下来才对。
重新拾起oracle的基本知识：
Shared pool：用...]]></description><category></category></item><item><title><![CDATA[最近很颓]]></title><link>https://blog.youkuaiyun.com/congming0455/article/details/100420806</link><guid>https://blog.youkuaiyun.com/congming0455/article/details/100420806</guid><author>congming0455</author><pubDate>Fri, 11 Sep 2009 17:56:24 +0800</pubDate><description><![CDATA[曾经说好的坚持。。。唉。。。看来我是一个随性的人，心情好能写10篇，颓的时候就什么都不想做。
还有一点需要说明的是：最近数据库很稳定，真的没有啥要调查的，主动学习性一下子就降低了。
                      ...]]></description><category></category></item><item><title><![CDATA[逻辑卷和数据文件之间的关系]]></title><link>https://blog.youkuaiyun.com/congming0455/article/details/100420747</link><guid>https://blog.youkuaiyun.com/congming0455/article/details/100420747</guid><author>congming0455</author><pubDate>Wed, 09 Sep 2009 10:47:17 +0800</pubDate><description><![CDATA[物理卷、卷组、逻辑卷之间的关系：如果把PV比做地球的一个板块，VG则是一个地球，因为地球是由多个板块组成的，那么在地球上划分一个区域并标记为亚洲，则亚洲就相当于 一个LV。
物理卷是hdisk，逻辑卷可以设置挂载点、设立分区。...]]></description><category></category></item><item><title><![CDATA[关于ORA-16198错误]]></title><link>https://blog.youkuaiyun.com/congming0455/article/details/100420754</link><guid>https://blog.youkuaiyun.com/congming0455/article/details/100420754</guid><author>congming0455</author><pubDate>Mon, 07 Sep 2009 10:46:02 +0800</pubDate><description><![CDATA[关于此错误，从metalink查到：
The net_timeout attribute in the log_archive_dest_2 on the primary is
set too low so that
LN...]]></description><category></category></item><item><title><![CDATA[Dataguard的三种模式]]></title><link>https://blog.youkuaiyun.com/congming0455/article/details/100420702</link><guid>https://blog.youkuaiyun.com/congming0455/article/details/100420702</guid><author>congming0455</author><pubDate>Fri, 04 Sep 2009 13:16:29 +0800</pubDate><description><![CDATA[最大保护：比如说用户commit，此时候会刷新redo buffer写入redolog中。在此模式时候，必须要保证redo buffer信息写入redo log和备机的一个redo中。不然就数据库挂。貌似这样。没测试过。有空...]]></description><category></category></item><item><title><![CDATA[DataGuard角色切换]]></title><link>https://blog.youkuaiyun.com/congming0455/article/details/100420737</link><guid>https://blog.youkuaiyun.com/congming0455/article/details/100420737</guid><author>congming0455</author><pubDate>Thu, 03 Sep 2009 17:09:10 +0800</pubDate><description><![CDATA[以下引自：
http://hi.baidu.com/zzztou/blog/item/e8cc47c2c1d41c1c0ff4774f.html
DataGuard角色切换:...]]></description><category></category></item><item><title><![CDATA[10046事件]]></title><link>https://blog.youkuaiyun.com/congming0455/article/details/100420709</link><guid>https://blog.youkuaiyun.com/congming0455/article/details/100420709</guid><author>congming0455</author><pubDate>Thu, 03 Sep 2009 13:41:25 +0800</pubDate><description><![CDATA[10046事件可以设置以下四个级别:1 - 启用标准的SQL_TRACE功能,等价于sql_trace4 - Level 1 加上绑定值(bind values)8 - Level 1 + 等待事件跟踪12 - Level 1 ...]]></description><category></category></item><item><title><![CDATA[使用SQL_TRACE进行数据库诊断]]></title><link>https://blog.youkuaiyun.com/congming0455/article/details/100420707</link><guid>https://blog.youkuaiyun.com/congming0455/article/details/100420707</guid><author>congming0455</author><pubDate>Thu, 03 Sep 2009 13:25:01 +0800</pubDate><description><![CDATA[alter session set sql_trace=true;exec dbms_system.set_sql_trace_in_session(SID,SERIAL#,true)
exec dbms_system.set...]]></description><category></category></item><item><title><![CDATA[Logical Dataguard出现的ORA-26786错误是个BUG]]></title><link>https://blog.youkuaiyun.com/congming0455/article/details/100420744</link><guid>https://blog.youkuaiyun.com/congming0455/article/details/100420744</guid><author>congming0455</author><pubDate>Thu, 27 Aug 2009 12:07:33 +0800</pubDate><description><![CDATA[此错误将在11.2中fix掉。
                                                            
                    
                ...]]></description><category></category></item><item><title><![CDATA[11g新特性：使用DBMS_COMPARISON比较数据库对象]]></title><link>https://blog.youkuaiyun.com/congming0455/article/details/100420705</link><guid>https://blog.youkuaiyun.com/congming0455/article/details/100420705</guid><author>congming0455</author><pubDate>Mon, 24 Aug 2009 11:09:50 +0800</pubDate><description><![CDATA[http://www.itpub.net/archiver/tid-923856.html
                                                            
       ...]]></description><category></category></item><item><title><![CDATA[DATAGUARD手工注册归档日志（转载）]]></title><link>https://blog.youkuaiyun.com/congming0455/article/details/100420701</link><guid>https://blog.youkuaiyun.com/congming0455/article/details/100420701</guid><author>congming0455</author><pubDate>Fri, 21 Aug 2009 19:39:27 +0800</pubDate><description><![CDATA[从9i以后，一般都不需要手工处理确实的日志，FAL自动会帮我们处理这些问题。但是，并非我们就完全不用手工处理了，比如，你的磁盘空间爆满，归档日志在传到备库前被转移到其他地方，这种情况下FAL是不能解决问题的，需要手工处理一下。下...]]></description><category></category></item><item><title><![CDATA[AIX的学习：之三（RAID）]]></title><link>https://blog.youkuaiyun.com/congming0455/article/details/100420703</link><guid>https://blog.youkuaiyun.com/congming0455/article/details/100420703</guid><author>congming0455</author><pubDate>Tue, 18 Aug 2009 15:38:25 +0800</pubDate><description><![CDATA[RAID 0：不提供任何冗余，所谓的条带话技术，分块技术，容量为N disks。
RAID 1：同时将相同数据写到多块磁盘上（较浪费空间），容量为1 disks。
RAID 3：数据交错分布，其中有一块专门的硬盘用于奇偶校验...]]></description><category></category></item><item><title><![CDATA[AIX的学习：之二（存储管理）]]></title><link>https://blog.youkuaiyun.com/congming0455/article/details/100420940</link><guid>https://blog.youkuaiyun.com/congming0455/article/details/100420940</guid><author>congming0455</author><pubDate>Mon, 17 Aug 2009 15:39:54 +0800</pubDate><description><![CDATA[LVM：逻辑卷管理器
VGDA：Volumn Group Descriptor Area
VGSA：Volumn Group Status Area
smit cplv：拷贝一个逻辑卷
逻辑卷的大小=LV包含LP的个数*...]]></description><category></category></item><item><title><![CDATA[AIX的学习：之一（设备管理）]]></title><link>https://blog.youkuaiyun.com/congming0455/article/details/100420714</link><guid>https://blog.youkuaiyun.com/congming0455/article/details/100420714</guid><author>congming0455</author><pubDate>Mon, 17 Aug 2009 10:48:38 +0800</pubDate><description><![CDATA[lsattr -E -l sys0 -H：显示系统属性的当前有效值
lscfg | grep proc | wc -l：列出处理器的数量
smitty——Devices——List Devices
prtconf：显示系统...]]></description><category></category></item><item><title><![CDATA[执行计划突变导致的SQL慢]]></title><link>https://blog.youkuaiyun.com/congming0455/article/details/100420736</link><guid>https://blog.youkuaiyun.com/congming0455/article/details/100420736</guid><author>congming0455</author><pubDate>Wed, 12 Aug 2009 10:09:09 +0800</pubDate><description><![CDATA[相同环境下同一条update语句，慢的时候执行了1.5天，快的时候2个小时就执行完了，通过执行@awrsqrpt.sql脚本抓取当时的执行计划，发现有如下不同：
慢的情况下的执行计划：




Id 
Operat...]]></description><category></category></item><item><title><![CDATA[aa]]></title><link>https://blog.youkuaiyun.com/congming0455/article/details/100420697</link><guid>https://blog.youkuaiyun.com/congming0455/article/details/100420697</guid><author>congming0455</author><pubDate>Wed, 12 Aug 2009 10:06:54 +0800</pubDate><description><![CDATA[aa
                                                            
                    
                             ...]]></description><category></category></item><item><title><![CDATA[Dataguard中的db link问题]]></title><link>https://blog.youkuaiyun.com/congming0455/article/details/100420698</link><guid>https://blog.youkuaiyun.com/congming0455/article/details/100420698</guid><author>congming0455</author><pubDate>Tue, 11 Aug 2009 16:11:50 +0800</pubDate><description><![CDATA[必须用CREATE PUBLIC DATABASE LINK......
                                                            
                ...]]></description><category></category></item><item><title><![CDATA[密码过期问题（转载）]]></title><link>https://blog.youkuaiyun.com/congming0455/article/details/100420696</link><guid>https://blog.youkuaiyun.com/congming0455/article/details/100420696</guid><author>congming0455</author><pubDate>Mon, 10 Aug 2009 15:42:30 +0800</pubDate><description><![CDATA[【解决方案】
按照如下步骤进行操作：
1、查看用户的proifle是哪个，一般是default：
sql&gt;SELECT username,PROFILE FROM dba_users;
2、查看指定概要文件（如de...]]></description><category></category></item></channel></rss>