Re: Performance decrease while deletin a table

From: Kevin A Lewis <KevinALewis_at_Hotmail.com>
Date: Thu, 29 Apr 1999 12:59:45 +0100
Message-ID: <wMXV2.3252$Ed5.49@news-reader.bt.net>

It take it that the key differenciator is the delete of the whole table content prior to the load. If this is not done the load performs well.

If this is the case then I can only asume oracle is having problems navigating index and data where space is allocated and there is no content. I have had my suspicions in this are before.

Could you extract the data, then truncate the table, leaving a reset data table and indexes; then if the load is unsuccessful truncate again and reload the first extract.

Also what did you see as the datafile io situation.

Regards

--
Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)

                        <Kevin.Lewis_at_BOCMPAULS.co.uk>

The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. Received on Thu Apr 29 1999 - 06:59:45 CDT