<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cser3000的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cser3000</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cser3000]]></copyright><item><title><![CDATA[Statspack_ORA-00001 奇怪的事]]></title><link>https://blog.youkuaiyun.com/cser3000/article/details/100241322</link><guid>https://blog.youkuaiyun.com/cser3000/article/details/100241322</guid><author>cser3000</author><pubDate>Fri, 21 May 2010 09:29:19 +0800</pubDate><description><![CDATA[前几天在清理了Statspack的表后出现了ORA-12012: error on auto execute of job 1[@more@]ORA-12012: error on auto execute of job 1OR...]]></description><category></category></item><item><title><![CDATA[Oracle: Grant 对high loading system，bind variable的影响]]></title><link>https://blog.youkuaiyun.com/cser3000/article/details/100241316</link><guid>https://blog.youkuaiyun.com/cser3000/article/details/100241316</guid><author>cser3000</author><pubDate>Wed, 12 May 2010 13:26:15 +0800</pubDate><description><![CDATA[前几日，海的那边的AP TEAM发来一份script，说是程序的权限控制要大改，请这边的DBA执行一下，我打开看了下，确实对很多objects的grants有很大变动。先在一个库执行了一下，顺利，10分钟run完。然后在第二个库...]]></description><category></category></item><item><title><![CDATA[ORA-00376 运气不好，遭遇这个]]></title><link>https://blog.youkuaiyun.com/cser3000/article/details/100241326</link><guid>https://blog.youkuaiyun.com/cser3000/article/details/100241326</guid><author>cser3000</author><pubDate>Wed, 21 Apr 2010 15:51:33 +0800</pubDate><description><![CDATA[今天下午，User突然反应数据都没法删除，收到他们的截图看，是ORA-00376 file 2 cannot be read at this time[@more@]然后file 2 是什么呢，一看是UNDO…去Alert.lo...]]></description><category></category></item><item><title><![CDATA[10.2.0.4 Listener 常挂掉的例子一个]]></title><link>https://blog.youkuaiyun.com/cser3000/article/details/100241321</link><guid>https://blog.youkuaiyun.com/cser3000/article/details/100241321</guid><author>cser3000</author><pubDate>Mon, 18 Jan 2010 11:02:39 +0800</pubDate><description><![CDATA[10.2.0.4的一个Data Warehouse, 最近listener常挂...[@more@]OS: RHEL4kernel: tnslsnr[5512]: segfault at 0000000000000018 rip...]]></description><category></category></item><item><title><![CDATA[Oracle 9i DataGuard Failover 发生ORA-16139]]></title><link>https://blog.youkuaiyun.com/cser3000/article/details/100241310</link><guid>https://blog.youkuaiyun.com/cser3000/article/details/100241310</guid><author>cser3000</author><pubDate>Thu, 26 Nov 2009 14:58:51 +0800</pubDate><description><![CDATA[偷懒打算用Standby DB Copy到另一台Server上做test DB.结果Failover时候发生ORA-16139 ...这个系统是Oracle9i, 10GR2之后已经不用再skip了...[@more@]Orac...]]></description><category></category></item><item><title><![CDATA[ORA-00600 [2103]的分析]]></title><link>https://blog.youkuaiyun.com/cser3000/article/details/100241318</link><guid>https://blog.youkuaiyun.com/cser3000/article/details/100241318</guid><author>cser3000</author><pubDate>Thu, 04 Jun 2009 13:33:22 +0800</pubDate><description><![CDATA[昨天下午5点有一台Production DB Crash, 去Alert.log察看发现是ORA-00600 [2103]这个ERROR我是第一次见到。[@more@]------------------------------...]]></description><category></category></item><item><title><![CDATA[Oracle多表关联更新的方式选择, Loop or Hash update?]]></title><link>https://blog.youkuaiyun.com/cser3000/article/details/100241308</link><guid>https://blog.youkuaiyun.com/cser3000/article/details/100241308</guid><author>cser3000</author><pubDate>Fri, 22 May 2009 14:42:21 +0800</pubDate><description><![CDATA[Oracle多表关联更新的方式选择。环境：Oracle 10.2.0.3 on RHEL4 X86_64SQL&gt; desc test_a;    Name                                  ...]]></description><category></category></item><item><title><![CDATA[适当采用Histogram 让Oracle达成最优Execution Plan]]></title><link>https://blog.youkuaiyun.com/cser3000/article/details/100241335</link><guid>https://blog.youkuaiyun.com/cser3000/article/details/100241335</guid><author>cser3000</author><pubDate>Thu, 23 Apr 2009 15:02:28 +0800</pubDate><description><![CDATA[某Production  DB, 主要是OLTP和一部分Report。最近由于盘点经常要出一个Report，这个Report会用对List里的COA_ITEM的每个值去捞取资料。但这个Report经常要跑很长时间。[@more@...]]></description><category></category></item><item><title><![CDATA[PL/SQL 批量Bind Forall 的性能表现]]></title><link>https://blog.youkuaiyun.com/cser3000/article/details/100241315</link><guid>https://blog.youkuaiyun.com/cser3000/article/details/100241315</guid><author>cser3000</author><pubDate>Fri, 13 Mar 2009 10:37:15 +0800</pubDate><description><![CDATA[周三 AP 人员准备对一个千万级的Table A进行Update, 要求A表中，每一行的Column MO的值要和B表中的MO值想等，对应的逻辑是A.SN=B.SN, SN是Unique。[@more@]本来他们想一个SQL搞定...]]></description><category></category></item><item><title><![CDATA[Oracle SQL Like 的优化]]></title><link>https://blog.youkuaiyun.com/cser3000/article/details/100241331</link><guid>https://blog.youkuaiyun.com/cser3000/article/details/100241331</guid><author>cser3000</author><pubDate>Wed, 21 Jan 2009 14:47:03 +0800</pubDate><description><![CDATA[这个问题首先是在TAOBAO DBA的BLOG上看到丹臣写的关于Like和INSTR的性能问题。不过他只是给出了结果。我对这个函数性能感到有趣，之前一直没有关注过，遂自己详细测试了下。[@more@]Oracle 9208:SQ...]]></description><category></category></item><item><title><![CDATA[使用ISCSI & Linux LVM2 搭建Report DB]]></title><link>https://blog.youkuaiyun.com/cser3000/article/details/100241313</link><guid>https://blog.youkuaiyun.com/cser3000/article/details/100241313</guid><author>cser3000</author><pubDate>Wed, 21 Jan 2009 10:48:59 +0800</pubDate><description><![CDATA[有一台Report DB，原先一直用本地磁盘，146G * 6 Raid 5。最近终于撑不住了，因为它的Production已经快到700GB。现在的暂行策略是把Report也放到Production上做。Production经...]]></description><category></category></item><item><title><![CDATA[Oracle Advanced Replication 1 例 9i to 10g MVR]]></title><link>https://blog.youkuaiyun.com/cser3000/article/details/100241305</link><guid>https://blog.youkuaiyun.com/cser3000/article/details/100241305</guid><author>cser3000</author><pubDate>Wed, 14 Jan 2009 14:01:12 +0800</pubDate><description><![CDATA[这个例子很简单，9i to 10g只有一个Table, Single Master Site。是近期的一个应用需求，顺便把当时的一些步骤记录下。而且测试下了，GLOBAL_NAME=FALSE也是可以的，但跟一个资深DBA聊起来...]]></description><category></category></item><item><title><![CDATA[遇到关于Sequence的 ORA-08002]]></title><link>https://blog.youkuaiyun.com/cser3000/article/details/100241300</link><guid>https://blog.youkuaiyun.com/cser3000/article/details/100241300</guid><author>cser3000</author><pubDate>Fri, 09 Jan 2009 16:47:39 +0800</pubDate><description><![CDATA[遇到关于Sequence的 ORA-08002[@more@]ORA-08002: sequence SEQ_TEST_ID.CURRVAL is not yet defined in this session.查了下，原来是这...]]></description><category></category></item><item><title><![CDATA[偶遇ORA-00059: maximum number of DB_FILES exceeded]]></title><link>https://blog.youkuaiyun.com/cser3000/article/details/100241327</link><guid>https://blog.youkuaiyun.com/cser3000/article/details/100241327</guid><author>cser3000</author><pubDate>Tue, 23 Dec 2008 13:51:41 +0800</pubDate><description><![CDATA[今天为A 系统09年一季度的Partitioned Table加新的Partitions.正在加new tablespace的时侯，ORA-00059: maximum number of DB_FILES exceeded[@...]]></description><category></category></item><item><title><![CDATA[由最长SQL想到的Latch Free( Library Cache Pin/Lock)整理~~草稿]]></title><link>https://blog.youkuaiyun.com/cser3000/article/details/100241324</link><guid>https://blog.youkuaiyun.com/cser3000/article/details/100241324</guid><author>cser3000</author><pubDate>Mon, 03 Nov 2008 14:03:03 +0800</pubDate><description><![CDATA[今天回想这中间的过程：这句SQL 导致Parse，execute占用大量资源，Parse的过程需要一直持有Library Cache，而Library Cache Latch的个数是有限的，这点引起了Library Cache的...]]></description><category></category></item><item><title><![CDATA[迄今见到最长的SQL...滥用Union]]></title><link>https://blog.youkuaiyun.com/cser3000/article/details/100241307</link><guid>https://blog.youkuaiyun.com/cser3000/article/details/100241307</guid><author>cser3000</author><pubDate>Mon, 03 Nov 2008 13:57:27 +0800</pubDate><description><![CDATA[上周，Production DB A的user 反应他们作业的速度变得很慢。这台DB用的是IBM X3850 16Core 2.93Ghz 16GB Memory AMS Storage，平时Performance表现十分良好，...]]></description><category></category></item><item><title><![CDATA[使用DBMS_STATS收集系统状态]]></title><link>https://blog.youkuaiyun.com/cser3000/article/details/100241339</link><guid>https://blog.youkuaiyun.com/cser3000/article/details/100241339</guid><author>cser3000</author><pubDate>Thu, 23 Oct 2008 08:40:43 +0800</pubDate><description><![CDATA[DBMS_STATS.GATHER_SYSTEM_STATS[@more@]不建立Stattab:ShXXXX SQL&gt; show parameter job;                       NAME    ...]]></description><category></category></item><item><title><![CDATA[Hash join semi带来的temp tablespace使用过度问题-Part1]]></title><link>https://blog.youkuaiyun.com/cser3000/article/details/100241304</link><guid>https://blog.youkuaiyun.com/cser3000/article/details/100241304</guid><author>cser3000</author><pubDate>Thu, 25 Sep 2008 15:07:40 +0800</pubDate><description><![CDATA[前日，Production DB N突然反应变慢(RHEL4UP4,9208,64bit,MTS mode)用top –d 1 察看，发现CPU usage大约在40%~70%间浮动，IOWAIT大约在4%~9%左右。Sys使用...]]></description><category></category></item><item><title><![CDATA[Oracle Partitioned Table：exchange的利用]]></title><link>https://blog.youkuaiyun.com/cser3000/article/details/100241323</link><guid>https://blog.youkuaiyun.com/cser3000/article/details/100241323</guid><author>cser3000</author><pubDate>Wed, 17 Sep 2008 09:14:06 +0800</pubDate><description><![CDATA[周末作了一天的Partitioned Table旧有资料的归档。主要是用Partitioned Table的Exchange功能。[@more@]基本步骤：1． 构造能用来做exchange的table A。2． 进行excha...]]></description><category></category></item><item><title><![CDATA[Oracle SQL 'or' 的优化，最近的案例一则。]]></title><link>https://blog.youkuaiyun.com/cser3000/article/details/100241302</link><guid>https://blog.youkuaiyun.com/cser3000/article/details/100241302</guid><author>cser3000</author><pubDate>Tue, 22 Jul 2008 13:12:01 +0800</pubDate><description><![CDATA[Oracle 中or是可以用union/union all来作优化的[@more@]SQL Tuning之 OR的优化。今天公司某Production DB时常LOADING飚起来，Monitor下发现一个很high的SQL:S...]]></description><category></category></item></channel></rss>