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,
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
huge waits on Foreground Events:
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,
FROM DUAL CONNECT BY ROWNUM <= :v1
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
Pawel
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 14 2016 - 11:14:44 CEST