Binding in-lists in 10g

Uncategorized
| Sep 11, 2008
Alternative IN-list binding in 10g using the new MEMBER OF collection condition. June 2004 (updated September 2008)

Partition-wise dependencies in 10g release 2

Uncategorized
| Aug 20, 2008
Modify partitions without invalidating dependant objects. October 2007 (updated August 2008)

The collect function in 10g

Uncategorized
| Jul 11, 2008
Using the new 10g COLLECT group function, including string aggregation. June 2004 (updated July 2008)

Pl/sql optimisation in 10g

Uncategorized
| Mar 5, 2008
Oracle 10g's compiler optimisation for faster PL/SQL, with a new section on optimisation bugs. November 2004 (updated March 2008)

Sql plan enhancements in 10g

Uncategorized
| Nov 5, 2007
New plan features in 10g make SQL performance investigations much more simple. December 2004 (updated November 2007)

Dml error logging performance in 10g release 2

Uncategorized
| Aug 15, 2005
Performance characteristics of DML error logging. August 2005

Autotrace enhancement in 10g release 2

Uncategorized
| Aug 11, 2005
Autotrace now uses DBMS_XPLAN to output its explain plans. August 2005

Dml error logging in oracle 10g release 2

Uncategorized
| Aug 10, 2005
A new error logging mechanism for bulk DML statements. August 2005

Flashback version query in oracle 10g

Uncategorized
| Aug 7, 2005
We can now view the evolution of our data with flashback version query. August 2005

Enhancements to dbms_output in 10g release 2

Uncategorized
| Aug 1, 2005
Oracle finally "fixes" DBMS_OUTPUT. August 2005

Flashback restore points in oracle 10g release 2

Uncategorized
| Aug 1, 2005
Restore points enable us to capture a point in time for flashback operations. August 2005

Array-based advanced queuing in 10g

Uncategorized
| Jul 16, 2005
Oracle 10g enables us to enqueue and dequeue in bulk. July 2005

Unloading data using external tables in 10g

Uncategorized
| May 24, 2005
External tables can write as well as read in 10g. May 2005

Dual optimisation in 10g

Uncategorized
| Nov 25, 2004
The dual table gets a performance makeover. November 2004

Sql tuning advisor in 10g

Uncategorized
| Nov 15, 2004
Oracle now offers SQL tuning recommendations. November 2004

Flashback table in 10g

Uncategorized
| Jun 30, 2004
Oracle extends flashback technology to restore dropped tables. June 2004

Measuring cpu time in 10g

Uncategorized
| Jun 26, 2004
An addition to DBMS_UTILITY now enables us to measure CPU time easily. June 2004

Aggregating data with the returning clause

Uncategorized
| Jun 26, 2004
In 10g, data returned by the RETURNING clause can be aggregated. June 2004

Collection extensions in 10g

Uncategorized
| Jun 22, 2004
A brief overview of the new collection operators, functions and conditions in 10g. June 2004

Regular expressions in 10g

Uncategorized
| Jun 22, 2004
Oracle finally provides support for regular expressions. June 2004