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[……]
由于此前的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[……]
总结了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[……]
在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)[……]
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[……]
记录一次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[……]
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[……]
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[……]
系统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/oracle/diag/rdbms/yhdstd/yhddb1/trace/yhddb1_ora_11327.trc
Corrupt block relative dba: 0x02489110 (file 9, block 561424)
Fractured block found durin[……]
从10.2.0.5的库导入一张表的增量数据到11.2.0.3 impdp报出如下错误,对比两边表结构一致，tablespace有剩余空间 报错如下：
[oracle@localhost ~]$ impdp \’\/ as sysdba \’ directory=pump dumpfile=so.dmp TABLE_EXISTS_ACTION=append
Import: Release 11.2.0.3.0 – Production on Thu Feb 23 09:44:49 2012
Copyright (c) 1982, 2011, Oracle and[……]
