Home -> Mailing Lists -> Oracle-L -> enq: SV - contention on RAC EXADATA

enq: SV - contention on RAC EXADATA

From: Pawel Smolarz <pawel.smolarz_at_nordea.com>
Date: Tue, 14 Jun 2016 11:14:44 +0200
Message-ID: <20160614111444.03cb328b_at_nordea.com> 





Hi,



Hi,



On Exadata RAC database 12.1.0.2.0  we have problems with queries:



SELECT schema.sequence_name.NEXTVAL


FROM DUAL CONNECT BY ROWNUM <= :v1



huge waits on Foreground Events:


Event Waits Total Wait Time (sec) Wait Avg(ms) % DB time Wait Class
DB CPU 2.1M 37.5



resmgr:cpu quantum 1.1E+08 1.2M 11.21 21.6 Scheduler
enq: SV - contention 83,224,234 1.1M 12.91 18.8 Other



I know that is BUG but fix has been included in 12.1.0.1



Anyone has a experience with this type of event?
A lot of CPU has been consume by these sessions .



Regards,


Pawel

--
http://www.freelists.org/webpage/oracle-l


Received on Tue Jun 14 2016 - 11:14:44 CEST












Original text of this message