以下是我个人原创或总结的一些深入研究Oracle Internal内部原理的文章post列表:
Oracle Internal Event:10200 Consistent Read诊断事件
了解Oracle RAC Brain Split Resolution
了解你所不知道的SMON功能(九):维护MON_MODS$字典基表
了解你所不知道的SMON功能(八):Transaction Recover
了解你所不知道的SMON功能(六):Instance Recovery
了解你所不知道的SMON功能(五):Recover Dead transaction
了解你所不知道的SMON功能(四):维护col_usage$字典基表
Find INTCOL#=1001 in col_usage$?
Buffer Lock Mode and Compatibilities
Advanced Diagnostic using oradebug dumpvar
Only ARCH Bgprocess may create archivelog?
Who pulls the background process dbwr’s trigger?
基于行跟踪的ROWDEPENDENCIES ORA_ROWSCN信息
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?
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
Known Oracle Internal Stack Call Meaning
_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?
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
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工具相关的环境变量