Oracle和MySQL - 博客园

How GoldenGate process consumes memory

摘要： Question:We are using Golden Gate to replicate the data from Oracle 9.2.0.8 on Solaris8 SPARC 64 bit (GoldenGate Version 10.4.0.31 Build 001) to Oracle RAC 11.2.0.1 on Solaris10 SPARC 64bit (GoldenGat... 阅读全文

posted @ 2010-12-26 09:03 Oracle和MySQL 阅读(382) 评论(0) 推荐(0)

Latches and Tuning:The Library Cache

摘要： 1. The shared pool is determined by the value of SHARED_POOL_SIZE as indicated in the init.ora file. The librarycache is part of the shared pool.a. Determine the size of the shared poool by executin... 阅读全文

posted @ 2010-12-26 06:54 Oracle和MySQL 阅读(241) 评论(0) 推荐(0)

Linode vps磁盘速度实测

摘要：事实证明Linode无愧于众多业界人士对其的推崇，今天实测了一下其磁盘速度真的不俗:[root@li229-25 ~]# hdparm -tT /dev/xvda/dev/xvda: Timing cached reads: 25536 MB in 1.99 seconds = 12843.60 MB/sec Timing buffered disk reads: 340 MB in 3... 阅读全文

posted @ 2010-12-24 22:10 Oracle和MySQL 阅读(371) 评论(0) 推荐(0)

Will Goldengate use Remote Procedure Call (RPC)?

摘要： Question:My Customer using Oracle GoldenGate to sync data from 11.2.0.1 RAC (on Solaris 10 SPRAc 64bit) to 9.2.0.8 standalone DB (On solaris Sparc 64bit). My customer recently doing an OS security sca... 阅读全文

posted @ 2010-12-24 06:52 Oracle和MySQL 阅读(223) 评论(0) 推荐(0)

ORA-01652 even though there is sufficient space in RECYCLE BIN

摘要： There is a bug 6977045 which may cause ORA-1652 raised even though there is sufficient space in RECYCLE BIN. Version under 11.2 believed to be affected[oracle@rh2 ~]$ oerr ora 165201652, 00000, "unab... 阅读全文

posted @ 2010-12-24 02:34 Oracle和MySQL 阅读(420) 评论(0) 推荐(0)

Google DataWiki如何区别于FluidDB

摘要：谷歌公司最近在其Google Lab上启动了数据维基(DataWiki)的项目。据谷歌官方称DataWiki将会是"一种数据结构化的维基"。根据其页面介绍，该项目理念来自于2010年海地地震期间发展起来的人物搜索(Person Finder)应用。谷歌开发者看到了创建结构化数据共享系统的急切需求。该项目乍听起来与FluidDB十分相似，FluidDB常被形容为”一种被托管的维基核心数据库"，Flu... 阅读全文

posted @ 2010-12-23 23:46 Oracle和MySQL 阅读(260) 评论(0) 推荐(0)

配置GoldenGate意外处理及记录Oracle错误信息(1)

摘要： GoldenGate自身不提供异常处理的程序。在默认情况下，若Replicat进程遭遇操作故障都会导致其异常终止(ABEND)，同时将会回滚事务到最近的检查点。在生产环境中这往往并不理想。当我们在做无缝的数据迁移时会用到HANDLECOLLISIONS和NOHANDLECOLLISIONS参数，这2个参数控制了Replicat是否会试图解决重复记录和缺失记录的错误，但这错误真的应该被忽略吗？这个问... 阅读全文

posted @ 2010-12-23 22:39 Oracle和MySQL 阅读(329) 评论(0) 推荐(0)

How to handle ddl in GoldenGate environment without ddl replication?

摘要： Question:gg only config to replicate dml, when source has some ddl changes, how to handle in source and target?Answer:GoldenGate capture the dml changes only by default,if you have made any changes in... 阅读全文

posted @ 2010-12-23 05:43 Oracle和MySQL 阅读(161) 评论(0) 推荐(0)

GoldenGate Build for Oracle 8i

摘要： BUILD REQUEST INSTALLATION MEDIA BUILD REQUEST ORACLE GOLDENGATE BUILD FOR 8I -32BIT ON WINDOWS (XP, 2003) 1040_WINNT.zip BUILD REQUEST SUN SOLARIS 5.8 SPARC (64-BIT) , ORACLE 8I GG VE... 阅读全文

posted @ 2010-12-22 19:12 Oracle和MySQL 阅读(222) 评论(0) 推荐(0)

GoldenGate实现Live Standby主备库切换(2)

摘要：在《GoldenGate实现Live Standby主备库切换(1)》中我们介绍了如何针对GoldenGate Live standby环境执行计划内的Switchover切换。除去计划内的主备切换，实际生产中更多的故障切换发生在主机故障或主库不可用的情况下,这种情况下一般我们已经无法在Primary上停止应用及extract了；当我们在这样的情况下failover到Standby上后如同在Dat... 阅读全文

posted @ 2010-12-21 22:06 Oracle和MySQL 阅读(288) 评论(0) 推荐(0)

ORACLE数据库服务热线：13764045638 诗檀软件