Re: Spinning package call

Posted by ErmanArslansOracleBlog on Jun 25, 2018; 7:20am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Spinning-package-call-tp6218p6255.html

Still spinning with what wait?
What is the wait event of the spinning process? (it should not be Resmgr:Cpu Quantum anymore)
Probably your code goes into a heavy loop..
Are there lots of elements in all_list_a and all_list_b?
If these are larger sets, why dont you use sql operators instead?

Here is what Tom Kyte says about it ->

Reference:

https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:2314694900346831630