<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cjysdw2000的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cjysdw2000</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cjysdw2000]]></copyright><item><title><![CDATA[11gR1 optimizer key changes]]></title><link>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293384</link><guid>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293384</guid><author>cjysdw2000</author><pubDate>Thu, 17 Dec 2009 03:15:11 +0800</pubDate><description><![CDATA[What the new 11gR1 RDBMS changes benefit our application, you can read the article for a taste[@more@]Architecture...]]></description><category></category></item><item><title><![CDATA[SQL PERFORMANCE ANALYZER, a great tool for upgrade testing tuning and benchmark check]]></title><link>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293389</link><guid>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293389</guid><author>cjysdw2000</author><pubDate>Tue, 28 Jul 2009 07:00:21 +0800</pubDate><description><![CDATA[Changes that affect SQL execution plans, such as upgrading a database or addingnew indexes, can severely impact SQ...]]></description><category></category></item><item><title><![CDATA[ASCII in oracle, masking power on]]></title><link>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293390</link><guid>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293390</guid><author>cjysdw2000</author><pubDate>Thu, 05 Feb 2009 01:55:00 +0800</pubDate><description><![CDATA[ASCII: function converts a single character to its corresponding ASCII code.[@more@]CHARASCIICHARASCIICHARASCIINul...]]></description><category></category></item><item><title><![CDATA[On Dynamic Sampling]]></title><link>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293386</link><guid>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293386</guid><author>cjysdw2000</author><pubDate>Sat, 24 Jan 2009 04:12:50 +0800</pubDate><description><![CDATA[There are two ways to use dynamic sampling: The OPTIMIZER_DYNAMIC_SAMPLING parameter can be set at the database in...]]></description><category></category></item><item><title><![CDATA[tnsping: NL-00605: national language initialization failed  sqlplus Error 5]]></title><link>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293417</link><guid>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293417</guid><author>cjysdw2000</author><pubDate>Tue, 06 Jan 2009 07:15:11 +0800</pubDate><description><![CDATA[wbiadm@wbidevrk1p:[/home/wbiadm]# tnspingNL-00605: national language initialization failedNL-00605: national langu...]]></description><category></category></item><item><title><![CDATA[push_pred, a powerful hint to speed up you inline view query 10X times]]></title><link>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293381</link><guid>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293381</guid><author>cjysdw2000</author><pubDate>Tue, 12 Aug 2008 06:22:23 +0800</pubDate><description><![CDATA[when we need to use it:Instructs the optimizer to push a join predicate into the view.condition: non-mergeable vie...]]></description><category></category></item><item><title><![CDATA[A taste of SQL Performance Analyzer in oracle 11g]]></title><link>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293383</link><guid>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293383</guid><author>cjysdw2000</author><pubDate>Sat, 02 Aug 2008 03:31:12 +0800</pubDate><description><![CDATA[we got a case when trying to change a table property, before we need to do thorough testing by collecting all rela...]]></description><category></category></item><item><title><![CDATA[steps to do real time apply in oracle 11g]]></title><link>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293416</link><guid>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293416</guid><author>cjysdw2000</author><pubDate>Wed, 23 Jul 2008 07:48:48 +0800</pubDate><description><![CDATA[the feature can make 11g standby database more powerful and flexible[@more@]real time apply:before:check log file:...]]></description><category></category></item><item><title><![CDATA[ORA-00604,ORA-01115,ORA-01110,ORA-27091,ORA-27072,IBM AIX RISC System/6000 Error]]></title><link>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293413</link><guid>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293413</guid><author>cjysdw2000</author><pubDate>Fri, 02 May 2008 07:06:27 +0800</pubDate><description><![CDATA[ORA-00604: error occurred at recursive SQL level 1ORA-01115: IO error reading block from file 1 (block # 81)ORA-01...]]></description><category></category></item><item><title><![CDATA[A more detailed threshold we should monitor on UNIX side]]></title><link>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293382</link><guid>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293382</guid><author>cjysdw2000</author><pubDate>Tue, 22 Apr 2008 04:49:44 +0800</pubDate><description><![CDATA[this is an example of SUN solaris data, it may be a bit different on other platform.FYI:[@more@]The iostat output ...]]></description><category></category></item><item><title><![CDATA[V$sort_usage, where is the definition?]]></title><link>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293378</link><guid>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293378</guid><author>cjysdw2000</author><pubDate>Tue, 22 Jan 2008 02:20:52 +0800</pubDate><description><![CDATA[GV$SORT_USAGEyou may need it sometimes when your temp gets blew without any reason during the nite :-)[@more@]sele...]]></description><category></category></item><item><title><![CDATA[ORA-00600: internal error code, arguments: [qkaffsindex3], [], [], [], [], [], [], []]]></title><link>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293376</link><guid>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293376</guid><author>cjysdw2000</author><pubDate>Tue, 20 Nov 2007 07:35:29 +0800</pubDate><description><![CDATA[SQL&gt; select * from V$version;BANNER----------------------------------------------------------------Oracle Datab...]]></description><category></category></item><item><title><![CDATA[best practice of rebuild your partition table local index online by using: "update indexes"]]></title><link>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293380</link><guid>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293380</guid><author>cjysdw2000</author><pubDate>Fri, 16 Nov 2007 09:25:20 +0800</pubDate><description><![CDATA[The following operations support the UPDATE INDEXES clause:ADD PARTITION | SUBPARTITIONCOALESCE PARTITION | SUBPAR...]]></description><category></category></item><item><title><![CDATA[X$ table, how many you know?]]></title><link>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293418</link><guid>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293418</guid><author>cjysdw2000</author><pubDate>Sat, 27 Oct 2007 02:23:14 +0800</pubDate><description><![CDATA[X$ Table This is a summary list of X$ table definitions. The last revision was for Oracle 7.3.2, however, the list...]]></description><category></category></item><item><title><![CDATA[how to use oidpasswd to admin your AS/OID account]]></title><link>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293412</link><guid>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293412</guid><author>cjysdw2000</author><pubDate>Sun, 21 Oct 2007 22:46:13 +0800</pubDate><description><![CDATA[got an issue that my orcladmin account was not able to login. Here is the approach to reset it:donot get panic whe...]]></description><category></category></item><item><title><![CDATA[appworx nutshell:]]></title><link>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293379</link><guid>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293379</guid><author>cjysdw2000</author><pubDate>Tue, 18 Sep 2007 01:40:54 +0800</pubDate><description><![CDATA[when change of fail-over host:change the entry accordingly$ pwd/u01/home/aw/site$ cat sosite# Copyright 1992-2003 ...]]></description><category></category></item><item><title><![CDATA[stream step-by-step]]></title><link>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293377</link><guid>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293377</guid><author>cjysdw2000</author><pubDate>Sat, 15 Sep 2007 09:42:34 +0800</pubDate><description><![CDATA[no time to read the manual but want to taste how stream works. here is what you can go through in 30min.[@more@]st...]]></description><category></category></item><item><title><![CDATA[rman and archive log variable and meanings:]]></title><link>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293373</link><guid>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293373</guid><author>cjysdw2000</author><pubDate>Thu, 06 Sep 2007 03:01:08 +0800</pubDate><description><![CDATA[archivelog format：(9i,10g)%s log sequence number%S log sequence number, zero filled%t thread number%T thread numbe...]]></description><category></category></item><item><title><![CDATA[system tuning and analysis:]]></title><link>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293368</link><guid>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293368</guid><author>cjysdw2000</author><pubDate>Mon, 03 Sep 2007 16:48:43 +0800</pubDate><description><![CDATA[The areas you'll want to review and monitor on your database server using Unix utilities are:CPU performance. How ...]]></description><category></category></item><item><title><![CDATA[SUID and SGID:  -rwsr-xr-x Unix file permission]]></title><link>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293369</link><guid>https://blog.youkuaiyun.com/cjysdw2000/article/details/100293369</guid><author>cjysdw2000</author><pubDate>Sat, 01 Sep 2007 06:48:21 +0800</pubDate><description><![CDATA[Everybody handling a Unix operating system would very well know what chmod 777 means. That the owner, group and th...]]></description><category></category></item></channel></rss>