Subscribe

Author Profile

Tom Kyte

In his 22 years at Oracle, Tom Kyte started the Ask Tom question and answer site and was the site's sole proprietor for almost 15 years. In his spare time, he also wrote Expert Oracle Database Architecture (Apress, 2005, 2010, 2014) and Effective Oracle by Design (Oracle Press, 2003), among other books. (The Ask Tom site continues today as Ask TOM: Ask The Oracle Masters.)

On Oracle Database 12c, Part 4

Our technologist talks with Oracle product management about Oracle Database 12c and the Oracle Multitenant option. By Tom Kyte March/April 2014 Usually I take...

On Oracle Database 12c, Part 3

Our technologist improves partitions, adapts query plans, and optimizes statistics gathering. By Tom Kyte January/February 2014 Usually I take three or four...

On Oracle Database 12c, Part 2

Our technologist finds a match for his SQL and makes his undo temporary. By Tom KyteNovember/December 2013 Usually I take three or four user-submitted questions...

On Oracle Database 12c, Part 1

Our technologist improves default values, handles bigger datatypes, and FETCHes for the first time. By Tom Kyte September/October 2013 Usually I take three or four...

On Randomness, Syntax, and Mutation

Our technologist gets deterministic, delimited, and the opposite of trigger-happy. By Tom KyteJuly/August 2013 I have an UPDATE statement that returns two...

On Efficiency, Avoidance, and Performance

Our technologist uses brutally efficient DDL, answers trick questions, and suggests a scalar subquery. By Tom Kyte May/June 2013 I have a table that contains...

On Becoming Others, Limits, and Restoration

Our technologist assumes identities, eliminates external limitations, and recovers constraints. By Tom Kyte March/April 2013 I got handed this requirement, and I...

On Promotion, Restriction, and Data Loading

Our technologist provides missing links, custom sizes, and external table tips. By Tom Kyte January/February 2013 Steven Feuerstein posted a URL that contains all...

On External Table Queries, Data Consistency, and Nothing

Our technologist queries the operating system, locks manually, and uses the right NULL. By Tom Kyte November/December 2012 In some of my customer’s databases, the...