This page covers items about the general need for tuning and performance monitoring - what to look for, how to look for it, and how (sometimes) to pre-empt it.
| Title | Content | Last update |
| Sort Usage | A correction to v$sort_usage in Oracle 8.1.5 | 24-Nov-2000 |
| Intro to Explain Plan | An introduction to the basic features of EXPLAIN PLAN | 30-Jun-2000 |
| Explain Plan 2 | Explain plan with parallel queries, partitioned table, and some funnies. | 30-Jun-2000 |
| Performance Now | A package to take performance snapshots or dump stats since startup | 18-May-1999 |
| Sort Usage | An Oracle 7 utility to identify who is doing sorting | 07-Apr-1999 |
| Memory Hogs | Spotting memory hungry Oracle processes without connecting | 01-Apr-1999 |
| Logs of performance | Using utl_file to log a series of performance snapshots. | 24-Mar-1999 |
| Parameter list | Yet another simple (Oracle 8) dump of the current parameter list | 03-Mar-1999 |
| Old V$ | What's been around but ignored in V$ for Oracle 7 | 26-Feb-1999 |
| PQ Costs | How effective was your last Parallel Query | 17-Feb-1999 |
| Tuning | 3 scripts for (almost) total performance monitoring | 17-Feb-1999 |
| Wrong Plans | A class of queries that makes Explain Plan go wrong | 10-Feb-1999 |
| Deltas | A sample of awk, cut,and paste for low-impact monitoring (UNIX) | 10-Feb-1999 |
| New V$s | What's new in the V$ area for Oracle 8 (and a symmetric difference) | 03-Feb-1999 |
| Strip SQL | A small C program to tidy up the listing from v$sql_text | 27-Jan-1999 |
| Waiting for files | An undocumented (X$) object to see where v$waitstat is happening | 21-Jan-1999 |
| Trace Pack | An idea for switching sql_trace on selectively in production systems | 21-Jan-1999 |
| Guilty Party | Who's the sinner and what's (s)he doing right now (Unix only) | 14-Jan-1999 |
| V$ Views | V$ Views - a health warning | 14-Jan-1999 |
| PQ Slaves | A better view definition for v$pq_slave | 08-Jan-1999 |
| Buffer content | What is in the db_block_buffer now (Oracle 8.0) | 08-Jan-1999 |
| Explain Plan | The oldest bug in Oracle ? | 07-Jan-1999 |
| Explain8 | A convenient framework for running explain plan against Oracle 8 | 07-Jan-1999 |
| Explain7 | A convenient framework for running explain plan against Oracle 7.3 | 07-Jan-1999 |