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 Blocks, Messages, Rows, and Queues

Our Oracle expert looks at block-level information, sending HTML messages, estimating rows, and AQ. By Tom Kyte March/April 2002 When I periodically delete records...

On Finding Order and Setting Packages Against Procedures

Our Oracle expert finds the right order, settles the packages-versus-procedures debate, and gathers information on collecting. By Tom KyteJanuary/February 2002 Sho...

Oracle9i Looks Past init.ora and SYS

Our Oracle expert looks at Oracle9i, init.ora, SPFILE, SYS, INTERNAL, and the last row. By Tom KyteNovember/December 2001 I've just installed Oracle9i . I changed...

On Different Users, Different Passwords, and Hidden Ability

Our technologist explores passwords, undocumented functionality, a different export, and different SGAs. By Tom KyteSeptember/October 2001 I am running Oracle8i Re...

Getting Just the Rows I Want

Our Oracle expert looks for the number of rows searched, the fastest way to go, and how to automate the creation of a materialized view. By Tom Kyte July/August...

Java, the ESCAPE Sequence, and Synonym Alternatives

  Our Oracle expert expounds on serializing Java objects, using ESCAPE with LIKE, communicating return code from SQL*Plus, and using a synonym to view. By Tom...

Tips on Automation, Cleanup, and Database Maintenance

Our Oracle expert illustrates automatic index maintenance, shows you how to clean up killed sessions faster, and explains differences in Oracle releases. By Tom...

Tips on Speeding Up, Working Out, and Getting Secure

Our Oracle expert shares his wisdom on function-based indexes, SQL, Net8 listener, and user lists. By Tom Kyte January/February 2001 We use an application that...

Java Tips, JDBC, PL/SQL Stored Procedures, and Custom Prompts

Working with Java is simpler now that it's a native part of the Oracle database. Here are some interesting questions I've received about using Java. By Tom Kyte No...