Anyone use autonomous transaction to improve performance?

Ive used it to manage transactions that I dont want to wait for. Im curious if the following would show any improvement. We have a Solaris server that has several process on a Network Appliance Hard disk array.

We do not have the parrallel query option. I have to perform a large number of inserts and upates which is running very slow. Im considering using the Autonomous_transaction to concurrently execute them at one time.

has anyone tried this? Did you see any performance improvements? Does Oracle do a good job load balancing the different threads? Received on Thu May 01 2003 - 14:50:44 CDT