Anything I stumble across in recent versions (as at the time I wrote it!) that looks good and is not part of the mega hyped features, I'll post here.
Topic |
Description |
|
| 15/10/2007 | The PROGRAM_ID is useful for tracking PL/SQL |
|
| 15/08/2007 | Changes in constraint handling in 10g |
|
| 18/04/2007 | Going from 32bit to 64bit? Take care!! |
|
| 09/01/2007 | Building indexes gives you statistics for free in 10g |
|
| 11/01/2006 | Some automatic sync facilities in 10g for text indexes |
|
| 30/09/2004 | Scheduling in 10g |
|
| 30/03/2004 | SQL Plus 10g - simple things are often the best |
|
| 08/08/2003 | Obtaining DDL made easy |
|
| 01/01/2003 | A 9i enhancement to tkprof to allow it see wait information |
|
| 01/01/2003 | Avoiding the pain your standby suffers when someone does a NOLOGGING operation |
|
| 01/01/2003 | A cure to the "Media Recovery needed" problems of shutdown during hot backup |
|
| 01/01/2003 | To do managed standby recovery, you need a SQL Plus session hanging around? Not any more |
|
| 27/01/2002 | (Updated) A possible issue with downloading patch 9.0.1.2 |
|
| 16/12/2002 | A better method for EXPLAIN PLAN results |
|
| 16/12/2002 | Sub-queries made easier to read |
|
| 16/12/2002 | Even SQL Plus gets a makeover in 9i |
|
| 16/12/2002 | Finally SYS has some real privilege power |
|
| 16/12/2002 | A new analytic which makes medians a doddle |
|
| 16/12/2002 | You can now include non-group'ed by expressions in the SELECT list |
|
| 16/12/2002 | A bug to what out for when using compressed primary key indexes |
|
| 02/12/2002 | A simple enhancement to make recording the occurrence of ORA-1555 |
|
| 21/10/2002 | The magic varchar2 column in 9i |
|
| 16/07/2002 | Maybe the number of extents does matter (but its better in 9i) |
|
| 16/06/2002 | New associative arrays in PL/SQL |
|
| 13/05/2002 | A warning about the 'compatible' parameter when upgrading |
|
| 24/04/2002 | A well-publicised security hole in 9i |
|
| 06/04/2002 | TO_LOB looks great, but watch out for the space it consumes |
|
| 11/02/2002 | An SPFILE 'gotcha' that can catch you if you're upgrading from 8i |
|
| 02/02/2002 | A new event that comes in handy when re-deploying code |
|
| 27/01/2002 | A possible issue with downloading patch 9.0.1.2 |
|
| 14/01/2002 | Simpler way of issuing bulk DDL in parallel |
|
| 14/12/2001 | A new feature (and a warning about it) in DBMS_STATS |
|
| 14/11/2001 | Some important notes on the FIRST_ROWS optimizer mode |
|
| 11/11/2001 | A nice addition for more control over redo log switching |
|
| 17/10/2001 | Be careful when altering the 'java_pool_size' parameter in 9i |
|
| 01/10/2001 | A new function to get histogram style information directly from SQL |
|
| 19/08/2001 | PL/SQL in 9i supports the CASE statements |
|
| 10/08/2001 | Now you can have a timeout when trying to lock rows in a table |
|
| 09/08/2001 | A function to return the first non-null in a list |
|
| 06/08/2001 | Checking indexes? You don't need to worry about locks anymore |
|
| 28/07/2001 | You can specify the order of entries under each "node" of a hierarchical query |
|
| 28/07/2001 | A function to return null if its two arguments are equal |
|
| 28/07/2001 | Using defaults for inserting a row into a table |
|
| 23/07/2001 | A nifty function thats actually already in most versions |
|
| 23/07/2001 | See an entire tree in a hierarchical query |