看到刘兄的一篇文章转载下
April 16, 2012 11g, oracle No comments
看到刘兄的一篇文章转载下
March 8, 2012 11g, maintain, oracle 1 comment 11g new feature
Create a database link with the new host:port/service syntax
Submitted by tanelpoder on Mon, 2012-03-05 15:57
Share
I just noticed that (finall[……]
February 15, 2012 11g, oracle No comments 11g new feature
11g为我们提供了Index Invisible特性，使用这个特性可以轻松的将index置为不可用状态，对比之前的将索引置为unusable
最大的改进是，当index设置为unusable时，索引将不再随着表数据的更新而更新，导致如果重新使用index 需要rebuild等操作
这对大型的OL[……]
February 3, 2012 11g, oracle No comments 11g new feature
在pythian看到了一个测试，是否证明了oracle 11g is x% faster than 10g?(oracle官方的说法）
First, you have to create and fill a table to run your query :
create table[……]
February 3, 2012 11g, oracle No comments 11g new feature
总结了11g partition new feature
11G Introduced partition extensions:
-Interval partitioning
-REF partitioning
-More Composite Partitioning
-Virtual[……]
January 2, 2012 11g, Internals, oracle No comments oradebug
11g Oracle 加强了oradebug 可以使用oradebug doc命令查看internal trace command,下面简述各种命令的输出，由于是undocumented,所以很多东西有待研究
Contents
ORADEBUG DOC
ORADEBUG DOC E[……]
December 29, 2011 11g, maintain, oracle No comments structure
how to create very big index
我们总会碰到各种case 需要建立索引 有些索引大至1T,这些索引的创建是个非常棘手的问题,oracle 11g 在建立partition index时,给出了不错的解决方案
Let’s now re-create th[……]
December 18, 2011 11g, oracle, RAC No comments upgrade
基于windows 2008平台升级rac 11.2.0.2.0->11.2.0.3.0
OS环境windows 2008 x64 数据库环境oracle 11g rac ,version 11.2.0.2.0 64bit
SQL> conn / as sysdba
已连接。
S[……]
December 16, 2011 11g, backup, oracle No comments 11g
11g Release 2 RMAN Backup Compression
Oracle 11g Release 2 introduced compression algorithm levels which can be used for compressing table data, Data[……]
December 13, 2011 11g, hardware, oracle No comments 11g
11G新特性 IO Calibration可以帮我们估算出存储的读写性能，在使用这个特性之前 我们需要满足一些条件：
.在linux系统中默认是不开启异步IO的
SQL> show parameter filesystemio_options
NAME TYPE V[……]