> 文章列表 / Page 307

一位客户的Oracle告警日志中出现了ORA-600 [kddummy_blkchk] [18038]故障，alert中的具体信息： Errors in file /u01/app/oracle/admin/prdw014a/udump/prdw014a_ora_4377.trc: ORA-00600: internal error code, arguments: [kddummy_blkchk...

介绍完了EnterpriseDB复制软件基本原理和注意事项，我们接下来进行Oracle数据复制到EntepriseDB advanced Server的实际演练。 先在Oracle实例中创建复制测试所用到的数据： SQL> drop user source cascade; User dropped. SQL> create user source identified by sour...

EntepriseDB 复制软件目前支持多种数据库到postgre的复制，其基本结构由发布者(Publication)与订阅者(Subscriptions)组成,Replication软件可针对来自不同类型数据库的多个发布者，将其数据复制到多个订阅者(Subscriptions)数据库中。 其可能的几种拓扑结构，如以下图： 同Oracle中普通的物化视图一样，不支持对订阅者(Subscriptio...

下面我们来测试EnterpriseDB Migration 工具对于Oracle 大对象(LOB)的迁移情况； 首先在在Oracle实例Scott模式下创建具有LOB对象的表,如： SQL> create table tlob (t1 int primary key,t2 clob,t3 blob); Table created. -- 并填充数据 SQL> begin 2 for i...

EntperpriseDB 目前作为Postgre开源数据库的企业发行版，在原开源社区的基础上对postgre进行了扩展(contribute),值得关注的技术有infiniteCache,以及其强大的迁移工具Migration tools;下面我们来简单测试该迁移工具. 通过安装postgreplus-advanced-server软件包，其中将默认包括DBA management Server...

以下罗列一些Oracle中的Top-N与分页匹配查询优化写法： CREATE INDEX i_pop ON cities(population); TOP-N SELECT * FROM ( SELECT name, population FROM cities ORDER BY population DESC ) WHERE rownum 10; Top-N with joins SELECT ...

oracle 11g r2 on windows platform released today , we can test it now.

升级到FF3.6的朋友肯定发现了现在使用火狐浏览器访问my oracle support 时许多页面打开为空白页，譬如这篇介绍FF3.6与目前oracle support site兼容性的文章： Firefox 3.6 Not Officially Supported by My Oracle Support Although much of the functionality of My Ora...

The status of buffer locks can be checked through the table X$KJBL; it is not necessary to dump the locks with the ORADEBUG command, in order to get to this information. The table contains the client ...

X$KJMSDP The table X$KJMSDP has entries for each LMS process that is configured for the instance. The default number of LMS processes is the number of CPU’s divided by 4, but 2 as a minimum. The LMS p...