Re: Spinning package call

Posted by ErmanArslansOracleBlog on Jun 21, 2018; 12:35pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Spinning-package-call-tp6218p6225.html

Hi Laurel,

1)It may be a bug. did you check this note->Large Waits With The Wait Event "Resmgr:Cpu Quantum" (Doc ID 806893.1)

2)May be a resource manager thing as well.. Did you enable resource manager? Is everything ok with it? Did you verify the resource manager plan?

3)Any other sessions waiting on this event? Did you see on top 5 in AWR?

4)Does the package use parallel execution? Do you have enough parallel slaves at the time of executing this?