<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[suner86的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/suner86</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; suner86]]></copyright><item><title><![CDATA[监测Oracle RAC Interconnect Traffic的几种方法]]></title><link>https://blog.youkuaiyun.com/suner86/article/details/15964715</link><guid>https://blog.youkuaiyun.com/suner86/article/details/15964715</guid><author>suner86</author><pubDate>Wed, 13 Nov 2013 20:08:35 +0800</pubDate><description><![CDATA[在此分享一个实时监测网卡网络流量的脚本，可以方便的查看RAC每秒的interconnect traffic：
vi network_traffic.sh
#!/bin/bash
while [ "1" ]
do
eth=$1
RXpre=$(cat /proc/net/dev | grep $eth | tr : " " | awk '{print $2}')
TXpre=$(cat /pro]]></description><category></category></item><item><title><![CDATA[RMAN duplicate创建Dataguard standby数据库并使用QMonitor监控standby delay]]></title><link>https://blog.youkuaiyun.com/suner86/article/details/12872435</link><guid>https://blog.youkuaiyun.com/suner86/article/details/12872435</guid><author>suner86</author><pubDate>Sat, 19 Oct 2013 17:30:14 +0800</pubDate><description><![CDATA[在Oracle 10g中，我们可以通过基于备份的rman DUPLICATE比较方便地实现Dataguard物理standby的搭建，首先对数据库进行备份并传送到standby所在主机，继而通过进行数据库的恢复来实现standby的搭建。
    而在Oracle 11g中，一个新特性令我们欣喜不已。Active database duplication 通过网络，直接copy target 库]]></description><category></category></item><item><title><![CDATA[Oracle Database 12c创建Pluggable Database的两种方式及拔出、插入、删除Pluggable Database]]></title><link>https://blog.youkuaiyun.com/suner86/article/details/9499699</link><guid>https://blog.youkuaiyun.com/suner86/article/details/9499699</guid><author>suner86</author><pubDate>Fri, 26 Jul 2013 19:25:41 +0800</pubDate><description><![CDATA[dbca建库后的目录结构（包括一个CDB,10个PDB）:
[root@db-12c tree-1.6.0]#
 tree /opt/oracle/oradata
/opt/oracle/oradata
`-- cdb
    |-- control01.ctl
    |-- pdb1
    |   
|-- pdb1_users01.dbf
    |   
|-- sy]]></description><category></category></item><item><title><![CDATA[归档与非归档模式下更改数据文件位置]]></title><link>https://blog.youkuaiyun.com/suner86/article/details/9472983</link><guid>https://blog.youkuaiyun.com/suner86/article/details/9472983</guid><author>suner86</author><pubDate>Thu, 25 Jul 2013 20:14:16 +0800</pubDate><description><![CDATA[一、归档模式

方法一：
SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 9 11:17:54 2013
 
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
 
Connected to:
Oracle Database 11g Enterprise Edition Rele]]></description><category></category></item><item><title><![CDATA[反向键索引研究]]></title><link>https://blog.youkuaiyun.com/suner86/article/details/9472801</link><guid>https://blog.youkuaiyun.com/suner86/article/details/9472801</guid><author>suner86</author><pubDate>Thu, 25 Jul 2013 20:00:59 +0800</pubDate><description><![CDATA[反向键索引（Reverse Key Index）也是一种B树索引，但是它与一般的B树索引相比又有一个很奇特的地方。反向键索引将索引键值的每一个字节做一个翻转变换，举一个例子：数字123456在反向键索引中的存储形式便是654321。读到这里很多读者就会觉得匪夷所思，因为这会使得本来邻近的整数在索引中变得分散，比如123456、123457被翻转后分别是654321、754321，那么转换后的数字就]]></description><category></category></item></channel></rss>