ACFS Architecture Pic

ACFS Architecture Pic

 

this is a build slide   first the current ASM paradigm.   Then we add a volume manager that allows us the mount ASM Cluster or single instance file systems,  take snapshots of those FS,  and even lets us mount Linux ext3 file systems on these volumes. In earlier releases of Oracle  Cluster Ready Service (CRS)  and Oracle Real Application Clusters  (RAC), you had to provision storage for Oracle Cluster Registry (OCR)  /Vote files, ASM Spfile outside ASM.  Prior to 10g  you also had to find either a cluster file system or raw devices for the database files.   Starting with Database 10g, database files could  be stored in ASM. Now, in 11gR2, OCR/Vote files as well ASM Spfile can be stored in ASM.  Wait!  Isn't there a chicken and egg problem.  How can you put the Cluster Registry in ASM when ASM isn't installed and running?  We're not really going to discuss that today, but through cunning and magic, the CRS development team figured it out.   Additionally, we introduce the ASM Filesystem, thus all other extended database related files can also be stored in ASM via ACFS filesystems.   Note that files stored traditionally in ASM will continue to be stored in ASM.  ACFS is not certified to be used to store database files.    ACFS should house Database Oracle Home and other extensible data file types associated with the database

AD4J Architecture

AD4J Architecture

 

Operates at JVM native layer for <0.1% overhead Snapshots only taken in response to console requests On-demand snapshots for real-time diagnostics Snapshots at monitoring frequency for historical diagnosis Post processing in console and repository  DB Agent allows the console to trace transaction from the application into the DB and back

图解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的主界面