Re: Temporary table use and the redo log
From: Randolf Geist <mahrah_at_web.de>
Date: Sun, 13 Sep 2009 02:33:49 -0700 (PDT)
Message-ID: <62314fc4-8800-40e8-888a-78d8aa4fa7bb_at_x37g2000yqj.googlegroups.com>
On Sep 11, 7:05 pm, "Jonathan Lewis" <jonat..._at_jlcomp.demon.co.uk> wrote:
> But there are various bugs in different versions of Oracle that
> cause problems. Most versions of 9i, for example, lose the
> bulk processing optimisation of insert as select;
Date: Sun, 13 Sep 2009 02:33:49 -0700 (PDT)
Message-ID: <62314fc4-8800-40e8-888a-78d8aa4fa7bb_at_x37g2000yqj.googlegroups.com>
On Sep 11, 7:05 pm, "Jonathan Lewis" <jonat..._at_jlcomp.demon.co.uk> wrote:
> But there are various bugs in different versions of Oracle that
> cause problems. Most versions of 9i, for example, lose the
> bulk processing optimisation of insert as select;
Jonathan,
interesting, can you elaborate a bit about the "bulk processing optimisation" bug in 9i? Is this specific to Global Temporary Tables? What does "lose" the bulk processing optimisation mean? Fall back to conventional DML or reduced performance comparable to single row/PL/ SQL bulk processing, similar to the DML error logging effect?
Regards,
Randolf
Oracle related stuff blog:
http://oracle-randolf.blogspot.com/
SQLTools++ for Oracle (Open source Oracle GUI for Windows):
http://www.sqltools-plusplus.org:7676/
http://sourceforge.net/projects/sqlt-pp/
Received on Sun Sep 13 2009 - 04:33:49 CDT