High CPU Usage When OEM Grid Control Runs A Query On DBA_OBJECTS (Doc ID 1061710.1)

Last updated on NOVEMBER 04, 2015

Applies to:

Enterprise Manager for Oracle Database - Version 10.2.0.1 to 11.1.0.7.0 [Release 10.2 to 11.1]
Information in this document applies to any platform.
Checked for relevance on 07-Jan-2013

Symptoms

A database which is being monitored using OEM Grid Control 10.2.0.5 is extremely slow. One particular query is using excessive CPU . The query in question is as follows:

SELECT P.OBJECT_NAME, O.OBJECT_TYPE, P.OBJECT_OWNER, P.POLICY_NAME, P.POLICY_GROUP, P.ENABLE
FROM DBA_POLICIES P, DBA_OBJECTS O
WHERE P.OBJECT_NAME=O.OBJECT_NAME

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms