Managing Databases using Enterprise Manager (MOSC)

MOSC Banner

DBSNMP sessions use too much CPU

edited Jul 20, 2011 2:17AM in Managing Databases using Enterprise Manager (MOSC) 10 commentsAnswered
 Dear all,
I have installed Oracle Database 11g 11.2.0.2.0. Everything works fine, the database works smoothly for two months without any problem. Anyhow, I have configured Oracle Data Guard using Oracle Data Guard Broker. The configuration went successful and the Redo is shipping just great.

The problem now is with the DBSNMP user. Once we log on to the DB Control, the DBSNMP user started a session with the following SQL statement:

/* OracleOEM */

SELECT 'proxy_account',

        c             ,

        'NA'

FROM

        (

                SELECT DISTINCT c

                FROM

                        (

                                SELECT   NULL  p,

                                        name c

                                FROM    system_privilege_map

                                WHERE   name <> 'CREATE SESSION'

                                UNION

                                SELECT granted_role p, grantee c

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center