Cloning an Oracle Home
Cloning an Oracle home involves creating a copy of the Oracle home and then configuring it for a new environment. If[……]
Author: Louis Liu
11.2.0.3 datapump got ORA-38500
从10.2.0.5的库导入一张表的增量数据到11.2.0.3 impdp报出如下错误,对比两边表结构一致，tablespace有剩余空间 报错如下：
[oracle@localhost ~]$ impdp \’\/ as sysdba \’ directory=pump dum[……]
Fractured blocks when Rman backup is running
系统alert在主库出现下面错误 OS为linux 5.5
Stopping background process CJQ0
Sat Feb 11 03:41:07 2012
Hex dump of (file 9, block 561424) in trace file /data/[……]
招聘：1号店招聘ORACLE DBA
新的一年到了,DBA TEAM准备扩充一下,主要环境是ORACLE(RAC+单实例+DG)+ MYSQL 后面还要涉及到MYSQL的高可用架构实施,ORACLE方面今年也会有一些架构变更,总体而言今年是很有挑战的一年,希望挑战与激情的同学可以来试一试,同时也欢迎大牛的加入
Location[……]
11g new feature Index Invisible
11g为我们提供了Index Invisible特性，使用这个特性可以轻松的将index置为不可用状态，对比之前的将索引置为unusable
最大的改进是，当index设置为unusable时，索引将不再随着表数据的更新而更新，导致如果重新使用index 需要rebuild等操作
这对大型的OL[……]
Scripts:lock_internal
set echo off
————————————————–
— @name: lock_internal
— @author: dion cho
— @description: my own version of[……]
记录一次database upgrade 导致physical standby故障
记录一次database upgrade 导致physical standby故障
upgrade from 10.2.0.5->11.2.0.3
单节点的database升级很容易，严格按照手册，修改compatible=10.2.0
Recommendation for the Real Application Cluster Interconnect and Jumbo Frames
Recommendation for the Real Application Cluster Interconnect and Jumbo Frames
Applies to:
Oracle Server – Enterprise Edition – Version: 9.2[……]
11g nested loop faster than 10g
在pythian看到了一个测试，是否证明了oracle 11g is x% faster than 10g?(oracle官方的说法）
First, you have to create and fill a table to run your query :
create table[……]
11g partition new features
总结了11g partition new feature
11G Introduced partition extensions:
-Interval partitioning
-REF partitioning
-More Composite Partitioning
-Virtual[……]