Oracle Internal Research深入研究Oracle内部原理

以下是我个人原创或总结的一些深入研究Oracle Internal内部原理的文章post列表:

Oracle Internal Event:10200 Consistent Read诊断事件

了解Oracle RAC Brain Split Resolution

了解Oracle内核代码层的作用

了解你所不知道的SMON功能(九):维护MON_MODS$字典基表

了解你所不知道的SMON功能(八):Transaction Recover

了解你所不知道的SMON功能(七):清理IND$字典基表

了解你所不知道的SMON功能(六):Instance Recovery

了解你所不知道的SMON功能(五):Recover Dead transaction

了解你所不知道的SMON功能(四):维护col_usage$字典基表

了解你所不知道的SMON功能(三):清理obj$基表

了解你所不知道的SMON功能(二):合并空闲区间

了解你所不知道的SMON功能(一):清理临时段

Know more about commit

Find INTCOL#=1001 in col_usage$?

Buffer Lock Mode and Compatibilities

关于V$OPEN_CURSOR

Advanced Diagnostic using oradebug dumpvar

还原真实的cache recovery

Oracle内部视图:x$targetrba

Oracle内部视图:x$ktfbfe

Oracle内部视图:x$ktfbue

Only ARCH Bgprocess may create archivelog?

Oracle Latch:一段描绘Latch运作的伪代码

Who pulls the background process dbwr’s trigger?

基于行跟踪的ROWDEPENDENCIES ORA_ROWSCN信息

Oracle闩:Cache Buffers chains

Latches and Tuning:Latches

Latches and Tuning:Redo Log Buffer and Latches

Latches and Tuning:Buffer Cache

Latches and Tuning:The Library CacheOracle等待事件ata file init write

How does RECORDLENGTH affect your exp speed?

Oracle网络TNS协议介绍(revised)

logfile switch causes incremental checkpoint?

Know more about redo log buffer and latches

How does cpu_count parameter affect instance?

How to trigger ORA-00600,ORA-7445 by manual

Basics of C code within the Oracle kernel

Know more about Oracle Latches

Know more about Buffer Cache and Latch

Know More About Libarary Cache and Latches

Oracle内部视图:X$BH

Know more about DML

Known Oracle Internal Stack Call Meaning

深入了解ASMM

_shared_pool_reserved_pct or shared_pool_reserved_size with ASMM

PL/SQL Virtual Machine Memory Usage

Slide:深入了解Oracle自动内存管理ASMM by Maclean Liu

Know GCS AND GES structure size in shared pool

How does SGA/PGA allocate on AMM?

理解Oracle在AIX平台上的内存使用

Probe how does your PGA consume

ora-4031 and “obj stat memory” component in Shared Pool

直接路径读取对于延迟块清除的影响

How to make BBED(Oracle Block Brower and EDitor Tool) on Unix/Linux/Windows

隐藏参数_high_priority_processes与oradism

Oracle等待事件Enqueue CI:Cross Instance Call Invocation

Oracle常用的几个父栓

ddl操作是否会产生undo?

kgl simulator，共享池simulator以及缓冲simulator相关解释

Oracle等待事件KJC:Wait for msg sends to complete
了解SYSDATE函数
Oracle等待事件kfk:async disk IO
Does Rman Backup benefit from Large Pool?
Oracle RAC Brain Split Resolution
Startup Upgrade为我们做了什么？

介绍dbms_registry PL/SQL程序包
Oracle中可以nologging执行的操作
Applying online patch on 11gr2
利用DBMS_ADVISOR.TUNE_MVIEW包生成物化视图创建语句
Oracle中可被并行化执行的SQL操作
Which SQL Operation May use Temp space?
Oracle Advanced Security:Column Encryption Overhead
Discover Your Missed ASM Disks
latch free:cache buffer handles造成的SQL性能问题

Oracle Internal Event:10201 consistent read undo application诊断事件

何时会发生db file sequential read等待事件？

手工模拟Oracle数据块逻辑讹误引发ORA-00600:[13013], [5001]一例

ASM file metadata operation等待事件
了解Oracle后台进程与数据库文件的读写关系

深入了解Oracle数据字典升级脚本catupgrd.sql调用过程

了解高水位与truncate

Warning:Even Exadata has a wrong memlock setting

Script Diagnostic Oracle Locks
利用Cluster Verify Utility工具体验RAC最佳实践
利用ProcDump工具诊断Windows平台上的Oracle数据库性能
OPatch工具相关的环境变量