If you are running OEM Grid Control 11g with the SOA Management Pack, be careful as the agent performs a considerably high number of SELECT COUNT(*) statements against the MDS. In fact, it's way much, with the following queries being executed over 5000 times per hour!
This has resulted in some minor overhead on our database. You have been warned!
Applicable Versions:
SELECT /*+ INDEX(MEDIATOR_INSTANCE MEDIATOR_INSTANCE_INDEX6) */ COUNT(*)
FROM MEDIATOR_INSTANCE
WHERE COMPONENT_NAME like :1
SELECT /*+ INDEX(MEDIATOR_INSTANCE MEDIATOR_INSTANCE_INDEX6) */ COUNT(*)
FROM MEDIATOR_INSTANCE
WHERE COMPONENT_NAME like :1 AND CASE_NUM > 0
This has resulted in some minor overhead on our database. You have been warned!
Applicable Versions:
- Oracle SOA Suite 11g
- OEM Grid Control 11g (with SOA Management Pack)
No comments:
Post a Comment