<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/citan5439</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; citan5439]]></copyright><item><title><![CDATA[Oracle11gR2 性能KPI 定义规则]]></title><link>https://blog.youkuaiyun.com/citan5439/article/details/100247537</link><guid>https://blog.youkuaiyun.com/citan5439/article/details/100247537</guid><author>citan5439</author><pubDate>Wed, 28 Oct 2015 08:43:23 +0800</pubDate><description><![CDATA[Oracle11gR2 性能KPI 定义规则

整体性能KPI

	整体KPI根据实例运行效率计算得到一定时间内的效率值，可以通过对比运行环境等信息比较直观反映系统是否存在问题。 





整体效率KPI...]]></description><category></category></item><item><title><![CDATA[通过修改log_archive_dest_state_n参数的状态来控制主库的日志文件传输]]></title><link>https://blog.youkuaiyun.com/citan5439/article/details/100247593</link><guid>https://blog.youkuaiyun.com/citan5439/article/details/100247593</guid><author>citan5439</author><pubDate>Thu, 24 Sep 2015 14:29:56 +0800</pubDate><description><![CDATA[Attribute
				
				
					Description
				
			
		
		
			
				
					
	...]]></description><category></category></item><item><title><![CDATA[oracle   has a disk HB, but no network HB, DHB has r cfg , wrtcnt]]></title><link>https://blog.youkuaiyun.com/citan5439/article/details/100247538</link><guid>https://blog.youkuaiyun.com/citan5439/article/details/100247538</guid><author>citan5439</author><pubDate>Tue, 23 Jun 2015 15:27:50 +0800</pubDate><description><![CDATA[“oracle node 1, rac0101, has a disk HB, but no network HB, DHB has r cfg , wrtcnt”

db突然停止运行
alert.log
Archiv...]]></description><category></category></item><item><title><![CDATA[ORACLE 12C EM Express]]></title><link>https://blog.youkuaiyun.com/citan5439/article/details/100247536</link><guid>https://blog.youkuaiyun.com/citan5439/article/details/100247536</guid><author>citan5439</author><pubDate>Wed, 27 May 2015 17:42:34 +0800</pubDate><description><![CDATA[ORACLE 12C的Enterprise Manager Database Express 12c相对于11G和10G的Enterprise Manager,从功能上说确实精简了很多,比如不支持在线查看AWR,不支持在线...]]></description><category></category></item><item><title><![CDATA[expdp impdp中 exclude/include 的使用]]></title><link>https://blog.youkuaiyun.com/citan5439/article/details/100247534</link><guid>https://blog.youkuaiyun.com/citan5439/article/details/100247534</guid><author>citan5439</author><pubDate>Mon, 25 May 2015 16:38:17 +0800</pubDate><description><![CDATA[exclude和include参数能够在使用expdp或impdp是对特定的对象或对象类型进行筛选或过滤。比如因工作的需要导出特定的表或不导出特定
的表、视图以及存储过程、索引、约束、授权统计信息等等。下面将给出expd...]]></description><category></category></item><item><title><![CDATA[【概念】为什么有时全表扫描比通过索引扫描效率更高]]></title><link>https://blog.youkuaiyun.com/citan5439/article/details/100247532</link><guid>https://blog.youkuaiyun.com/citan5439/article/details/100247532</guid><author>citan5439</author><pubDate>Wed, 04 Mar 2015 15:35:08 +0800</pubDate><description><![CDATA[伟大的Oracle SQL优化器可以判断出在某些情况下，使用全表扫描比使用索引扫描能更快的得到数据结果。
有没有想过，她是怎么做到的呢？
背后的原理是什么呢？

举一个非常好理解的场景（scenario：通过索引读取表中...]]></description><category></category></item><item><title><![CDATA[在装完Linux系统之后自己去修改Swap分区的大小(两种方法)]]></title><link>https://blog.youkuaiyun.com/citan5439/article/details/100247531</link><guid>https://blog.youkuaiyun.com/citan5439/article/details/100247531</guid><author>citan5439</author><pubDate>Mon, 02 Mar 2015 15:00:47 +0800</pubDate><description><![CDATA[在装完Linux系统之后自己去修改Swap分区的大小(两种方法)


	在安装完Linux系统后，swap分区太小怎么办，怎么可以扩大Swap分区呢？有两个办法，一个是从新建立swap分区，一个是增加swap分区。下...]]></description><category></category></item><item><title><![CDATA[linux下获取占用CPU和内存资源最多的10个进程]]></title><link>https://blog.youkuaiyun.com/citan5439/article/details/100247533</link><guid>https://blog.youkuaiyun.com/citan5439/article/details/100247533</guid><author>citan5439</author><pubDate>Thu, 12 Feb 2015 11:22:22 +0800</pubDate><description><![CDATA[linux下获取占用CPU资源最多的10个进程，可以使用如下命令组合：


	


	ps aux|head -1;ps aux|grep -v PID|sort -rn -k +3|head


	...]]></description><category></category></item><item><title><![CDATA[Oracle 11gR2 使用 RMAN duplicate from active database 复制数据库]]></title><link>https://blog.youkuaiyun.com/citan5439/article/details/100247528</link><guid>https://blog.youkuaiyun.com/citan5439/article/details/100247528</guid><author>citan5439</author><pubDate>Wed, 24 Dec 2014 17:06:56 +0800</pubDate><description><![CDATA[在Oracle 10g下，我们可以使用RMAN duplicate命令创建一个具有不同DBID的复制库。到了Oracle 11gR2，RMAN的duplicate有2种方法实现：


	1....]]></description><category></category></item><item><title><![CDATA[通过 rman duplicate 配置Oracle 11g Active Dataguard]]></title><link>https://blog.youkuaiyun.com/citan5439/article/details/100247530</link><guid>https://blog.youkuaiyun.com/citan5439/article/details/100247530</guid><author>citan5439</author><pubDate>Wed, 24 Dec 2014 17:04:41 +0800</pubDate><description><![CDATA[本文介绍了11g active dataguard的详细配置步骤和数据保护模式的修改！


	一：环境介绍
主库
IP地址:192.168.1.61/24
操作系统版本：rhel5.4 64bit
数据库版本...]]></description><category></category></item><item><title><![CDATA[Oracle SQL优化之sql tuning advisor(STA)]]></title><link>https://blog.youkuaiyun.com/citan5439/article/details/100247524</link><guid>https://blog.youkuaiyun.com/citan5439/article/details/100247524</guid><author>citan5439</author><pubDate>Wed, 22 Oct 2014 15:24:36 +0800</pubDate><description><![CDATA[Oracle SQL优化之sql tuning advisor(STA)



	SQL优化器SQL Tuning Advisor （STA)，是oracle的sql优化补助工具。


	其实优化sql主要...]]></description><category></category></item><item><title><![CDATA[Linux静态IP设置(ipconfig命令)]]></title><link>https://blog.youkuaiyun.com/citan5439/article/details/100247527</link><guid>https://blog.youkuaiyun.com/citan5439/article/details/100247527</guid><author>citan5439</author><pubDate>Sun, 28 Sep 2014 15:26:33 +0800</pubDate><description><![CDATA[Linux静态IP设置


	IP配置:
/etc/sysconfig/network-scripts/ifcfg-eth0
DEVICE=eth0
BOOTPROTO=static
HWADDR=00:26...]]></description><category></category></item><item><title><![CDATA[linux平台11gR2 grid安装到执行root.sh时报错]]></title><link>https://blog.youkuaiyun.com/citan5439/article/details/100247526</link><guid>https://blog.youkuaiyun.com/citan5439/article/details/100247526</guid><author>citan5439</author><pubDate>Tue, 23 Sep 2014 14:46:02 +0800</pubDate><description><![CDATA[vi /etc/selinux/config
SELINUX=disabled
重新执行root.sh

[root@oracledb oracle]# /oradata/app/11.2.0/grid/root.sh...]]></description><category></category></item><item><title><![CDATA[/etc/fstab改错后的处理]]></title><link>https://blog.youkuaiyun.com/citan5439/article/details/100247525</link><guid>https://blog.youkuaiyun.com/citan5439/article/details/100247525</guid><author>citan5439</author><pubDate>Tue, 23 Sep 2014 11:06:53 +0800</pubDate><description><![CDATA[今天不小心把/etc/fstab改错了， 系统重启後显示
Checking filesystems
。。。。。。。。。。。。。。。


***An error occured during the file syste...]]></description><category></category></item><item><title><![CDATA[Redhat Linux 硬盘挂载方法]]></title><link>https://blog.youkuaiyun.com/citan5439/article/details/100247523</link><guid>https://blog.youkuaiyun.com/citan5439/article/details/100247523</guid><author>citan5439</author><pubDate>Mon, 22 Sep 2014 15:59:57 +0800</pubDate><description><![CDATA[硬盘挂载操作工作步骤：
1、先查看目前机器上有几块硬盘，查看命令有两种：
命令1：# fdisk –l
命令2：# dmesg | grep sd
其中：fdisk命令说明如下：
fdisk命令用途：观察硬盘的实体使用...]]></description><category></category></item><item><title><![CDATA[Linux下批量Kill多个进程的方法]]></title><link>https://blog.youkuaiyun.com/citan5439/article/details/100247522</link><guid>https://blog.youkuaiyun.com/citan5439/article/details/100247522</guid><author>citan5439</author><pubDate>Fri, 19 Sep 2014 17:16:12 +0800</pubDate><description><![CDATA[ps -ef|grep LOCAL=NO|grep -v grep|cut -c 9-15|xargs kill -9 

　　管道符“|”用来隔开两个命令，管道符左边命令的输出会作为管道符右边命令的输入。下面说说用管道符联...]]></description><category></category></item><item><title><![CDATA[oracle impdp network_link参数使用介绍]]></title><link>https://blog.youkuaiyun.com/citan5439/article/details/100247520</link><guid>https://blog.youkuaiyun.com/citan5439/article/details/100247520</guid><author>citan5439</author><pubDate>Fri, 19 Sep 2014 10:33:58 +0800</pubDate><description><![CDATA[一、环境说明 
源数据库： 
IP地址：192.168.137.100 
sid：catalog 
用户名：rman 
密码：rman 
目标数据库： 
IP地址：192.168.137.101 
sid：orc...]]></description><category></category></item><item><title><![CDATA[Oracle 后台进程 说明]]></title><link>https://blog.youkuaiyun.com/citan5439/article/details/100247518</link><guid>https://blog.youkuaiyun.com/citan5439/article/details/100247518</guid><author>citan5439</author><pubDate>Tue, 16 Sep 2014 14:52:21 +0800</pubDate><description><![CDATA[后台进程


	为了实现为多用户提供服务且保证系统性能，在一个多进程Oracle系统（multiprocess Oracle system）中，存在多个被称为后台进程（background process）的O...]]></description><category></category></item><item><title><![CDATA[Oracle Purge和drop的区别]]></title><link>https://blog.youkuaiyun.com/citan5439/article/details/100247517</link><guid>https://blog.youkuaiyun.com/citan5439/article/details/100247517</guid><author>citan5439</author><pubDate>Sun, 31 Aug 2014 14:50:45 +0800</pubDate><description><![CDATA[最近发现oracle中出现了这些奇怪的表名，上网查找后发现是oracle10g的回收站功能，并没有彻底的删除表，而是把表放入回收站，最后就出现了这样一堆奇怪的表名......

 清除的方法如下：
 p...]]></description><category></category></item><item><title><![CDATA[Oracle 使用 ass.awk 工具查看 system state dump 说明]]></title><link>https://blog.youkuaiyun.com/citan5439/article/details/100247514</link><guid>https://blog.youkuaiyun.com/citan5439/article/details/100247514</guid><author>citan5439</author><pubDate>Fri, 15 Aug 2014 11:46:42 +0800</pubDate><description><![CDATA[如果Oracle数据库hang住了，对Oracle做system dump，或做 hang analyze，是研究和解决问题的有效办法。如果能够连接数据库，并能够进行操作，那么用oradebug是简单快捷的办法。

...]]></description><category></category></item></channel></rss>