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 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...

On Clustering Factor and Validating Keys

Our technologist explains different statistics and very foreign keys. By Tom Kyte September/October 2012 I created the following table and index to see...

On Characters, Pivots, and Endings

Our technologist substitutes characters, looks at fishy results, and avoids redo. By Tom Kyte July/August 2012 I want to insert a value into a table as follows: crea...

On Connection Pools, Cursor Differentiation, and Optimal Ordering

Our technologist cleans pools, explores cursor types, and looks for order in table creation. By Tom Kyte May/June 2012 We are facing severe performance issues on...

On Unlearning and Modeling

Photography by Scott Webb, Unsplash Our technologist goes back to school for Oracle Exadata and vows to be a MODEL student. By Tom Kyte March/April 2012 I...

On History, Basics, and Network Performance

Our technologist recalls a Web seminar, gives the right hint, and dishes on network performance. By Tom Kyte January/February 2012 I recently delivered an online...

On Collaboration, Testing, When, and Why

Our technologist learns from you, is tested on testing, and propagates errors. By Tom Kyte November/December 2011 I am often asked how I got to know so much about...

On Caching and Evangelizing SQL

Our technologist caches scalar subqueries, votes for SQL, and recommends technology and community. By Tom Kyte September/October 2011 One of the talks I gave...

On Better Loading and Fact-Checking

Photography by Ricardo Gomez, Unsplash Our technologist enjoys the rule of external tables and debunks index scan myths. By Tom Kyte July/August 2011 I’m working to...