This index covers all the active items on the site. Eventually it will list only those items that do not fall into an obvious category.
| Title | Content | Last update |
| Analytic | An introduction to Analytic functions in 8.1.6 | 21-Dec-2000 |
| Sort Usage | A correction to v$sort_usage in Oracle 8.1.5 | 24-Nov-2000 |
| Free Space | How much space is actually free in a data segment (update) | 13-Nov-2000 |
| My statistics | Seeing the statistics for my own session. | 29-Aug-2000 |
| Optimising sorts | An insight into optimiser evolution and sorting (7.3 to 8.1) | 29-Aug-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 |
| Sequences | All about sequences (7 and 8) | 24-Sep-1999 |
| Setting SID | Selecting and setting the Oracle SID (Unix) | 7-Sep-1999 |
| Block Dump | How to dump an Oracle 8 block (updated) | 7-Sep-1999 |
| Losing SQL text | A minor bug in v$sql et. al. that 'loses' SQL text (updated) | 7-Sep-1999 |
| SDU | Widening the pipeline from client to server | 17-Aug-1999 |
| OSOPER | Does anyone ever use it ? (Unix) | 17-Aug-1999 |
| Dimensions | Summary management and Query Rewrite with prebuilt tables | 04-Aug-1999 |
| Buffer content | What is in the db_block_buffer now (Oracle 8.0) (correction) | 04-Aug-1999 |
| Shell Arrays | Passing multiple results from SQL*Plus to the shell (Unix) | 04-Aug-1999 |
| PL/SQL arrays v7 | Turning a PL/SQL array into an SQL statement (in v7) | 22-Jul-1999 |
| What a bind | Binding and Bind variables in dbms_sql | 13-Jul-1999 |
| Old Wives Tales | Folk lore and fairy tales about Oracle databases | 13-Jul-1999 |
| Dynamic pl/sql | If you really want to, you can do dynamic selects in PL/SQL | 5-July-1999 |
| Dummy data | Generating numeric lists without using a dummy table | 29-Jun-1999 |
| 2D partitions | Hash sub-partitions in 8i can give you 2 dimensional partitioning | 23-Jun-1999 |
| In lists | One variable interpreted as an IN list (V 8.0) | 12-Jun-1999 |
| User / Owner | Executing dynamic sql in packages as User, not Owner in in v7 | 11-Jun-1999 |
| PL/SQL tables | Turning a PL/SQL table into an SQL statement (v8) | 11-Jun-1999 |
| PQ Slaves | A better view definition for v$pq_slave (updated) | 11-Jun-1999 |
| Scheduling | A demonstraton of managing concurrent proceses under Oracle | 3-Jun-1999 |
| Performance Now | A package to take performance snapshots - added t/s I/O and filenames | 3-Jun-1999 |
| Concurrency | A mechanism for concurrent execution of lists of tasks | 26-May-1999 |
| commitscn | A bizarre undocumented feature | 26-May-1999 |
| Am I tracing | A way to find out if your session is running with SQL Trace true | 26-May-1999 |
| Big Update | A cunning (Y2K) plan to update most of a very large table efficiently | 18-May-1999 |
| Block Dump 7 | How to dump an Oracle 7 block. | 18-May-1999 |
| Dec to Hex | A decimal to Hexadecimal function in PL/SQL | 18-May-1999 |
| PLSQL arrays | Array based dynamic SQL in PL/SQL (8.0) | 6-May-1999 |
| Where and When | Order of execution in a WHERE clause with NO indexes | 6-May-1999 |
| Flush | An idea on allowing ordinary users selective DBA rights | 30-Apr-1999 |
| dbms_sql | A little wrapper for simple dynamic SQL | 30-Apr-1999 |
| Buffer Flag | Interpreting the x$bh buffer header flag | 30-Apr-1999 |
| Cache | How Oracle 7 handles small tables and caching | 22-Apr-1999 |
| 3 Buffers | Oracle 8's answer to Placido Domingo et. al. (and caching) | 22-Apr-1999 |
| Packing a table | A new feature in 7.3.4 for packing a table | 07-Apr-1999 |
| Sort Usage | An Oracle 7 utility to identify who is doing sorting (15K file) | 07-Apr-1999 |
| PT Defect | When partition views work better than partition tables | 01-Apr-1999 |
| Memory Hogs | Spotting memory hungry Oracle processes without connecting | 01-Apr-1999 |
| Inline Speed | How in-line views can improve performance dramatically | 25-Mar-1999 |
| Logs of performance | Using utl_file to log a series of performance snapshots. | 24-Mar-1999 |
| Meaning of errors | A simple NT utility to emulate the Unix oerr command | 24-Mar-1999 |
| Raw or FS | A study of how the choice can affect Oracle performance | 15-Mar-1999 |
| Audit Connect | A very cheap early warning that something is going wrong. | 15-Mar-1999 |
| TS Build | Building multiple large tablespaces concurrently | 3-Mar-1999 |
| Parameter list | Yet another simple (Oracle 8) dump of the current parameter list | 3-Mar-1999 |
| Block size | A simple C program to help you pick an Oracle block size | 26-Feb-1999 |
| Old V$ | What's been around but ignored in V$ for Oracle 7 | 26-Feb-1999 |
| What's going on | A non-invasive PL/SQL tool for performance snapshots | 24-Feb-1999 |
| PQ Costs | How effective was your last Parallel Query | 17-Feb-1999 |
| Bad PQ Slaves | Identifying parallel query slaves that won't die. | 17-Feb-1999 |
| Tuning | 3 scripts for (almost) total performance monitoring (Pts 1,2 &3) | 17-Feb-1999 |
| Buffer size | db_block_buffers can be too big | 10-Feb-1999 |
| Extent count | Sometimes fewer extents to an object is a good thing | 10-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) | 3-Feb-1999 |
| PQO (pt 2) | Some real life experience with the Parallel Query Option (7.3) | 3-Feb-1999 |
| PQO (pt 1) | An introduction to the Parallel Query Option (7.3) | 27-Jan-1999 |
| Strip SQL | A small C program to tidy up the listing from v$sql_text | 27-Jan-1999 |
| DW | A data warehouse case study | 21-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 |
| PVs | An introduction to Partition Views (7.3) | 14-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 |
| PT Quirk | A Partition Elimination anomaly in partition tables (and views) | 09-Jan-1999 |
| PVs or PTs | A comparison of 7.3 partition views and 8.0 partition tables | 09-Jan-1999 |
| Bitmaps | Bitmap indexes in Oracle 7.3.2 | 09-Jan-1999 |
| smon | What does SMON do. | 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 |