Pub Date |
Title |
Description |
| November/December 2009 |
Looking at the New Edition |
Our technologist takes a first look at Oracle Database 11g Release 2. |
| September/October 2009 |
On DBMS_ROWID, Parsing, and Sizing |
Our technologist identifies rows, analyzes ratios, and fills space. |
| July/August 2009 |
On Popularity and Natural Selection |
Our technologist optimizes away binds and promotes more-selective queries. |
| May/June 2009 |
On Constraints, Metadata, and Truth |
Our technologist uses constraints to improve query performance. |
| March/April 2009 |
On Wrong and Right |
Our technologist checks the documentation and tests the answers. |
| January/February 2009 |
On Dynamic Sampling |
Our technologist samples dynamically, considers usage, and sets levels. |
| November/December 2008 |
On Separation and Counting |
Our technologist promotes more than one schema, counts partitions, and uses TKPROF. |
| September/October 2008 |
The Trouble with Triggers |
Our technologist looks at trigger maintenance and implementation challenges. |
| July/August 2008 |
On Redefinition, Nature, and Triggers |
Our technologist redefines tables, compares keys, and warns about DDL in triggers. |
| May/June 2008 |
On Seeing Double in V$SQL |
Our technologist looks at SQL repetition in V$SQL and differences in cardinality. |
| March/April 2008 |
Oracle Database 11g Redux |
Our technologist continues to explore Oracle Database 11g features. |
| January/February 2008 |
On Tuning by Tracing |
Our technologist does a tune-up with SQL_TRACE. |
| November/December 2007 |
More on Oracle Database 11g |
Our technologist takes another look at Oracle Database 11g. |
| September/October 2007 |
On Oracle Database 11g |
Our technologist takes a look at the server results and
PL/SQL function caches.
|
| July/August 2007 |
On Ignoring, Locking, and Parsing |
Our technologist looks out for WHEN OTHERS, locks, cascades, and parses.
|
| May/June 2007 |
On Loading and Extents |
Our technologist follows the direct path and optimizes extent usage.
|
| March/April 2007 |
On Cursors, SQL, and Analytics |
Our technologist referees between cursors, SQL statements, analytics, and aggregates.
|
| January/February 2007 |
On Top-n and Pagination Queries |
Our technologist gets more results using ROW_NUMBER, RANK, and DENSE_RANK.
|
| November/December 2006 |
On Rescue Analytics and Popularity |
Our technologist explains the saving power of analytics and shares popularity.
|
| September/October 2006 |
On ROWNUM and Limiting Results |
Our technologist explains how ROWNUM works and how to make it work for you.
|
| July/August 2006 |
On Speeding, Dating, and Spelling |
Our technologist finds the OS, makes things appear faster, dates clients, and spells out numbers. |
| May/June 2006 |
On Joins and Query Plans |
Our technologist optimizes joins and explains changing plans. |
| March/April 2006 |
On Deduping and Ordering |
Our technologist deletes duplicates, gives trigger orders, and explains how SELECT locks. |
| January/February 2006 |
On Sharing, Splitting, and Deleting |
Our technologist shares cursors, splits large tables, and deletes securely. |
| November/December 2005 |
On Transaction Isolation Levels |
Our technologist isolates transactions safely. |
| September/October 2005 |
My First Day with the New Release |
Our technologist talks about his first experience with Oracle Database 10g Release 2. |
| July/August 2005 |
On Searching and Synonyms |
Our technologist searches, moves, and finds synonyms. |
| May/June 2005 |
On Favorites and CONNECT BY |
Our technologist picks, expands, loads, and dates. |
| March/April 2005 |
On Rollups, Merges, and Moves |
Our technologist materializes, merges, and moves. |
| January/February 2005 |
On Injecting and Comparing |
Our technologist speaks on safe injections, comparing tables, and materialized views. |
| November/December 2004 |
On Partitioning and Pipelining |
Our technologist speaks on UNION ALL, pipelines, and Saturdays. |
| September/October 2004 |
On Fetching, Storing, and Indexing |
Our technologist fetches sequentially, stores inline, and indexes globally. |
| July/August 2004 |
On Numbers and Analytics |
Our technologist searches, numbers, analyzes, and orders.
|
| May/June 2004 |
On Sorts, Selecting, and Selectivity |
Our technologist looks at sorting, cursors, architecting, selecting, and extracting.
|
| March/April 2004 |
On Format, Negation and Sliding |
Our technologist discusses determining space required, randomizing, and partition outer joins. |
| January/February 2004 |
On Uniqueness, Space, and Numbers |
Our technologist modifies formats, makes zeros zeros, and avoids slides.
|
| November/December 2003 |
On Constraints, CASE, and Cursors |
Our technologist talks integrity, time, and belonging. |
| September/October 2003 |
On HTML DB, Bulking Up, and Speeding |
Our technologist looks at Oracle Database 10g's HTML DB, building bulk, and improving speed. |
| July/August 2003 |
On Procedures, Flushes, and Writes |
Our expert compares triggers procedures, flushing, and not flushing. |
| May/June 2003 |
On Measuring Distance and Aging |
Our expert computes distance without aging and highlights favorite Oracle9i features. |
| March/April 2003 |
On Partitions, Lookups, and Integrity |
Our expert partitions, looks up with a PL/SQL table, and does everything with referential integrity. |
| January/February 2003 |
On the Explicit, Size, and Complex |
Our techologist answers questions on cursors, extents, and intervals. |
| November/December 2002 |
On Asking, Chaining, and Decoding. |
Our technologist answers questions about questions, chained rows, and decoding. |
| September/October 2002 |
Now Showing and Playing. |
Our Oracle technologist shows how to use the unused index and how to play. |
| July/August 2002 |
Parsing Densities, ANYDATA, and XML. |
Our technologist looks at the hard parse, the soft parse, and the softer parse. |
| May/June 2002 |
On Creating, Dating, and Binding |
Our technologist creates XML, translates dates, and binds variables. |
| March/April 2002 |
Blocks, Messages, Rows |
A look at block-level information, HTML
messages, estimating rows, and AQ. |
| January/February 2002 |
Finding Order |
Our technologist settles the packages-versus-procedures debate. |
| November/December 2001 |
Beyond Init.ora and SYS |
Oracle9i, init.ora, SPFILE, SYS, INTERNAL, and the last row. |
| September/October 2001 |
On Different Users, Different Passwords, and Hidden Ability |
Passwords, undocumented functionality, a different export, and different SGAs. |
| July/August 2001 |
Getting What You Want |
Learn how to get just the rows you want. |
| May/June 2001 |
Java, the ESCAPE Sequence, and Synonym Alternatives |
Serializing Java objects, using ESCAPE with LIKE, communicating return code from SQL*Plus, and using a synonym to view. |
| March/April 2001 |
Automation, Cleanup, and Database Maintenance |
Automatic index maintenance, shows you how to clean up killed sessions faster, and explains differences in Oracle releases. |
| January/February 2001 |
Speeding Up, Working Out, and Getting Secure |
Function-based indexes, SQL, Net8 listener, and user lists. |
Bookmark
