BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;
Dear All,
I am using :Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
I found that in my database
BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, ); END;
is taking max CPU utilization.
I am using EM.
Please suggest what to do?
SQL> select ss.username, se.SID, VALUE/100 cpu_usage_seconds
from v$session ss, v$sesstat se, v$statname sn
where se.STATISTIC# = sn.STATISTIC# and NAME like '%CPU used by this session%'
and se.SID = ss.SID and ss.status='ACTIVE' and ss.username is not null
I am using :Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
I found that in my database
BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, ); END;
is taking max CPU utilization.
I am using EM.
Please suggest what to do?
SQL> select ss.username, se.SID, VALUE/100 cpu_usage_seconds
from v$session ss, v$sesstat se, v$statname sn
where se.STATISTIC# = sn.STATISTIC# and NAME like '%CPU used by this session%'
and se.SID = ss.SID and ss.status='ACTIVE' and ss.username is not null
0