Jame Tong, a DBA from China, has asked if he can translate existing articles of mine into Chinese and publish them on his blog. I think it’s a good idea and have given him permission, so he will be sending me an email with a URL whenever he finds time to translate a piece, and I’ll let everyone know about it.
This is a catalogue of the articles he has published to date – he’s started with a few of my older articles rather than recent blog items. The highlighted links are to his translations, and each a reference back to the original English.
Why isn’t Oracle using my Index ? – a brief introduction to Cost Based Optimisation. (English version (MS Word .doc file))
Stored Outlines in 8i/9i – Notes about using “stored outline” (a.k.a. “plan stability”) in 8i and 9i. (English version (MS Word .rtf file))
Faking Stored Outlines in 9i – Notes about how the 8i method for faking stored outlines is no longer suitable for 9i. (English Version (MSWord .doc file))
“Unbalanced” Indexes – An explanation of why it is very silly to say that Oracle’s B-tree indexes can get “unbalanced”; and a couple of suggestions why this idea has taken so long to eliminate. (English version (MSWord .doc file)
Log file switch – notes on affecting the timing of log file switches. (Original English version).
Undo and Redo – a brief summary of undo,redo and recovery (Original English version)
Parse calls – a warning note about interpreting the “parse calls” statistic (Original English version)
Fragmentation 1 – An introduction to what we mean by fragmentation in different contexts (Original English version)
A Visual Approach to Designing Efficient SQL: An article I wrote for Simple-Talk, the title says it all. (Original English Version).