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

Looking at the New Edition

Our technologist takes a first look at Oracle Database 11g Release 2. By Tom Kyte November/December 2009 In this issue, instead of using the usual...

On DBMS_ROWID, Parsing, and Sizing

Our technologist identifies rows, analyzes ratios, and fills space. By Tom Kyte September/October 2009 I have a partitioned table that spans multiple tablespaces,...

On Popularity and Natural Selection

Our technologist optimizes away binds and promotes more-selective queries. By Tom Kyte July/August 2009 It is time to do a “flashback query” of sorts and revisit...

On Wrong and Right

Our technologist checks the documentation and tests the answers. By Tom Kyte March/April 2009 I have a question about SPFILEs and parameter changes. If I make a...

On Dynamic Sampling

Our technologist samples dynamically, considers usage, and sets levels. By Tom Kyte January/February 2009 My questions are related to dynamic sampling. What does...

On Separation and Counting

Our technologist promotes more than one schema, counts partitions, and uses TKPROF. By Tom KyteNovember/December 2008 A data architect at work has proposed that...

The Trouble with Triggers

Our technologist looks at trigger maintenance and implementation challenges. By Tom Kyte September/October 2008 Those of you who frequent the asktom.oracle.com Web...

On Redefinition, Nature, and Triggers

Our technologist redefines tables, compares keys, and warns about DDL in triggers. By Tom Kyte July/August 2008 I have a table that contains millions of records,...

On Seeing Double in V$SQL

Our technologist looks at SQL repetition in V$SQL and differences in cardinality. By Tom Kyte May/June 2008 I often find more than one row in V$SQL for a given SQL...