<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/congche1987</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; congche1987]]></copyright><item><title><![CDATA[rownum取值影响组合索引的使用]]></title><link>https://blog.youkuaiyun.com/congche1987/article/details/100360653</link><guid>https://blog.youkuaiyun.com/congche1987/article/details/100360653</guid><author>congche1987</author><pubDate>Tue, 24 Apr 2012 15:25:22 +0800</pubDate><description><![CDATA[创建一个组合索引，分别运行两个SQL,SQL唯一不同的地方是rownum&lt;20和rownum&lt;200

create index IDX_TEL_ZU
on t_s_Tel_Reco...]]></description><category></category></item><item><title><![CDATA[SQL优化--not in和or出的问题]]></title><link>https://blog.youkuaiyun.com/congche1987/article/details/100360650</link><guid>https://blog.youkuaiyun.com/congche1987/article/details/100360650</guid><author>congche1987</author><pubDate>Thu, 19 Apr 2012 14:49:34 +0800</pubDate><description><![CDATA[开发发来一条SQL，出了几行数据，要跑40多秒，让优化下原SQL如下SQL&gt; explain plan for 2  2 /* Formatted on 2012/04/19 14:11 (Formatt...]]></description><category></category></item><item><title><![CDATA[SQL优化--用各种hints优化一条SQL]]></title><link>https://blog.youkuaiyun.com/congche1987/article/details/100360651</link><guid>https://blog.youkuaiyun.com/congche1987/article/details/100360651</guid><author>congche1987</author><pubDate>Mon, 16 Apr 2012 14:21:15 +0800</pubDate><description><![CDATA[oracle 10g R2加各种hints优化一条SQL：Select Count(*) From t_Ho_Order_Statistics --2032946Select ...]]></description><category></category></item><item><title><![CDATA[外键引起的锁]]></title><link>https://blog.youkuaiyun.com/congche1987/article/details/100360718</link><guid>https://blog.youkuaiyun.com/congche1987/article/details/100360718</guid><author>congche1987</author><pubDate>Thu, 12 Apr 2012 16:11:20 +0800</pubDate><description><![CDATA[环境：

emp上面有外键FK_deptno,它参考了dept表上的dpetno列，在oracle 10g R2下



以下会话按顺序执行

--------------------------...]]></description><category></category></item><item><title><![CDATA[转载-oracle Shrink命令的使用]]></title><link>https://blog.youkuaiyun.com/congche1987/article/details/100360648</link><guid>https://blog.youkuaiyun.com/congche1987/article/details/100360648</guid><author>congche1987</author><pubDate>Thu, 12 Apr 2012 10:50:06 +0800</pubDate><description><![CDATA[从10g开始，oracle开始提供Shrink的命令，假如我们的表空间中支持自动段空间管理 (ASSM),就可以使用这个特性缩小段，即降低HWM。

Shrink的两大功能

1、降低高水...]]></description><category></category></item><item><title><![CDATA[ITL]]></title><link>https://blog.youkuaiyun.com/congche1987/article/details/100360593</link><guid>https://blog.youkuaiyun.com/congche1987/article/details/100360593</guid><author>congche1987</author><pubDate>Wed, 11 Apr 2012 16:59:04 +0800</pubDate><description><![CDATA[查看T2的事务槽Select aa.ini_trans,aa.max_trans From dba_tables aa Where table_name='T2'Create Table t10(Id Int);Ins...]]></description><category></category></item><item><title><![CDATA[转载--sequence向后推]]></title><link>https://blog.youkuaiyun.com/congche1987/article/details/100360738</link><guid>https://blog.youkuaiyun.com/congche1987/article/details/100360738</guid><author>congche1987</author><pubDate>Fri, 06 Apr 2012 17:29:45 +0800</pubDate><description><![CDATA[昨天导入一个数据库，用户反映导过来的有sequence要小于已经导入到表中的sequence的值。原因生产数据中seq导入的时候可能在操作，导致出现一些重复的出现。为了解决这个问题，我把当前用户下所有的sequence全部向后延...]]></description><category></category></item><item><title><![CDATA[参数cursor_sharing]]></title><link>https://blog.youkuaiyun.com/congche1987/article/details/100360589</link><guid>https://blog.youkuaiyun.com/congche1987/article/details/100360589</guid><author>congche1987</author><pubDate>Fri, 06 Apr 2012 17:27:11 +0800</pubDate><description><![CDATA[SQL&gt; show parameter cursor_sharing;NAME                 TYPE    VALUE----------------...]]></description><category></category></item><item><title><![CDATA[rebuild index]]></title><link>https://blog.youkuaiyun.com/congche1987/article/details/100360592</link><guid>https://blog.youkuaiyun.com/congche1987/article/details/100360592</guid><author>congche1987</author><pubDate>Fri, 06 Apr 2012 17:25:32 +0800</pubDate><description><![CDATA[-
rebuild offline时，选择的6模式的X
锁，它根据old index 来rebuild。
因此不允许进行DML，也就没有中间表。因此也比较块。

-
re...]]></description><category></category></item><item><title><![CDATA[参数 optimizer_index_cost_adj]]></title><link>https://blog.youkuaiyun.com/congche1987/article/details/100360616</link><guid>https://blog.youkuaiyun.com/congche1987/article/details/100360616</guid><author>congche1987</author><pubDate>Fri, 06 Apr 2012 17:23:23 +0800</pubDate><description><![CDATA[SQL&gt; show parameter
index;

 

NAME...]]></description><category></category></item><item><title><![CDATA[nologgin和append]]></title><link>https://blog.youkuaiyun.com/congche1987/article/details/100360655</link><guid>https://blog.youkuaiyun.com/congche1987/article/details/100360655</guid><author>congche1987</author><pubDate>Fri, 06 Apr 2012 17:03:47 +0800</pubDate><description><![CDATA[-nologging:

打开了nologging,在归档和非归档模式下都有只有append才能减少redo的生成.



-hints append :

使用append hint...]]></description><category></category></item><item><title><![CDATA[删除大表T_HP_PRODUCT]]></title><link>https://blog.youkuaiyun.com/congche1987/article/details/100360652</link><guid>https://blog.youkuaiyun.com/congche1987/article/details/100360652</guid><author>congche1987</author><pubDate>Fri, 06 Apr 2012 16:57:32 +0800</pubDate><description><![CDATA[删除一张大表的过程

1,直接删除，删除4万行用了半小时

2,建好表结构（包括索引和约束），然后insert
,,, As Select * From ,这种方式将undo插入满了，虽然我这里用的...]]></description><category></category></item><item><title><![CDATA[转载--直接路径插入]]></title><link>https://blog.youkuaiyun.com/congche1987/article/details/100360590</link><guid>https://blog.youkuaiyun.com/congche1987/article/details/100360590</guid><author>congche1987</author><pubDate>Mon, 19 Mar 2012 15:29:55 +0800</pubDate><description><![CDATA[一、直接路径插入与间接路径插入的不同这个问题相信很多人都已经知道了，为了方便初学者，我再来重审一遍。create table 表1 as select 列1，列2，... select 表2insert /...]]></description><category></category></item><item><title><![CDATA[转载--游标使用全解]]></title><link>https://blog.youkuaiyun.com/congche1987/article/details/100360615</link><guid>https://blog.youkuaiyun.com/congche1987/article/details/100360615</guid><author>congche1987</author><pubDate>Thu, 01 Mar 2012 13:45:40 +0800</pubDate><description><![CDATA[-- 声明游标；CURSOR cursor_name IS select_statement--For 循环游标--（1）定义游标--（2）定义游标变量--（3）使用for循环来使用这个游标declare       --类型定...]]></description><category></category></item><item><title><![CDATA[转载--事务隔离]]></title><link>https://blog.youkuaiyun.com/congche1987/article/details/100360584</link><guid>https://blog.youkuaiyun.com/congche1987/article/details/100360584</guid><author>congche1987</author><pubDate>Tue, 28 Feb 2012 14:50:49 +0800</pubDate><description><![CDATA[最近我们的一套总是报 ORA-08177: 无法连续访问此事务处理，刚开始以为是系统压力大，并发一起的，但最近发现，及时系统压力小时，也会报这个错误，于是上网仔细查找，发现下面的文章，让我收益非浅　　今天在消息的接受日志中，发现...]]></description><category></category></item><item><title><![CDATA[SQL优化--强制走索引失效的情况]]></title><link>https://blog.youkuaiyun.com/congche1987/article/details/100360588</link><guid>https://blog.youkuaiyun.com/congche1987/article/details/100360588</guid><author>congche1987</author><pubDate>Mon, 27 Feb 2012 17:06:48 +0800</pubDate><description><![CDATA[select count(0) from creditguarantee cg where 1=1     and cg.createddate&gt;=to_date('2012-02-23','yyyy-MM-d...]]></description><category></category></item><item><title><![CDATA[转载--oracle DML锁]]></title><link>https://blog.youkuaiyun.com/congche1987/article/details/100360686</link><guid>https://blog.youkuaiyun.com/congche1987/article/details/100360686</guid><author>congche1987</author><pubDate>Thu, 16 Feb 2012 10:25:35 +0800</pubDate><description><![CDATA[Oracle多粒度封锁机制研究

1引言—数据库锁的基本概念

为了确保并发用户在存取同一数据库对象时的正确性（即无丢失修改、可重复读、不读“脏”数据），数据库中引入了锁机制。基本的锁类型有两种：...]]></description><category></category></item><item><title><![CDATA[停掉oracle自带job]]></title><link>https://blog.youkuaiyun.com/congche1987/article/details/100360595</link><guid>https://blog.youkuaiyun.com/congche1987/article/details/100360595</guid><author>congche1987</author><pubDate>Thu, 02 Feb 2012 15:18:48 +0800</pubDate><description><![CDATA[状况，昨晚10点有发生前天性能问题，又重新收集了一下就好了，这个时间点就可以定位到是oracle自带的job收集统计信息是有问题的oracle的自动信息收集功能是通过一个叫GATHER_STATS_JOB的任务来完成的，该任务调...]]></description><category></category></item><item><title><![CDATA[oracle 误删除的处理方法]]></title><link>https://blog.youkuaiyun.com/congche1987/article/details/100360642</link><guid>https://blog.youkuaiyun.com/congche1987/article/details/100360642</guid><author>congche1987</author><pubDate>Thu, 02 Feb 2012 14:23:24 +0800</pubDate><description><![CDATA[这里简单的描述一下to_timestamp的用法，在测试库上面，经常会有开发人员误删除或修改一些数据，并且已经提交。方法如下：
			
			SQL&gt; select * from emp;EMPNO E...]]></description><category></category></item><item><title><![CDATA[ORA-09817  trace文件目录满了]]></title><link>https://blog.youkuaiyun.com/congche1987/article/details/100360586</link><guid>https://blog.youkuaiyun.com/congche1987/article/details/100360586</guid><author>congche1987</author><pubDate>Thu, 19 Jan 2012 16:10:14 +0800</pubDate><description><![CDATA[今天上午导收银监控例行报表，时间写的是2012-01-06到2012-01-12，在pl/sql运行，结果报错，错误为ORA-29701：unable to connect to cluster manager，网上说这可能是一...]]></description><category></category></item></channel></rss>