Louis workspace

新的一年到了,DBA TEAM准备扩充一下,主要环境是ORACLE(RAC+单实例+DG)+ MYSQL 后面还要涉及到MYSQL的高可用架构实施,ORACLE方面今年也会有一些架构变更,总体而言今年是很有挑战的一年,希望挑战与激情的同学可以来试一试,同时也欢迎大牛的加入

Location:Shanghai

简历发送到ylouis83@gmail.com

louisliu
2012-02-17[……]

Read more

11g为我们提供了Index Invisible特性，使用这个特性可以轻松的将index置为不可用状态，对比之前的将索引置为unusable
最大的改进是，当index设置为unusable时，索引将不再随着表数据的更新而更新，导致如果重新使用index 需要rebuild等操作
这对大型的OLTP系统是极大的挑战，而invisible则不然

下面做个测试：

SQL> create table t_test1 as select * from all_objects;

Table created.

SQL> create index t_te[……]

Read more

set echo off

————————————————–
— @name: lock_internal
— @author: dion cho
— @description: my own version of dba_lock_internal
—————————————————

define __SID = “&1”
define __NAME = “&2”

col handle format a10
col type[……]

Read more

记录一次database upgrade 导致physical standby故障

upgrade from 10.2.0.5->11.2.0.3

单节点的database升级很容易，严格按照手册，修改compatible=10.2.0

参考文档 Complete Checklist for Manual Upgrades to 11gR2 [ID 837570.1]

如果带有standby的系统升级要注意以下几点：

1.首先stop 10g listener,使用 11g listener

2.使用11g software打开standby databa[……]

Read more

Recommendation for the Real Application Cluster Interconnect and Jumbo Frames

Applies to:

Oracle Server – Enterprise Edition – Version: 9.2.0.1 to 11.2.0.0 – Release: 9.2 to 11.2
Information in this document applies to any platform.
Oracle Server Enterprise Edition – Version: 9.2.0.1 to[……]

Read more

在pythian看到了一个测试，是否证明了oracle 11g is x% faster than 10g?(oracle官方的说法）

First, you have to create and fill a table to run your query :

create table gark
(id1 number not null,
id2 number not null,
id3 number not null);

begin
for i in 1..100000 loop
insert into gark(id1, id2, id3)[……]

Read more

总结了11g partition new feature
11G Introduced partition extensions:
-Interval partitioning
-REF partitioning
-More Composite Partitioning
-Virtual Column-based partitioning
-System Partitioning
-Introduced Partition Advisor.

Partition Types
Let us discuss each of the above features briefl[……]

Read more

由于此前的mysql salve服务器没有进行规划,一些参数都是使用的默认参数,导致innodb datafile 无限制增长,所以需要重新规划一下datafile空间的分配,以及其他参数的优化

version:

mysql>
mysql>
mysql> select version()
-> ;
+————+
| version() |
+————+
| 5.5.14-log |
+————+
1 row in set (0.02 sec)

mysql>

配置sysctl limit
[roo[……]

Read more

Regular Pages and HugePages

This section aims to give a general picture about memory access in virtual memory systems and how pages are referenced.
When a single process works with a piece of memory, the pages that the process uses are reference in a local page table for the specific process. T[……]

Read more

修改过的show_space 支持ASSM

create or replace
procedure show_space
( p_segname_1 in varchar2,
p_space in varchar2 default ‘MANUAL’,
p_type_1 in varchar2 default ‘TABLE’ ,
p_freespace in varchar2 default ‘N’,
p_owner_1 in varchar2 default user)
as
p_segname varc[……]

Read more