AUTO ALLOCATE PERFORMANCE

From: Wolfson Larry - lwolfs <lawrence.wolfson_at_acxiom.com>
Date: Wed, 28 Mar 2007 11:26:20 -0500
Message-ID: <B39B7B7D8C8CEA419D0ED45FD7FA4C53020DC392@CWYMSX06.Corp.Acxiom.net>

Hey guys, I've got a vendor claiming his batch load runs in 70 minutes instead of 90 on his test system when he switched to AUTOALLOCATE.

Can't say I've seen a lot of info on performance improvements with AUTOALLOCATE. Anybody have a take on this? He hasn't given me his code yet. All I've seen is FTS because all his SELECTs use UPPER everywhere and never use any indexes. His biggest table has 26 of them and I'm gonna see if he really uses any. Sorry nothing to do with AA question.

TIA
Larry

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.

If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.

If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.

Thank You.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 28 2007 - 11:26:20 CDT