Re: Anyone use autonomous transaction to improve performance?

Ryan Gaffuri wrote:

> 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?

Never tried it but I'd be surprised if it helped.

If you have slow inserts and updates I'd look into 'Why?'.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)