oracle

关于Partial write for all MySQL and Oracle

September 2, 2014 Internals, MYSQL, oracle No comments

很久之前看过这个帖子,当时没有细究,这几天看了下mysql相关的internal 突然想起这个问题,跟三四个朋友讨论了下 想把这个问题展开讲一讲。

源帖子内容见:https://community.oracle.com/thread/1087650?start=0&tstart=0

这个[……]

Read more

小型机迁移x86平台之老生常谈

July 17, 2014 migration, oracle, system, unix No comments

You can view this presentation click here: x86_architect
注意使用chrome打开文件 不然可能乱码[……]

Read more

[SHOUG] 1号店Exadata应用

April 3, 2014 Architect, Exadata, hardware, oracle No comments

Download PDF: [SHOUG.LOUISLIU]Exadata在电商的实践[……]

Read more

Oracle DGHA architecture

November 1, 2013 advanced tech, Architect, network, oracle, replication No comments


Download this PDF
[……]

Read more

[转] Autotrace with bind variables

September 27, 2013 Internals, oracle No comments

JL刚刚写的一篇autotrace与bind variables 的行为:Autotrace trick
之前我们也发现过这个问题具体SR在这里:something seems confused [……]

Read more

CTAS导致严重BUG一则

September 25, 2013 Internals, oracle No comments

某国内巨头的一起CASE,在系统繁忙情况下大量的CTAS 导致数据字典表的不一致,由原来10.0.2.4版本升级到10.0.2.5之后问题依旧。
具体表现为:
1. 尝试drop这些不一致的tablespace

15:00:18 SQL> @dropts_2012.0319.150[......]

Read more

Think of bind value

September 17, 2013 Internals, oracle No comments

[……]

Read more

一次诡异的缓慢”死亡” CASE

September 13, 2013 Internals, oracle No comments

今天下午遇到的一个诡异CASE,现象为系统诡异的死亡,目前判定为sqluldr2工具导致 (同事使用sqluldr2 用具 执行了sqluldr2_linux64_10204.bin -help 命令)
抛出的错误如下 (/var/log/message)

Sep 11 09:00:54[......]

Read more

DGHA,Dataguard自动切换方案

August 15, 2013 Architect, oracle, replication, software No comments

发布对autoswitch over dg脚本DGHA测试,此脚本针对oracle dataguard设计使用共享存储存放redo以及controlfile从而达到了切换数据0丢失。
同时切换以后,original primary database可以无缝加入整个dg集群,从而形成了datagua[……]

Read more

关于12c Pluggable database注册listener问题

August 9, 2013 12c, network, oracle No comments

演示一下12c中关于pdb的listener register,unregister问题

[oracle@db-42 ~]$ lsnrctl status listener1

LSNRCTL for Linux: Version 12.1.0.1.0 - Production on[......]

Read more