Binding in-lists in 10g
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
Modify partitions without invalidating dependant objects. October 2007 (updated August 2008)
The collect function in 10g
Using the new 10g COLLECT group function, including string aggregation. June 2004 (updated July 2008)
Pl/sql optimisation in 10g
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
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
Performance characteristics of DML error logging. August 2005
Autotrace enhancement in 10g release 2
Autotrace now uses DBMS_XPLAN to output its explain plans. August 2005
Dml error logging in oracle 10g release 2
A new error logging mechanism for bulk DML statements. August 2005
Flashback version query in oracle 10g
We can now view the evolution of our data with flashback version query. August 2005
Enhancements to dbms_output in 10g release 2
Oracle finally "fixes" DBMS_OUTPUT. August 2005
Flashback restore points in oracle 10g release 2
Restore points enable us to capture a point in time for flashback operations. August 2005
Array-based advanced queuing in 10g
Oracle 10g enables us to enqueue and dequeue in bulk. July 2005
Unloading data using external tables in 10g
External tables can write as well as read in 10g. May 2005
Dual optimisation in 10g
The dual table gets a performance makeover. November 2004
Sql tuning advisor in 10g
Oracle now offers SQL tuning recommendations. November 2004
Flashback table in 10g
Oracle extends flashback technology to restore dropped tables. June 2004
Measuring cpu time in 10g
An addition to DBMS_UTILITY now enables us to measure CPU time easily. June 2004
Aggregating data with the returning clause
In 10g, data returned by the RETURNING clause can be aggregated. June 2004
Collection extensions in 10g
A brief overview of the new collection operators, functions and conditions in 10g. June 2004
Regular expressions in 10g
Oracle finally provides support for regular expressions. June 2004
RSS