10g new feature articles
The two major releases of 10g (re-badged as Oracle Database 10g) have provided many new features for DBAs and developers alike. Despite many features aimed at automation, there's still plenty for developers to play with and you'll find some of these described in the articles below.
- 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 - Dml error logging in oracle 10g release 2
A new error logging mechanism for bulk DML statements. 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 - Enhancements to dbms_output in 10g release 2
Oracle finally "fixes" DBMS_OUTPUT. August 2005 - Autotrace enhancement in 10g release 2
Autotrace now uses DBMS_XPLAN to output its explain plans. August 2005 - Flashback version query in oracle 10g
We can now view the evolution of our data with flashback version query. 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 - Sql tuning advisor in 10g
Oracle now offers SQL tuning recommendations. November 2004 - Dual optimisation in 10g
The dual table gets a performance makeover. November 2004 - Tracking exceptions in oracle 10g
Exceptions can now be traced back to their source in 10g. June 2004 - Flashback table in 10g
Oracle extends flashback technology to restore dropped tables. June 2004 - Partition outer join in oracle 10g
A new mechanism to populate the gaps in sparse data. June 2004 - Quoting string literals in 10g
Oracle 10g provides a quoting mechanism for strings that include single-quotes. June 2004 - Merge enhancements in 10g
Enhancements to the MERGE statement in 10g provide much greater flexibility. June 2004 - Native dynamic sql optimisation in 10g
Native dynamic SQL gets an optimisation to match DBMS_SQL for efficiency. June 2004 - Forall enhancements in 10g
An overview of enhancements to FORALL bulk-binding. 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 - Exception enhancements in 10g
A few small enhancements to exception handling/error messages. 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