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


Other related posts: