Skip to Main Content

Chinese

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Maclean LiuJan 22 2012 — edited Aug 24 2012

<p align="left">以下是Maclean.Liu个人原创或总结的一些深入研究Oracle Internal内部原理的文章post列表:<u><br>
</u></p>
<br>
<p align="left"><strong>Oracle Internal Event:10200 Consistent Read诊断事件</strong></p>
<p align="left"><strong>了解Oracle RAC Brain Split Resolution</strong></p>
<p align="left"><strong>了解Oracle内核代码层的作用</strong></p>
<p align="left"><strong>了解你所不知道的SMON功能(九):维护MON_MODS$字典基表</strong></p>
<p align="left"><strong>了解你所不知道的SMON功能(八):Transaction Recover</strong></p>
<p align="left"><strong>了解你所不知道的SMON功能(七):清理IND$字典基表</strong></p>
<p align="left"><strong>了解你所不知道的SMON功能(六):Instance Recovery</strong></p>
<p align="left"><strong>了解你所不知道的SMON功能(五):Recover Dead transaction</strong></p>
<p align="left"><strong>了解你所不知道的SMON功能(四):维护col_usage$字典基表</strong></p>
<p align="left"><strong>了解你所不知道的SMON功能(三):清理obj$基表</strong></p>
<p align="left"><strong>了解你所不知道的SMON功能(二):合并空闲区间</strong></p>
<p align="left"><strong>了解你所不知道的SMON功能(一):清理临时段</strong></p>
<p align="left"><strong>Know more about commit</strong></p>
<p align="left"><strong>Find INTCOL#=1001 in col_usage$?</strong></p>
<p align="left"><strong>Buffer Lock Mode and Compatibilities</strong></p>
<p align="left"><strong>关于V$OPEN_CURSOR</strong></p>
<p align="left"><strong>Advanced Diagnostic using oradebug dumpvar</strong></p>
<p align="left"><strong>还原真实的cache recovery</strong></p>
<p align="left"><strong>Oracle内部视图:x$targetrba</strong></p>
<p align="left"><strong>Oracle内部视图:x$ktfbfe</strong></p>
<p align="left"><strong>Oracle内部视图:x$ktfbue</strong></p>
<p align="left"><strong>Only ARCH Bgprocess may create archivelog?</strong></p>
<p align="left"><strong>Oracle Latch:一段描绘Latch运作的伪代码</strong></p>
<p align="left"><strong>Who pulls the background process dbwr’s trigger?</strong></p>
<p align="left"><strong>基于行跟踪的ROWDEPENDENCIES ORA_ROWSCN信息</strong></p>
<p align="left"><strong>Oracle闩:Cache Buffers chains</strong></p>
<p align="left"><strong>Latches and Tuning:Latches</strong></p>
<p align="left"><strong>Latches and Tuning:Redo Log Buffer and Latches</strong></p>
<p align="left"><strong>Latches and Tuning:Buffer Cache</strong></p>
<p align="left"><strong>Latches and Tuning:The Library Cache Oracle等待事件<img src="http://%5c%22static/image/smiley/qqbiaoqin/29.gif%5C%22" alt="">ata file init write</strong></p>
<p align="left"><strong>How does RECORDLENGTH affect your exp speed?</strong></p>
<p align="left"><strong>Oracle网络TNS协议介绍(revised)</strong></p>
<p align="left"><strong>logfile switch causes incremental checkpoint?</strong></p>
<p align="left"><strong>Know more about redo log buffer and latches</strong></p>
<p align="left"><strong>How does cpu_count parameter affect instance?</strong></p>
<p align="left"><strong>How to trigger ORA-00600,ORA-7445 by manual</strong></p>
<p align="left"><strong>Basics of C code within the Oracle kernel</strong></p>
<p align="left"><strong>Know more about Oracle Latches</strong></p>
<p align="left"><strong>Know more about Buffer Cache and Latch</strong></p>
<p align="left"><strong>Know More About Libarary Cache and Latches</strong></p>
<p align="left"><strong>Oracle内部视图:X$BH</strong></p>
<p align="left"><strong>Know more about DML</strong></p>
<p align="left"><strong>Known Oracle Internal Stack Call Meaning</strong></p>
<p align="left"><strong>深入了解<strong>ASMM</strong></strong></p>
<p align="left"><strong>sharedpool_reserved_pct or shared_pool_reserved_size with ASMM</strong></p>
<p align="left"><strong>PL/SQL Virtual Machine Memory Usage</strong></p>
<p align="left"><strong>Slide:深入了解Oracle自动内存管理ASMM by Maclean Liu</strong></p>
<p align="left"><strong>Know GCS AND GES structure size in shared pool</strong></p>
<p align="left"><strong>How does SGA/PGA allocate on AMM?</strong></p>
<p align="left"><strong>理解Oracle在AIX平台上的内存使用</strong></p>
<p align="left"><strong>Probe how does your PGA consume</strong></p>
<p align="left"><strong>ora-4031 and “obj stat memory” component in Shared Pool</strong></p>
<p align="left"><strong>直接路径读取对于延迟块清除的影响</strong></p>
<p align="left"><strong>How to make BBED(Oracle Block Brower and EDitor Tool) on Unix/Linux/Windows</strong></p>
<p align="left"><strong>隐藏参数_high_priority_processes与oradism</strong></p>
<p align="left"><strong>Oracle等待事件Enqueue CI:Cross Instance Call Invocation</strong></p>
<p align="left"><strong>Oracle常用的几个父栓</strong></p>
<p align="left"><strong>ddl操作是否会产生undo?</strong><br>
</p>
<p><strong>kgl simulator，共享池simulator以及缓冲simulator相关解释</strong></p>
<p><br>
</p>
<p>Oracle等待事件KJC:Wait for msg sends to complete<br>
了解SYSDATE函数<br>
Oracle等待事件kfk:async disk IO<br>
Does Rman Backup benefit from Large Pool?<br>
Oracle RAC Brain Split Resolution<br>
Startup Upgrade为我们做了什么？<br>
<br>
介绍dbms_registry PL/SQL程序包<br>
Oracle中可以nologging执行的操作<br>
Applying online patch on 11gr2<br>
利用DBMS_ADVISOR.TUNE_MVIEW包生成物化视图创建语句<br>
Oracle中可被并行化执行的SQL操作<br>
Which SQL Operation May use Temp space?<br>
Oracle Advanced Security:Column Encryption Overhead<br>
Discover Your Missed ASM Disks<br>
latch free:cache buffer handles造成的SQL性能问题<br>
<br>
<strong>Oracle Internal Event:10201 consistent read undo application诊断事件<br>
<br>
何时会发生db file sequential read等待事件？<br>
<br>
手工模拟Oracle数据块逻辑讹误引发ORA-00600:[13013], [5001]一例<br>
<br>
ASM file metadata operation等待事件<br>
了解Oracle后台进程与数据库文件的读写关系<br>
<br>
深入了解Oracle数据字典升级脚本catupgrd.sql调用过程<br>
<br>
了解高水位与truncate<br>
<br>
Warning:Even Exadata has a wrong memlock setting</strong><br>
<br>
Script Diagnostic Oracle Locks<br>
<strong>利用Cluster Verify Utility工具体验RAC最佳实践<br>
利用ProcDump工具诊断Windows平台上的Oracle数据库性能<br>
OPatch工具相关的环境变量</strong></p>

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 21 2012

Added on Jan 22 2012

#ask-maclean, #产品, #数据库

7 comments

402 views