Re: Delete with Huge table

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 25 Nov 1999 22:54:28 -0000
Message-ID: <943570566.25346.0.nnrp-09.9e984b29@news.demon.co.uk>

There is an article on my website that may help about using rowid ranging to update sections of a table. The same principle can be applied to deletes.

developer tricks -> big updates

which can be used in conjunciton with

developer tricks -> concurrency

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Eric DUCHET wrote in message <6Ia%3.1812$N45.9344122_at_nnrp1.proxad.net>...
>Hi,
>
>I want to know if Oracle works fine for deleting part of huge table (about
>50 000 000 rows).
>My system is AIX 4.2
>Oracle v7.3.4
>No archive log.
>
>My performance on my system for deleting 1 000 000 rows is very bad.
>How can I improve that ?
>
>(I already have dropped all my indexes)
>
>Can I lauch a parallel query ?
>
>Thanx a lot.
>
>
>
>
>
>
Received on Thu Nov 25 1999 - 16:54:28 CST