<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[crs00001的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/crs00001</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; crs00001]]></copyright><item><title><![CDATA[Oracle系统统计信息]]></title><link>https://blog.youkuaiyun.com/crs00001/article/details/100238662</link><guid>https://blog.youkuaiyun.com/crs00001/article/details/100238662</guid><author>crs00001</author><pubDate>Tue, 25 Jan 2011 17:47:08 +0800</pubDate><description><![CDATA[1.      什么是系统统计信息？ 我们知道在CBO环境中，Oracle依赖于对象的统计估算成本，以选择正确的SQL执行计划。从Oracle9i开始CBO计算成本(cost)的算法有了变化。Oracle9i以前更多考虑IO（多...]]></description><category></category></item><item><title><![CDATA[一个性能调优的案例]]></title><link>https://blog.youkuaiyun.com/crs00001/article/details/100238669</link><guid>https://blog.youkuaiyun.com/crs00001/article/details/100238669</guid><author>crs00001</author><pubDate>Mon, 02 Aug 2010 22:42:51 +0800</pubDate><description><![CDATA[一.为什么升级总是出问题？云南一市级人民医院是我们在云南目前最重要的客户之一，以前去过两次，留下的映象也比较好。此次HIS升级到10.26,云南公司的同事也做了不少的准备，可还是出问题了。问题流转到我这里之前，同事们已经处理了大...]]></description><category></category></item><item><title><![CDATA[在rhel下错误设置了lvm卷组集群属性的处理]]></title><link>https://blog.youkuaiyun.com/crs00001/article/details/100238670</link><guid>https://blog.youkuaiyun.com/crs00001/article/details/100238670</guid><author>crs00001</author><pubDate>Tue, 30 Mar 2010 10:04:02 +0800</pubDate><description><![CDATA[在rhel中使用vgchange命令,在非集群环境将vg设置集群属性后,对vg的所有操作都出现"Skipping clustered volume group data"的提示,使用vgremove删除都不可以,出现相同的...]]></description><category></category></item><item><title><![CDATA[DBA_HIGH_WATER_MARK_STATISTICS视图]]></title><link>https://blog.youkuaiyun.com/crs00001/article/details/100238667</link><guid>https://blog.youkuaiyun.com/crs00001/article/details/100238667</guid><author>crs00001</author><pubDate>Wed, 24 Feb 2010 11:57:27 +0800</pubDate><description><![CDATA[从Oracle10g开始，增加了DBA_HIGH_WATER_MARK_STATISTICS视图，用以记录段的HWM信息，Oracle文档对这个视力的描述如下：[@more@]DBA_HIGH_WATER_MARK_STATIS...]]></description><category></category></item><item><title><![CDATA[Oracle的并行操作[转]]]></title><link>https://blog.youkuaiyun.com/crs00001/article/details/100238666</link><guid>https://blog.youkuaiyun.com/crs00001/article/details/100238666</guid><author>crs00001</author><pubDate>Mon, 22 Feb 2010 17:16:02 +0800</pubDate><description><![CDATA[The full list of Oracle parallel execution features currently includes the following ·         Parallel Query ·   ...]]></description><category></category></item><item><title><![CDATA[11g中direct path read事件等待很高的一个案例]]></title><link>https://blog.youkuaiyun.com/crs00001/article/details/100238663</link><guid>https://blog.youkuaiyun.com/crs00001/article/details/100238663</guid><author>crs00001</author><pubDate>Thu, 04 Feb 2010 10:15:23 +0800</pubDate><description><![CDATA[　　在11g中，全表扫描可能使用direct path read方式，绕过buffer cache，这样的全表扫描就是物理读了．最近遇到了这样一个测试环境的案例，表现为direcy path read事件等特很高．[@more@...]]></description><category></category></item><item><title><![CDATA[用Table变量返回多行数据]]></title><link>https://blog.youkuaiyun.com/crs00001/article/details/100238659</link><guid>https://blog.youkuaiyun.com/crs00001/article/details/100238659</guid><author>crs00001</author><pubDate>Mon, 28 Dec 2009 11:33:58 +0800</pubDate><description><![CDATA[要让 PL/SQL 函数返回数据的多个行，必须通过返回一个 REF CURSOR 或一个数据集合来完成。REF CURSOR 的这种情况局限于可以从查询中选择的数据，而整个集合在可以返回前，必须进行具体化。Oracle ...]]></description><category></category></item><item><title><![CDATA[一次RAC节点宕机的解决过程]]></title><link>https://blog.youkuaiyun.com/crs00001/article/details/100238664</link><guid>https://blog.youkuaiyun.com/crs00001/article/details/100238664</guid><author>crs00001</author><pubDate>Tue, 08 Dec 2009 09:56:01 +0800</pubDate><description><![CDATA[1.       情况介绍海哥反馈大连某院的Oracle 10g RAC平均每个月都要宕机一次，一个节点自动重启，奇怪的是故障的时间没有规律，有时还发生在基本上没有业务的凌晨。医院目前使用的Windows 2003 Server...]]></description><category></category></item><item><title><![CDATA[查询gv$session引发大量的PX Deq Credit: send blkd事件]]></title><link>https://blog.youkuaiyun.com/crs00001/article/details/100238656</link><guid>https://blog.youkuaiyun.com/crs00001/article/details/100238656</guid><author>crs00001</author><pubDate>Fri, 23 Oct 2009 12:00:52 +0800</pubDate><description><![CDATA[一个用户提交了一个awr报告，发现有大量的PX Deq Credit: send blkd事件:Top 5 Timed Events EventWaitsTime(s)Avg Wait(ms)% Total Call Tim...]]></description><category></category></item><item><title><![CDATA[NFS保存rman备份时的mount选项]]></title><link>https://blog.youkuaiyun.com/crs00001/article/details/100238661</link><guid>https://blog.youkuaiyun.com/crs00001/article/details/100238661</guid><author>crs00001</author><pubDate>Mon, 21 Sep 2009 16:56:06 +0800</pubDate><description><![CDATA[今天在用使用nfs保存rman备份时，出现如下提示，意思是nfs的mount参数不对：RMAN&gt; backup datafile 1 format '/nfs/archive/%s_%U_%P.dbf';Starting ...]]></description><category></category></item><item><title><![CDATA[mysql的安装]]></title><link>https://blog.youkuaiyun.com/crs00001/article/details/100238660</link><guid>https://blog.youkuaiyun.com/crs00001/article/details/100238660</guid><author>crs00001</author><pubDate>Tue, 30 Jun 2009 21:31:29 +0800</pubDate><description><![CDATA[基本上按照这个链接的说明安装成功：http://tech.sina.com.cn/s/2008-05-05/07372174929.shtml过程只遇到了一个问题,在启动mysqld的时候，出错：[root@rhel local...]]></description><category></category></item><item><title><![CDATA[断电引起ora-01200的数据库恢复]]></title><link>https://blog.youkuaiyun.com/crs00001/article/details/100238654</link><guid>https://blog.youkuaiyun.com/crs00001/article/details/100238654</guid><author>crs00001</author><pubDate>Thu, 18 Jun 2009 16:20:12 +0800</pubDate><description><![CDATA[一个10g的库断电后,打开时出现ora-01200的错误:SQL&gt; connect / as sysdba;已连接到空闲例程。SQL&gt; startup;ORACLE 例程已经启动。Total System Globa...]]></description><category></category></item><item><title><![CDATA[linux下添加10g rac节点OUI-10009错误的解决办法]]></title><link>https://blog.youkuaiyun.com/crs00001/article/details/100238657</link><guid>https://blog.youkuaiyun.com/crs00001/article/details/100238657</guid><author>crs00001</author><pubDate>Wed, 17 Jun 2009 13:06:53 +0800</pubDate><description><![CDATA[一linux下的10g RAC环境，使用$ORACLE_HOME/oui/bin/addNode.sh在新节点上安装数据库软件时，出现OUI-10009错误：   OUI-10009 --&amp;gt There are...]]></description><category></category></item><item><title><![CDATA[linux下网卡bonding[转]]]></title><link>https://blog.youkuaiyun.com/crs00001/article/details/100238658</link><guid>https://blog.youkuaiyun.com/crs00001/article/details/100238658</guid><author>crs00001</author><pubDate>Tue, 02 Jun 2009 10:51:58 +0800</pubDate><description><![CDATA[所谓bonding，就是将多块网卡绑定同一IP地址对外提供服务，可以实现高可用或者负载均衡。当然，直接给两块网卡设置同一IP地址是不可能的。通过bonding，虚拟一块网卡对外提供连接，物理网卡的被修改为相同的MAC地址。Ker...]]></description><category></category></item><item><title><![CDATA[断电后回退段损坏引起的ora-00600错误修复一例]]></title><link>https://blog.youkuaiyun.com/crs00001/article/details/100238650</link><guid>https://blog.youkuaiyun.com/crs00001/article/details/100238650</guid><author>crs00001</author><pubDate>Tue, 24 Feb 2009 16:38:40 +0800</pubDate><description><![CDATA[一用户的817的库启动时出现如下错误：Recovery of Online Redo Log: Thread 1 Group 3 Seq 1608 Reading mem 0  Mem# 0 errs 0: D:ORACLEOR...]]></description><category></category></item><item><title><![CDATA[分区交换的速度为什么快？]]></title><link>https://blog.youkuaiyun.com/crs00001/article/details/100238655</link><guid>https://blog.youkuaiyun.com/crs00001/article/details/100238655</guid><author>crs00001</author><pubDate>Thu, 22 Jan 2009 17:52:48 +0800</pubDate><description><![CDATA[Oracle的分区交换功能，用来实现对数据“滑动窗口”操作，就是可以把数据从分区表中指定分区移出到一个表，或把一个表的数据移入到指定的分区中。[@more@]  分区交换的速度是非常快速的，只是数据字典的更新，在移动过程中，数据...]]></description><category></category></item><item><title><![CDATA[使用可传输表空间向rac环境迁移数据]]></title><link>https://blog.youkuaiyun.com/crs00001/article/details/100238649</link><guid>https://blog.youkuaiyun.com/crs00001/article/details/100238649</guid><author>crs00001</author><pubDate>Tue, 09 Sep 2008 16:48:34 +0800</pubDate><description><![CDATA[可传输表空间,是一种快速的转移数据的方式,基本过程如下:1、检查表空间的自包含性2、使用exp(expdp)导出表空间的元数据,这个过程很快3、将表空间置于read only模式，防止数据写入4、将包含元数据的dmp文件和表空间...]]></description><category></category></item><item><title><![CDATA[将表导入到其他用户的impdp命令]]></title><link>https://blog.youkuaiyun.com/crs00001/article/details/100238653</link><guid>https://blog.youkuaiyun.com/crs00001/article/details/100238653</guid><author>crs00001</author><pubDate>Thu, 07 Aug 2008 17:09:02 +0800</pubDate><description><![CDATA[今天需要另一个数据库的用户表导入到当前库中,但用户名不相同,以前exp/imp时,可以指定fromuser和touser来解决,在expdp中也提供了类似的解决方法[@more@]impdp system/zlsoft dump...]]></description><category></category></item><item><title><![CDATA[Oracle 10g rac升级(10.2.0.1 Rac到10.2.0.4)]]></title><link>https://blog.youkuaiyun.com/crs00001/article/details/100238651</link><guid>https://blog.youkuaiyun.com/crs00001/article/details/100238651</guid><author>crs00001</author><pubDate>Thu, 07 Aug 2008 11:27:54 +0800</pubDate><description><![CDATA[简要介绍了Linux下oracle10g rac环境的升级过程环境如下： OS: Linux AS 4 U4 32 bitDBMS: Oracle 10.2.0.1节点： IBM 3655, 主机名分别为rac01、rac02、...]]></description><category></category></item><item><title><![CDATA[将审计记录保存到xml文件]]></title><link>https://blog.youkuaiyun.com/crs00001/article/details/100238644</link><guid>https://blog.youkuaiyun.com/crs00001/article/details/100238644</guid><author>crs00001</author><pubDate>Wed, 06 Aug 2008 17:00:34 +0800</pubDate><description><![CDATA[在Oracle 10g中audit_trail增加了一个新选项:xml，与os选项不同的是，会将审计记录记录到操作系统的xml文件中。[@more@]   在Oracle 10g中audit_trail增加了一个新选项:xml，...]]></description><category></category></item></channel></rss>