<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[congtudi4111的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/congtudi4111</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; congtudi4111]]></copyright><item><title><![CDATA[explain (analyze,verbose,buffers,costs,timing) select]]></title><link>https://blog.youkuaiyun.com/congtudi4111/article/details/100423327</link><guid>https://blog.youkuaiyun.com/congtudi4111/article/details/100423327</guid><author>congtudi4111</author><pubDate>Sun, 28 Dec 2014 20:36:20 +0800</pubDate><description><![CDATA[explain (analyze,verbose,buffers,costs,timing) select id from t11 where id&lt;10;

EXPLAIN [ ( option [, ...] ) ...]]></description><category></category></item><item><title><![CDATA[PG9.3.5 流复制测试]]></title><link>https://blog.youkuaiyun.com/congtudi4111/article/details/100423325</link><guid>https://blog.youkuaiyun.com/congtudi4111/article/details/100423325</guid><author>congtudi4111</author><pubDate>Fri, 21 Nov 2014 16:57:59 +0800</pubDate><description><![CDATA[环境信息：主节点 192.168.100.117
     从节点 192.168.100.118


PGDATA=/usr/local/pgsql/data


arch :
[p...]]></description><category></category></item><item><title><![CDATA[Centos 6.5 下安装postgres 9.3.5]]></title><link>https://blog.youkuaiyun.com/congtudi4111/article/details/100423262</link><guid>https://blog.youkuaiyun.com/congtudi4111/article/details/100423262</guid><author>congtudi4111</author><pubDate>Tue, 18 Nov 2014 16:02:09 +0800</pubDate><description><![CDATA[gunzip postgresql-9.3.5.tar.gz
tar xf postgresql-9.3.5.tar


./configure
gmake
su
gmake install
adduse...]]></description><category></category></item><item><title><![CDATA[test0001]]></title><link>https://blog.youkuaiyun.com/congtudi4111/article/details/100423268</link><guid>https://blog.youkuaiyun.com/congtudi4111/article/details/100423268</guid><author>congtudi4111</author><pubDate>Tue, 18 Nov 2014 15:13:26 +0800</pubDate><description><![CDATA[[postgres@myLinux002 lib]$ pg_ctl restart -m fast
 waiting for server to shut down.... done
 server stopped...]]></description><category></category></item><item><title><![CDATA[RAC 一个节点HANG住]]></title><link>https://blog.youkuaiyun.com/congtudi4111/article/details/100423326</link><guid>https://blog.youkuaiyun.com/congtudi4111/article/details/100423326</guid><author>congtudi4111</author><pubDate>Fri, 13 Jan 2012 14:17:56 +0800</pubDate><description><![CDATA[ALERT:
Thread 2 advanced to log sequence 98525 (LGWR switch) Current log# 3 seq# 98525 mem# 0: +DATA/ttdb/onl...]]></description><category></category></item><item><title><![CDATA[恢复dba   role 角色]]></title><link>https://blog.youkuaiyun.com/congtudi4111/article/details/100423254</link><guid>https://blog.youkuaiyun.com/congtudi4111/article/details/100423254</guid><author>congtudi4111</author><pubDate>Fri, 13 Jan 2012 14:13:54 +0800</pubDate><description><![CDATA[恢复dba这个role 
create role DBA; grant all privileges to dba with admin option;
必须是 sysdba的身份登陆

或者：
一哥们由于误操...]]></description><category></category></item><item><title><![CDATA[10.2.0.4 RAC CRS-0184错误 CRS 无法启动案例]]></title><link>https://blog.youkuaiyun.com/congtudi4111/article/details/100423257</link><guid>https://blog.youkuaiyun.com/congtudi4111/article/details/100423257</guid><author>congtudi4111</author><pubDate>Fri, 30 Dec 2011 16:07:40 +0800</pubDate><description><![CDATA[今天一个客户系统遇到一个问题，RAC的一个CRS节点无法启动，当然检查状态时遇到CRS-0184错误：
[root@RAC2 tmp]# /opt/Oracle/product/10.2.0/crs10g/bin/crs_...]]></description><category></category></item><item><title><![CDATA[10.2.0.4/5无法启动dbconsole问题解决]]></title><link>https://blog.youkuaiyun.com/congtudi4111/article/details/100423324</link><guid>https://blog.youkuaiyun.com/congtudi4111/article/details/100423324</guid><author>congtudi4111</author><pubDate>Fri, 02 Dec 2011 12:15:36 +0800</pubDate><description><![CDATA[在2011年新装了oracle10.2.0.5数据库，在建库最后em创建时候报错。


Starting Oracle Enterprise Manager 10g Database Control.............]]></description><category></category></item><item><title><![CDATA[Oracle 11G在用EXP 导出时，空表不能导出解决]]></title><link>https://blog.youkuaiyun.com/congtudi4111/article/details/100423252</link><guid>https://blog.youkuaiyun.com/congtudi4111/article/details/100423252</guid><author>congtudi4111</author><pubDate>Fri, 22 Jul 2011 15:53:53 +0800</pubDate><description><![CDATA[Oracle 11G在用EXP 导出时，空表不能导出解决
11G中有个新特性，当表无数据时，不分配segment，以节省空间
　　解决方法：
　　1、insert一行，再rollback就产生segment了。
　　该方...]]></description><category></category></item><item><title><![CDATA[Tuning VMM kernel parameter in AIX for Oracle]]></title><link>https://blog.youkuaiyun.com/congtudi4111/article/details/100423323</link><guid>https://blog.youkuaiyun.com/congtudi4111/article/details/100423323</guid><author>congtudi4111</author><pubDate>Mon, 02 May 2011 12:08:30 +0800</pubDate><description><![CDATA[对于运行Oracle数据库的AIX操作系统VMM（Virtual Memory Management）层面的系统内核参数如何进行调整，这是一个很古老的话题。这篇文章力图解释一些概念，同时与时俱...]]></description><category></category></item><item><title><![CDATA[PRECOMPUTE_SUBQUERY应用的一个例子（转）]]></title><link>https://blog.youkuaiyun.com/congtudi4111/article/details/100423261</link><guid>https://blog.youkuaiyun.com/congtudi4111/article/details/100423261</guid><author>congtudi4111</author><pubDate>Wed, 27 Apr 2011 16:32:19 +0800</pubDate><description><![CDATA[PRECOMPUTE_SUBQUERY应用的一个例子

http://space.itpub.net/19423/viewspace-667934
SQL&gt; select * from v$version;BANN...]]></description><category></category></item><item><title><![CDATA[利用LINUX命令bc实现进制转换（转）]]></title><link>https://blog.youkuaiyun.com/congtudi4111/article/details/100423249</link><guid>https://blog.youkuaiyun.com/congtudi4111/article/details/100423249</guid><author>congtudi4111</author><pubDate>Sun, 24 Apr 2011 18:01:24 +0800</pubDate><description><![CDATA[http://www.cnblogs.com/killkill/archive/2010/09/11/1824199.html

深入分析 Oracle 内部原理的时候不得不经常进行二进制、八进制、十进制、十六进制之间的转...]]></description><category></category></item><item><title><![CDATA[将“相关值”导致的Nested Loop优化成Hash Join (转）]]></title><link>https://blog.youkuaiyun.com/congtudi4111/article/details/100423316</link><guid>https://blog.youkuaiyun.com/congtudi4111/article/details/100423316</guid><author>congtudi4111</author><pubDate>Sun, 24 Apr 2011 16:58:17 +0800</pubDate><description><![CDATA[http://www.cnblogs.com/killkill/archive/2011/04/11/2013044.html
原文地址：http://www.itpub.net/thread-1376537-1-2.h...]]></description><category></category></item><item><title><![CDATA[Oracle sqlplus prelim 参数介绍]]></title><link>https://blog.youkuaiyun.com/congtudi4111/article/details/100423260</link><guid>https://blog.youkuaiyun.com/congtudi4111/article/details/100423260</guid><author>congtudi4111</author><pubDate>Mon, 11 Apr 2011 15:07:51 +0800</pubDate><description><![CDATA[http://blog.youkuaiyun.com/tianlesoftware/archive/2009/12/10/4980545.aspx

从Oracle10g开始，sqlplus提供了一个参数选项-prelim，用这个参数...]]></description><category></category></item><item><title><![CDATA[inside sqlplus prelim(转）]]></title><link>https://blog.youkuaiyun.com/congtudi4111/article/details/100423255</link><guid>https://blog.youkuaiyun.com/congtudi4111/article/details/100423255</guid><author>congtudi4111</author><pubDate>Mon, 11 Apr 2011 14:58:48 +0800</pubDate><description><![CDATA[http://www.laoxiong.net/inside_sqlplus_prelim.html

我们知道，在Oracle 10g中，如果数据库实例hang住了，应用及sqlplus都不能连接时，可以用sqlplus...]]></description><category></category></item><item><title><![CDATA[Causes of Oracle Buffer Busy Waits]]></title><link>https://blog.youkuaiyun.com/congtudi4111/article/details/100423259</link><guid>https://blog.youkuaiyun.com/congtudi4111/article/details/100423259</guid><author>congtudi4111</author><pubDate>Mon, 11 Apr 2011 11:40:16 +0800</pubDate><description><![CDATA[Oracle Tips by Burleson ConsultingWritten December 9, 2003Updated February 10, 2008 
 One of the most confoundin...]]></description><category></category></item><item><title><![CDATA[EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS占用大量资源]]></title><link>https://blog.youkuaiyun.com/congtudi4111/article/details/100423280</link><guid>https://blog.youkuaiyun.com/congtudi4111/article/details/100423280</guid><author>congtudi4111</author><pubDate>Wed, 02 Mar 2011 15:25:50 +0800</pubDate><description><![CDATA[EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS占用大量资源 



今天一个客户咨询，他们的RAC环境中，EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_P...]]></description><category></category></item><item><title><![CDATA[怎样保持Oracle数据库SQL性能的稳定性(转）]]></title><link>https://blog.youkuaiyun.com/congtudi4111/article/details/100423256</link><guid>https://blog.youkuaiyun.com/congtudi4111/article/details/100423256</guid><author>congtudi4111</author><pubDate>Tue, 11 Jan 2011 11:32:14 +0800</pubDate><description><![CDATA[http://www.laoxiong.net/how-keeping-sql-plan-stability.html
好文，转一下。
有客户遇到SQL性能不稳定，突然变差导致系统性能出现严重问题的情况。对于大型的系统...]]></description><category></category></item><item><title><![CDATA[ORADEBUG]]></title><link>https://blog.youkuaiyun.com/congtudi4111/article/details/100423314</link><guid>https://blog.youkuaiyun.com/congtudi4111/article/details/100423314</guid><author>congtudi4111</author><pubDate>Tue, 11 Jan 2011 11:02:42 +0800</pubDate><description><![CDATA[ORADEBUG 收藏 http://inthirties.com:90/thread-1283-1-1.html 
一、 概要 首先看看help SQL&gt; oradebug help HELP [command] ...]]></description><category></category></item><item><title><![CDATA[数据库报ORA-04030: 在尝试分配xxx 字节(kxs-heap-c,AAA)时进程内存不足]]></title><link>https://blog.youkuaiyun.com/congtudi4111/article/details/100423247</link><guid>https://blog.youkuaiyun.com/congtudi4111/article/details/100423247</guid><author>congtudi4111</author><pubDate>Thu, 30 Dec 2010 13:48:26 +0800</pubDate><description><![CDATA[10.2.0.2报ora-04030,在尝试分配xxx 字节
aix53+10.2.0.2,应用在做一个业务是，数据库报ORA-04030: 在尝试分配xxx 字节(kxs-heap-c,AAA)时进程内存不足。每次xxx是不...]]></description><category></category></item></channel></rss>