Search

OakieTags

more tags

Who's online

There are currently 0 users and 38 guests online.

Recent comments

Affiliations

Home

10g Articles

Native dynamic sql optimisation in 10g

Submitted by Adrian Billington on Fri, 2008-03-07 08:59

Native dynamic SQL gets an optimisation to match DBMS_SQL for efficiency. June 2004

Flashback version query in oracle 10g

Submitted by Adrian Billington on Fri, 2008-03-07 08:59

We can now view the evolution of our data with flashback version query. August 2005

Exception enhancements in 10g

Submitted by Adrian Billington on Tue, 2008-01-15 19:45

A few small enhancements to exception handling/error messages. June 2004

Autotrace enhancement in 10g release 2

Submitted by Adrian Billington on Thu, 2007-10-11 18:22

Autotrace now uses DBMS_XPLAN to output its explain plans. August 2005

Dml error logging in oracle 10g release 2

Submitted by Adrian Billington on Wed, 2007-10-10 19:57

A new error logging mechanism for bulk DML statements. August 2005

Dml error logging performance in 10g release 2

Submitted by Adrian Billington on Sat, 2007-09-15 22:28

Performance characteristics of DML error logging. August 2005

Merge enhancements in 10g

Submitted by Adrian Billington on Fri, 2007-04-13 17:42

Enhancements to the MERGE statement in 10g provide much greater flexibility. June 2004

Enhancements to dbms_output in 10g release 2

Submitted by Adrian Billington on Sun, 2007-04-01 20:41

Oracle finally "fixes" DBMS_OUTPUT. August 2005

Flashback restore points in oracle 10g release 2

Submitted by Adrian Billington on Sun, 2007-04-01 20:34

Restore points enable us to capture a point in time for flashback operations. August 2005

Flashback table in 10g

Submitted by Adrian Billington on Fri, 2007-03-30 07:15

Oracle extends flashback technology to restore dropped tables. June 2004