>The places I am doing sqlexec() are where I was updating various views. The views I had setup to updating based on pk only and had a batch count. When I was done all the changes I had a routine that ran through all the tables that were being updated which started a sql transaction, did the table updates and then did sqlcommits.
>
>I thought commands sent through sqlexec would be quite efficient since they are bring sent directly to oracle.
>
>Could the large number of sqlexec commands being run be the problem here?

Not necessarily. I notice you're running several SELECT commands inside a scan. You may be better off doing the selects before the scan and using seek inside the scan to find related/lookup info.

SNIP!