Oracle Magazine Ask Tom Columns

Tom Kyte is a database evangelist in Oracle’s Server Technologies division and has worked for Oracle since 1993. He is the author of Expert Oracle Database Architecture (Apress, 2005, 2010) and Effective Oracle by Design (Oracle Press, 2003), among other books.

Pub Date	Title	Description
May/June 2014	On Oracle Database 12c, Part 5	Our technologist explores the invisible, improves introspection, and expands SQL.
March/April 2014	On Oracle Database 12c, Part 4	Our technologist talks with Oracle product management about Oracle Database 12c and the Oracle Multitenant option.
January/February 2014	On Oracle Database 12c, Part 3	Our technologist improves partitions, adapts query plans, and optimizes statistics gathering
November/December 2013	On Oracle Database 12c, Part 2	Our technologist finds a match for his SQL and makes his undo temporary.
September/October 2013	On Oracle Database 12c, Part 1	Our technologist improves default values, handles bigger datatypes, and FETCHes for the first time.
July/August 2013	On Randomness, Syntax, and Mutation	Our technologist gets deterministic, delimited, and the opposite of trigger-happy.
May/June 2013	On Efficiency, Avoidance, and Performance	Our technologist uses brutally efficient DDL, answers trick questions, and suggests a scalar subquery.
March/April 2013	On Becoming Others, Limits, and Restoration	Our technologist assumes identities, eliminates external limitations, and recovers constraints.
January/February 2013	On Promotion, Restriction, and Data Loading	Our technologist queries missing links, custom sizes, and external table tips.