[HELP]: Large cursor updates

I have a cursor that scans a table of approximatly 10,000 records and does various inserts to a table based on what it finds. When the same cursor is run on a select statement that finds a smaller selection of records, say 100-1,000, everything seems to complete quickly and properly. However, cursors that have a larger found set appear to hang.

What can be causing this? What should I be looking for? What is causing the cursor the hang or appear not to complete? Are there some dba init parameters I should be setting to optimize the cursor?

-- 
Neil Greene
benchMark Developments, Inc. [NeXT VAR]
2040 Regency Road, Suite C Lexington, KY 40503
Phone: 606-231-6599 / Fax: 606-254-4864