Re: Cursor without a where clause...

Have a look at my web-site for the article on handling a table by rowid ranges.

    Developer Tricks -> Big Update

This may help. It is a version 7 example, but converting to version 8 is not difficult.

--

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

justvrk wrote in message <8djsrd$upm$1_at_nnrp1.deja.com>...


>Hello:

>    I am stuck up with a performance problem involving a cursor.

>I am moving data from a huge table ( rows > 300,000,000 ) with business

>validation done through a set of plsql procedures. Till date I am

>unable to complete the full move in one step. I am opening a cursor on

>the huge table without any WHERE clause, and because of which things

>are slowing down.

>    I have tested with small chuck of data in steps and the completion

>time is rising exponentially. like 5 mins for the first 100000 recs, 15

>mins for first 200000 recs and so on.

>    Can someone suggest me any hints to speed up this blind cursor

>method ? Also I am thinking about partitioning the table but I am not

>sure whether this will be of any help.