图解Undo原理

图解Undo原理：包括事务表Transaction Table、Undo Chains、和事务槽Interested Transaction List(ITLS)。

 

Transaction Table, Undo Chains and Interested Transaction Lists (ITLs) Mechanism by which Oracle maintains row level locking, Consistent Reads & block cleanouts.

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 Monitor架构图

Oracle GoldenGate Monitor架构图

Oracle Goldengate Director软件截面图

Oracle Goldengate Director软件截面图

 

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

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

 

MySQL Query Analyzer查询分析器

MySQL Query Analyzer查询分析器

 

Query Analyzer Use Cases Developers and QA Profile and tune SQL code while in development Enabled at all times during QA DBAs/Sys Admins Enabled at all times in production (may be limited) Sampling of production query stream during non-peak hours via application port swapping

 

 

 

 

图解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.

Blogroll

« Older posts