Friend Life for Oracle http://space.itpub.net/?uid-12361284 过着简单,真实的生活，喜欢收藏变形金刚(TFE,G1,SL系列)，研究金融股市，KOF98，篮球，学习研究Oracle技术,我并不是一个全职的Oracle DBA，但是对于Oracle技术的热爱和研究，是一个不争的事实，愿意结交广大Oracle技术爱好者！MSN:oracle_kof_tf@hotmail.com Copyright(C) Friend Life for Oracle SupeSite/X-Space Sat, 17 May 2008 02:54:05 GMT 2008 5 16: Do I need to buy the ticket in advance? http://space.itpub.net/?uid-12361284-action-viewspace-itemid-269287 blog oracle_ace Fri, 16 May 2008 14:22:40 GMT How to redirect the TAF Service to preferred node? http://space.itpub.net/?uid-12361284-action-viewspace-itemid-269237 As we know If a node in the RAC environment is crashed or shutdown abnormally.We can adopt to use the DBCA to generate a TAF service to achieve the failover between two or more nodes in the Real application cluster environment. For example i have tw...]]> blog oracle_ace Thu, 15 May 2008 21:18:03 GMT How to re-create the ASM http://space.itpub.net/?uid-12361284-action-viewspace-itemid-269233 These days i was attempting to install the RAC with openfiler(ISCSI), it is approached to finished.
The lastest step is to create database with DBCA and its datafiles was based on ASM.
i misconfigured the ASM diskgroups during the database cre...]]> blog oracle_ace Thu, 15 May 2008 20:50:23 GMT RAC中的虚拟IP http://space.itpub.net/?uid-12361284-action-viewspace-itemid-265165 10g 中为什么使用虚拟 IP (VIP)？为什么当它的主节点发生故障时不只是返回一个无效的连接呢？

这全是出于对应用程序可用性的考虑。当一个节点发生故障时，与其关联的 VIP 将被自动故障切换到另外某个节点上。当出现这种情况时，会发生...]]> blog oracle_ace Mon, 12 May 2008 16:22:17 GMT iSCSI技术 http://space.itpub.net/?uid-12361284-action-viewspace-itemid-265157     这两天在研究如何用openfiler来搭建一套廉价的Oracle RAC环境，下面引用的文本是对iSCSI技术的一个简短的介绍： 

　多年以来，一直用于构建基于网络的存储解决方案的唯一技术就是光纤通道存储区域网 (FC S...]]> blog oracle_ace Mon, 12 May 2008 15:39:09 GMT 2008 5 12:I were you,I couldn't take this much longer http://space.itpub.net/?uid-12361284-action-viewspace-itemid-265152 blog oracle_ace Mon, 12 May 2008 15:05:41 GMT 2008 5.9:I think i'm coming down with a cold http://space.itpub.net/?uid-12361284-action-viewspace-itemid-263416 http://blog.itpub.net/post/330/2230
今天早上一来，数据库load就比往常高了许多。想想数据库唯一的...]]> blog oracle_ace Mon, 21 Apr 2008 18:21:46 GMT statspack的若干使用技巧(转) http://space.itpub.net/?uid-12361284-action-viewspace-itemid-246232 使用statspack有相当长的时间啦,从最初的推崇,到后来的否定,
再到现在的肯定,发现它已经是我工作中不可缺少的一部分,
每晚上读当天产生的statspack报表就成了一种习惯,
越是读得认真,越是觉得statspack妙用无穷,
现在本人就将一些心得告诉大家,希望对你有所...]]> blog oracle_ace Mon, 21 Apr 2008 17:40:59 GMT 2008 4 16: The train was five minutes behind schedule http://space.itpub.net/?uid-12361284-action-viewspace-itemid-238012 blog oracle_ace Wed, 16 Apr 2008 17:19:13 GMT 为什么要Supplemental Log(追加日志) http://space.itpub.net/?uid-12361284-action-viewspace-itemid-237928
alter database add supplemental log data (primary key, unique index) columns;

在配置stream replication时,也要求参与复制的表传输附加日志:
alter tabl...]]> blog oracle_ace Tue, 15 Apr 2008 19:44:04 GMT ORA-00600: internal error code, arguments: [krvxbpns01], [], [], [], [], [], http://space.itpub.net/?uid-12361284-action-viewspace-itemid-235731 SQL> select count(*) from GV$LOGMNR_CONTENTS;
select count(*) from GV$LOGMNR_CONTENTS
    &nb...]]> blog oracle_ace Mon, 14 Apr 2008 17:04:28 GMT 2008 4 14: Good Coffee,really hits the spot http://space.itpub.net/?uid-12361284-action-viewspace-itemid-235722 blog oracle_ace Mon, 07 Apr 2008 15:51:42 GMT Oracle 堆组织表(HOT) http://space.itpub.net/?uid-12361284-action-viewspace-itemid-230932 Oracle实际应用中,经常会用到table,对于table的研究自己之前并没有过多的参与, 最近读了一下tom的书后,对table又有了一点新的认识.
table在Oracle中被分为很多的类种,我们平时在create table时,最常用到的类型就是堆组织表了(HOT),那么heap我们都知道是一种经典的数...]]> blog oracle_ace Sun, 06 Apr 2008 15:01:09 GMT 关于global_stats http://space.itpub.net/?uid-12361284-action-viewspace-itemid-227922
GLOBAL_STATS VARCHAR2(3)
-------------------------
For partitioned tables, indicates whether statistics were
collected by analyzing the table as a whole (YES) or
were estimated fr...]]> blog oracle_ace Thu, 03 Apr 2008 19:05:46 GMT 2008 4 3:She can come at the drop of a hat http://space.itpub.net/?uid-12361284-action-viewspace-itemid-227879 blog oracle_ace Thu, 03 Apr 2008 14:20:03 GMT