Re: Large table query with cpu throttling

Ooopss....I think I got the problem solved....a simple no-brainer solution. Thank you very much everyone. (Thank you for the dbms_lock.sleep(0.1)) tip, it was useful :-)).

> >
> > loop
> > bulk collect from your_table to arrary;
> > exit when no rows found exit loop;
> > do something with your fetched array;
> > sleep for a short time; (dbms_lock.sleep(0.1));
> > end loop;
>

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