We have been tracing sessions to try to drill down to the cause of sluggish insert transactions. We performed a process to insert 600+K transactions logged into the application as the schema owner. Once completed, we performed the same insert test logged into the application via the use of a proxy user. The process took 30 times longer.
In review of the trace files using TKPROF (sys=yes, aggregate = no), we saw the execution of page after page of system queries with the proxy user session before getting to the actual insert statement.
Has anyone experienced this kind of behavior using proxy users? And, if so, did you find any useful articles describing this and any solutions?
I am searching all of the Oracle resources, but have not been able to come up with anything useful.
Thanks for any help you can provide.
In review of the trace files using TKPROF (sys=yes, aggregate = no), we saw the execution of page after page of system queries with the proxy user session before getting to the actual insert statement.
Has anyone experienced this kind of behavior using proxy users? And, if so, did you find any useful articles describing this and any solutions?
I am searching all of the Oracle resources, but have not been able to come up with anything useful.
Thanks for any help you can provide.
