Performance comparison Raw device VS Ext2 VS Ext3 VS OCFS

Performance comparison Raw device VS Ext2 VS Ext3 VS OCFS

 

TPS Graph、 Input 、Output 、CPU usage

Oracle数据库升级路线图

Oracle Upgrade roadmap Oracle数据库升级路线图总览

Moving from much older releases of Oracle Database, it suggested that an upgrade to 9iR2 is done first.

Upgrade to Oracle Database 10g Release 2For all release upgrades, export/import will work as well.Direct upgrades to 11.1 are supported from 9.20.4 or higher, 10.1.0.x, 10.2.0.x.

图解Oracle RAC全局缓存等待事件Global Cache Wait Events

图解Oracle RAC全局缓存等待事件Global Cache Wait Events

 

如何给Exadata数据库一体机打补丁patching图解

从图中可以看到使用ILOM为Infiniband 打补丁,而OS和固件使用oracle定制的minimal pack install.sh

 

Oracle Goldengate Director软件截面图

Oracle Goldengate Director软件截面图

 

没有Metalink账号的同学可以观赏下,My Oracle Support的主界面

没有Metalink账号的同学可以观赏下,My Oracle Support Main Dashboard的主界面

 

图解Oracle Checkpoint Queue

图解Oracle Checkpoint Queue

 

Checkpoint queues contain the dirty buffers that are ordered by the low RBA. There is one file queue per data file containing: Dirty buffers belonging to that file Delayed logged buffers Linking buffer to checkpoint queue: Whenever the low RBA is set for a buffer, the buffer is added to tail of the CKPTQ and appropriate FQ. Removal of buffer from checkpoint queue: The low RBA is cleared when the buffer is added to write batch. When the buffer is written to disk, it is unlinked from the FQ and CKPTQ. Write of hot buffers from CKPTQ is deferred.

图解Oracle 11g physical standby Rolling Upgrade物理备库滚动升级特性

图解Oracle 11g physical standby Rolling Upgrade物理备库滚动升级特性 11g Rolling Database Upgrades Using Transient Logical Flow:

 

MySQL Enterprise Monitor架构图

MySQL Enterprise Monitor架构图 Enterprise Monitor Architecture

 

图解揭秘Oracle Buffer Header数据结构

X$BH V$BH? Oracle里 的Buffer Header到底是这样的数据结构, 保存了哪些buffer属性?

图解揭秘Oracle Buffer Header数据结构, Buffer header记录了lru chain 、 Hash bkt、User List、 Waiter List、flags、TSN、afn、dba、buffer address、CR env、lock element等信息:

 

 

buffer_header

沪ICP备14014813号

沪公网安备 31010802001379号