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
--
//www.freelists.org/webpage/oracle-l