1. create Pluggable database from NON_CDB database.
[oracle@db-42 ~]$ ora si SQL*Plus: Release 12.1.0.1.0 Production on Fri Jul 5 13:07:08 20[......]
July 5, 2013 12c, oracle No comments 12c new feature
1. create Pluggable database from NON_CDB database.
[oracle@db-42 ~]$ ora si SQL*Plus: Release 12.1.0.1.0 Production on Fri Jul 5 13:07:08 20[......]
July 4, 2013 advanced tech, oracle No comments training
最近做的一次内部交流文档[……]
July 3, 2013 12c, oracle No comments 12c new feature
根据JL,Glen Fawcett 的文章 oracle 从12c开始提供了3个视图来探测慢速的IO
SQL> desc V$LGWRIO_OUTLIER; Name Null? Type -----------------------------------[......]
June 27, 2013 12c, oracle 1 comment 12c new feature
首先我们看一组测试 数据库版本oracle 12c beta1
SQL> select count(*) from test; COUNT(*) ---------- 725888 SQL> set timing on; SQL> alter[......]
June 14, 2013 MYSQL, performance 2 comments mysql
最近team基于mysql的性能基准测试,包含多种场景[……]
June 7, 2013 oracle, RAC No comments RAC
前天处理了一启RAC ASM 内存泄露问题,系统为公司最后一套RAC one node 版本为11.2.0.3
这套核心RAC one node系统出现大量 log file switch buffer busy waits等待,并伴随大量cursor: pin S wait on X re[……]
May 22, 2013 Architecture, MYSQL, performance No comments mysqlawr
MyAWR 开源了,第一版的reference 已经放出, tx to noodba
MyAWR_Reference_Guid
slideshare地址:MyAWR (awr of MySQL)
MyAWR template:MySQL WorkLoad Report[……]
May 14, 2013 Internals, oracle No comments internal
May 6, 2013 Architecture, MYSQL, performance No comments mysqlawr
April 11, 2013 11g, advanced tech, oracle No comments 11g new feature
By wwf from ebay COC about Optimizer in Oracle 11g.
[……]