French Translation

Franck Pachot has asked if he can translate some of the articles I’ve written and re-publish them on his blog. This page is a catalogue of the articles he has published to date. The highlighted links take you to his translations, but each line also holds a reference back to the original English article. Franck has also asked other authors if he can translate their work, and the second set of  links points to translation of (so far) Tom Kyte, Doug Burns, Cary Millsap and Greg Rahn.

Update Latest notes from Franck – Two articles from Greg Rahn on data warehouse performance, and five articles of mine – one on the 10g feature of private redo and in-memory undo, and the four in the “fragmentation” series:

Translation of articles that I have written:

Consistent Gets – an explanation of what Oracle means by a “consistent get”. (Original English version)

Clean it up – explanation of the different uses of the word “clean”. (Original English version)

The Interested Transaction List – a brief explanation of the ITL (The original English version is in the Oracle Glossary).

System Change / Commit Number – a brief explanation of the SCN. (The original English version is in the Oracle Glossary.)

Nutshell – 1 – Undo, redo, and recovery in a nutshell. (Original English version)

Glossary about Undo – a brief explanation of ‘undo segment header’ and ‘transaction table’. (The original English version is in the Oracle Glossary.)

Why Undo ? – Thoughts about why Oracle has implemented undo (Original English version)

Not Waiting – The importance of the state column in v$session_wait (Original English version)

Designing Efficient SQL: A Visual Approach (Original English version)

Parse Calls – A definition about parsing statistics (Original English version)

Nutshell – 2 – What is behind a parse call (Original English version)

Not Waiting – about WAITING, WAIT_TIME and  SECONDS_IN_WAIT (Original English Version)

Queue Time – see also the notes from Doug and Cary  below on through and response time (Original English Version)

Private redo Private Redo Threads and In-Memory Undo (Original English Version)

Fragmentation 1 – Introduction (Original English Version)

 Fragmentation 2 – Disk and Tablespace fragmentation (Original English Version)

 Fragmentation 3 – Table fragmentation (Original English Version)

 Fragmentation 4 – Index fragmentation (Original English Version)

Translations of articles by other authors:

Multi-Versioning and Concurrency by Tom Kyte (Original English version from AskTom)

Transaction Isolation Levels by Tom Kyte (Original English version from Oracle Magazine)

Object Relational Features of Oracle by Tom Kyte (Original English version from AskTom)

Write Consistency (update restart) Part 1 by Tom Kyte (Original English version from Tom’s Blog)

Write Consistency (update restart) Part 2 by Tom Kyte (Original English version from Tom’s Blog)

Write Consistency (update restart) Part 3 by Tom Kyte (Original English version from Tom’s Blog)

Time Matters: Throughput vs. Response Time by Doug Burns (Original English version)

Throughput vs. Response Time by Cary Millsap (Original English Version)

The Core Performance Fundamentals Of Oracle Data Warehousing – Set Processing vs Row Processing by Greg Rahn (Original English Version)

 The Core Performance Fundamentals Of Oracle Data Warehousing – Partitioning by Greg Rahn (Original English Version)