SQL Performance (MOSC)

MOSC Banner

11GR2: EM performance

edited Dec 25, 2016 4:25PM in SQL Performance (MOSC) 5 commentsAnswered

Hi,

We have 11GR2 database installed.   Also, we have  EM 12c cloud control installed.     I am looking at one of the database AWR report and found the following jobs are consuming lot of resource.

My question is as follows

1)  is the above jobs  comming from  EM cloud control 12c    or from  db control

2) If db control is enabled , how to disable is without affecting EM cloud control.

I want to avoid unnecessary db overheads

Here is the output of dba_jobs.

SQL> select what from dba_jobs;

WHAT

--------------------------------------------------------------------------------

EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS();

Please advise

Thanks

Ram

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