RE: Simplest way to create/use PLSQL collections
- From: "Post, Ethan" <Ethan.Post@xxxxxx>
- To: <tim@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 19 May 2005 10:30:24 -0500
Bug 2874489 Excessive REDO generated for INSERT as SELECT into GLOBAL
TEMPORARY TABLES
Using 'insert as select' to insert into a global=20
temporary table can generate far more redo than=20
the same insert into a permanent table.
Updates and deletes are not affected, only multirow inserts.
Affects:
Product (Component) Oracle Server (Rdbms)=20
Range of versions believed to be affected Versions < 10.1.0.2 =20
Versions confirmed as being affected 9.2.0.4=20
=20
Platforms affected Generic (all / most platforms affected)=20
Fixed:
This issue is fixed in 9.2.0.5 (Server Patch Set)=20
10.1.0.2=20
=20
--
//www.freelists.org/webpage/oracle-l
Other related posts:
