|
September 2001 | ||
|
Over committed | - Are your commits hurting you? | |
|
Making a hash of it | - Tuning hash joins with event 10104 | |
|
June 2001 | ||
|
Searching questions | - Improvements to the Ixora search engine | |
|
Briefly busy | - Catching buffer busy waits with SQL | |
|
Temporary confusion | - Sorting out temporary tablespaces | |
|
May 2001 | ||
|
Sin-onyms | - Are synonyms really bad? | |
|
Not so fast | - Incremental checkpointing can defeat commit cleanouts | |
|
April 2001 | ||
|
Histogram helper | - Help with histogram creation | |
|
Dependent SQL | - Profiling current table usage | |
|
Keeper fix | - A fix to keeper.sql | |
|
March 2001 | ||
|
Saving time | - How to tune Oracle CPU usage | |
|
Which way there? | - A script to consider alternative table access paths | |
|
A recursive ideal | - Tuning the buffer pool sizes under Oracle 8i | |
|
February 2001 | ||
|
Fingerprints | - Using V$LATCH_MISSES to characterize latching problems | |
|
Buying time | - How purchasing decisions affect Oracle CPU usage | |
|
No more double trouble | - The Oracle8i snapshot problems are fixed | |
|
January 2001 | ||
|
A change of heart | - Start your web searches at Ixora | |
|
Pressed for time | - Understanding the components of response time | |
|
December 2000 | ||
|
The best sort | - Using event 10032 to set sort_area_size | |
|
What's in a name? | - Why to avoid long file names and big directories | |
|
Large log buffers | - Not so bad since Oracle8 | |
|
November 2000 | ||
|
Sort memory | - Do you tolerate unnecessary disk sorts? | |
|
cache buffers chains latches | - Why less is more under Oracle8i | |
|
Tuning checkpoints | - A new approach to an old problem | |
|
October 2000 | ||
|
Index compression | - An 8i performance boon waiting for you | |
|
The 8i buffer cache | - An explanation of the LRU algorithm in 8i | |
|
SAME | - Stripe And Mirror Everything - Really? | |
|
September 2000 | ||
|
Get answers fast | - A mailing list for advanced performance tuning answers | |
|
The cool pool | - Shared pool fragmentation problems are history in 8.1.6 | |
|
DBWn's new tricks | - This old dog can juggle multiple write batches under 8i | |
|
APT scripts news | - Changes to our collection of advanced performance tuning scripts | |
|
August 2000 | ||
|
A comment about comments | - How NOT to comment out code in SQL scripts | |
|
Double trouble | - Some performance problems with snapshots in Oracle 8.1 | |
|
More new APT scripts | - A few more additions to our collection of advanced performance tuning scripts | |
|
July 2000 | ||
|
Modification monitoring | - Why you should use it | |
|
New pool rules | - Controlling shared pool fragmentation under Oracle 8.1 | |
|
New APT scripts | - A few additions to our collection of advanced performance tuning scripts | |
|
June 2000 | ||
|
Basic queuing | - An undocumented SQL statement for implementing a simple queuing mechanism | |
|
Tuning the redo copy latches | - There are big changes in how the redo copy latches are used in Oracle 8.1 | |
|
The 8i log_buffer "maximum" | - A shrewd documentation illusion | |
|
objects_on_hot_latches.sql | - An APT script explained | |
|
© Ixora Pty Ltd. All rights reserved.
12-Oct-2007 22:22 |
|