<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cnmcsdn8786的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cnmcsdn8786</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cnmcsdn8786]]></copyright><item><title><![CDATA[Setup RAC on Vmware(raw device)]]></title><link>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356805</link><guid>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356805</guid><author>cnmcsdn8786</author><pubDate>Thu, 10 Nov 2011 08:46:09 +0800</pubDate><description><![CDATA[Setup RAC on Vmware(raw device)
			
			
			
			
			
			
			其中有些可斟酌的地方。Setup RAC on Vmware(raw device)....]]></description><category></category></item><item><title><![CDATA[Linux AS 4.0下Oracle10g RAC搭建(虚拟机+裸设备)]]></title><link>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356780</link><guid>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356780</guid><author>cnmcsdn8786</author><pubDate>Thu, 10 Nov 2011 08:36:21 +0800</pubDate><description><![CDATA[同事做的一份文档，拿来记录一下，以便后续能够做参考查询：
			
			Linux AS 4.0下Oracle10g RAC搭建(虚拟机+裸设备)Linux AS 4.0 ,  Oracle 10.2.0.4....]]></description><category></category></item><item><title><![CDATA[每天检查DG的简单脚本]]></title><link>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356806</link><guid>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356806</guid><author>cnmcsdn8786</author><pubDate>Thu, 08 Sep 2011 15:23:20 +0800</pubDate><description><![CDATA[source /home/oracle/.bash_profileecho "sqlplus -S '/as sysdba' &lt;alter session set nls_date_format='yyyy-mm-dd h...]]></description><category></category></item><item><title><![CDATA[简单记录一下每天检查正式Server的一个脚本]]></title><link>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356775</link><guid>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356775</guid><author>cnmcsdn8786</author><pubDate>Thu, 08 Sep 2011 15:19:18 +0800</pubDate><description><![CDATA[source /home/oracle/.bash_profileecho "echo "echo "echo "echo "echo "echo "echo "sqlplus -S '/as sysdba' &lt;...]]></description><category></category></item><item><title><![CDATA[SQL Server 2008连接Oracle 11G RAC执行Package报错]]></title><link>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356774</link><guid>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356774</guid><author>cnmcsdn8786</author><pubDate>Fri, 01 Jul 2011 10:36:58 +0800</pubDate><description><![CDATA[Juarez PCE OTS 10.13.8.96Server Name : MXOSV-OTSDB02Job Name : TO_OTS
Job Status : FailedDateTime : 20100601 10...]]></description><category></category></item><item><title><![CDATA[11g 数据库连接报用户密码错]]></title><link>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356807</link><guid>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356807</guid><author>cnmcsdn8786</author><pubDate>Wed, 22 Jun 2011 15:20:38 +0800</pubDate><description><![CDATA[前几天配置了一个11G的RAC架构，今天程式测试连接报用户密码错误：
			
			ORA-01017: invalid username/password; logon denied ORA-02063: precedin...]]></description><category></category></item><item><title><![CDATA[oracle数据库的两个基本log自动切换设置]]></title><link>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356770</link><guid>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356770</guid><author>cnmcsdn8786</author><pubDate>Thu, 13 Jan 2011 08:13:20 +0800</pubDate><description><![CDATA[以下我们对oracle数据库的两个基本log进行轮询.具体操作如下:我们需要在 /etc/logrotate.d目录下面配置一个文件，操作如下(root用户操作):# cd /etc/logrotate.d# touch ora...]]></description><category></category></item><item><title><![CDATA[How to Rsync over SSH without a password]]></title><link>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356767</link><guid>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356767</guid><author>cnmcsdn8786</author><pubDate>Thu, 13 Jan 2011 08:11:10 +0800</pubDate><description><![CDATA[Howto Rsync over SSH without a password.1. Log into the TARGET host, and generate an RSA (public and private) key...]]></description><category></category></item><item><title><![CDATA[Oracle直方图解析 ---转]]></title><link>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100509525</link><guid>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100509525</guid><author>cnmcsdn8786</author><pubDate>Fri, 07 Jan 2011 15:05:55 +0800</pubDate><description><![CDATA[一、  何谓直方图：直方图是一种统计学上的工具，并非Oracle专有。通常用于对被管理对象的某个方面的质量情况进行管理，通常情况下它会表现为一种几何图形表，这个图形表是根据从实际环境中所收集来的被管理对象某个方面的质量分布情...]]></description><category></category></item><item><title><![CDATA[oracle 10g logmnr使用---转]]></title><link>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356773</link><guid>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356773</guid><author>cnmcsdn8786</author><pubDate>Fri, 29 Oct 2010 09:11:02 +0800</pubDate><description><![CDATA[一.安装LogMiner
$ sqlplus /nolog
SQL*Plus: Release 10.2.0.3.0 - Production on Tue Apr 15 12:30:58 2008
Copyright (...]]></description><category></category></item><item><title><![CDATA[Oracle 10g Shrink Table 详解---转]]></title><link>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356762</link><guid>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356762</guid><author>cnmcsdn8786</author><pubDate>Thu, 15 Jul 2010 16:18:50 +0800</pubDate><description><![CDATA[从10g开始，oracle开始提供Shrink的命令，假如我们的表空间中支持自动段空间管理 (ASSM),就可以使用这个特性缩小段，即降低HWM。这里需要强调一点，10g的这个新特性，仅对ASSM表空间有效，否则会报 ...]]></description><category></category></item><item><title><![CDATA[SQL重复记录查询---转]]></title><link>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356768</link><guid>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356768</guid><author>cnmcsdn8786</author><pubDate>Thu, 01 Jul 2010 15:33:58 +0800</pubDate><description><![CDATA[反复记录分为两种，第一种是完全反复的记录，也就是所有字段均反复的记录，第二种是部分要害字段反复的记录，例如Name字段反复，而其它字段不一定反复或都反复。1、第一种反复很轻易解决，不同数据库环境下方法相似：Mysqlc...]]></description><category></category></item><item><title><![CDATA[oracle HINTS 的使用]]></title><link>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356771</link><guid>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356771</guid><author>cnmcsdn8786</author><pubDate>Tue, 04 May 2010 13:34:03 +0800</pubDate><description><![CDATA[摘自徐玉金的&lt;&gt;
如何使用hints: Hints只应用在它们所在sql语句块(statement block，由select、update、delete关键字标识)上，对其它SQL语句或语句的其它部分没有影响。如...]]></description><category></category></item><item><title><![CDATA[Oracle job 相关]]></title><link>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356798</link><guid>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356798</guid><author>cnmcsdn8786</author><pubDate>Thu, 08 Apr 2010 10:12:25 +0800</pubDate><description><![CDATA[DBA_JOBS＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝字段（列） 类型 描述JOBNUMBER 任务的唯一标示号LOG_USER VARCHAR2(30) 提交任务的用户P...]]></description><category></category></item><item><title><![CDATA[转---收集oracle统计信息]]></title><link>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356763</link><guid>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356763</guid><author>cnmcsdn8786</author><pubDate>Wed, 10 Mar 2010 11:13:58 +0800</pubDate><description><![CDATA[优化器统计范围：
表统计； --行数，块数，行平均长度；all_tables：NUM_ROWS，BLOCKS，AVG_ROW_LEN；列统计； --列中唯一值的数量（NDV），NULL值的数量，数据分布；...]]></description><category></category></item><item><title><![CDATA[oracle buffer cache的优化]]></title><link>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356784</link><guid>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356784</guid><author>cnmcsdn8786</author><pubDate>Tue, 02 Mar 2010 09:54:17 +0800</pubDate><description><![CDATA[配置和使用buffer cache 通过以下两种方式调整大小： V$DB_CACHE_ADVICE / buffer cache hit ratio 1) V$DB_CACHE_ADVICE: 当DB_CACHE_ADVICE＝...]]></description><category></category></item><item><title><![CDATA[记录一下oracle 常见等待事件及处理方法]]></title><link>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356799</link><guid>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356799</guid><author>cnmcsdn8786</author><pubDate>Tue, 02 Mar 2010 09:02:35 +0800</pubDate><description><![CDATA[我们可以通过视图v$session_wait来查看系统当前的等待事件，以及与等待事件相对应的资源的相关信息，从而可确定出产生瓶颈的类型及其对象。v$session_wait的p1、p2、p3告诉我们等待事件的具体含义，根据事件不...]]></description><category></category></item><item><title><![CDATA[转帖---oracle 索引何时需要重建问题的解决]]></title><link>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356797</link><guid>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356797</guid><author>cnmcsdn8786</author><pubDate>Thu, 25 Feb 2010 11:09:44 +0800</pubDate><description><![CDATA[关于索引何时需要重建，我在oracle文档中还没找到明确的说法，但可以通过一个视图（index_stats），参考里面的数值来判断是否需要重建。select name,del_lf_rows,lf_rows, round(del...]]></description><category></category></item><item><title><![CDATA[转帖---sqlplus下使用copy命令]]></title><link>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356795</link><guid>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356795</guid><author>cnmcsdn8786</author><pubDate>Tue, 23 Feb 2010 10:02:39 +0800</pubDate><description><![CDATA[从圈子中看到一篇文章，怕忘记，特记录在自己的空间中。原帖地址：http://space.itpub.net/12932950/viewspace-627501
我们知道，通常情况下，我们要从一个数据库复制数据到另一个数据库或者...]]></description><category></category></item><item><title><![CDATA[转载---Oracle OMF管理 数据文件,redo文件]]></title><link>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356796</link><guid>https://blog.youkuaiyun.com/cnmcsdn8786/article/details/100356796</guid><author>cnmcsdn8786</author><pubDate>Thu, 18 Feb 2010 15:48:27 +0800</pubDate><description><![CDATA[OMF管理文件 和手动管理文件比较 手动管理文件 需要手动指定文件存储位置,包括名字,路径,而ORACLE-MANAGE-FILE 这一切就交给数据库系统...]]></description><category></category></item></channel></rss>