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?

autonomous txns still run synchronously, they are just a new transaction. You would need to look at using dbms_job and possibly some sort of queueing mechanism to start spawning "background" work

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"