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

Oracle Database 11g Redux

Our technologist continues to explore Oracle Database 11g features. By Tom Kyte March/April 2008 I've received some good questions since the last issue of Oracle...

On Tuning by Tracing

Our technologist does a tune-up with SQL_TRACE. By Tom Kyte January/February 2008 My all-time favorite presentation is called "All About Binds." It takes me about...

More on Oracle Database 11g

Our technologist takes another look at Oracle Database 11g. By Tom Kyte November/December 2007   Last issue, I wrote about some new Oracle Database 11g features,...

On Oracle Database 11g

Our technologist takes a look at the server results and PL/SQL function caches. By Tom Kyte September/October 2007 Over the next few months, I'll be looking at new...

On Ignoring, Locking, and Parsing

Our technologist looks out for WHEN OTHERS, locks, cascades, and parses. By Tom Kyte July/August 2007 There's a programming construct, WHEN OTHERS, in PL/SQL that...

On Loading and Extents

Our technologist follows the direct path and optimizes extent usage. By Tom Kyte May/June 2007 We are loading lots of files (49,000+) into a database, using...

On Cursors, SQL, and Analytics

Our technologist referees between cursors, SQL statements, analytics, and aggregates. By Tom Kyte March/April 2007 I must make a new table based on the data of,...

On Top-n and Pagination Queries

Our technologist gets more results using ROW_NUMBER, RANK, and DENSE_RANK. By Tom Kyte January/February 2007 In a recent Ask Tom column (September/October 2006),...

On Rescue Analytics and Popularity

Our technologist optimizes away binds and promotes more-selective queries. By Tom Kyte November/December 2006 Our technologist explains the saving power of...