RE: EM 12c - What process/job insert a lots of record into EM_TRACE_DEBUG

If memory serves me correctly, repvfy has a way to debug tracing and to stop it. Have you tried using that?  

Pete

Pete Sharman
Database Architect, DBaaS / DBLM
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA

Phone: HYPERLINK "tel:+61262924095"+61262924095 | | Mobile: +61414443449 Email: HYPERLINK "mailto:pete.sharman_at_oracle.com"pete.sharman_at_oracle.com Twitter: @SharmanPete LinkedIn: au.linkedin.com/in/petesharman Website: petewhodidnottweet.com

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook  

"Oh no, it's not, it's much harder than that!"

Bruce Pihlamae, long term Oracle DBA

From: Le, Binh T. [mailto:Binh.Le_at_lfg.com] Sent: Monday, July 25, 2016 11:25 PM
To: oracle-l_at_freelists.org
Subject: EM 12c - What process/job insert a lots of record into EM_TRACE_DEBUG  

Dear EM 12c Experts,  

I'm running into a weird issue with my EM 12c (12.1.0.5)  

Since the upgrade (from 12.1.0.4 to 12.1.0.5) I ran into several issues and one of them is I can't create patch plan for the agent.  

Oracle SR help me id the issue . somehow there was the issue with EMD_MAINTENANCE jobs.  

They told me do  

ALTER SYSTEM SET job_queue_processes=0 SCOPE=BOTH;

exec emd_maintenance.remove_em_dbms_jobs;

ALTER SYSTEM SET job_queue_processes=1000 SCOPE=BOTH;

exec emd_maintenance.submit_em_dbms_jobs;    

Since then I'm able to create and patch the agent . however .  

Some job has been running none stop and insert millions of records into sysman.em_trace_debug .  

DECLARE         job BINARY_INTEGER := :job;

        next_date TIMESTAMP

WITH TIME ZONE := :mydate;

broken BOOLEAN := FALSE;

job_name VARCHAR2(30) := :job_name;

job_subname VARCHAR2(30) := :job_subname;

job_owner VARCHAR2(30) := :job_owner;

job_start TIMESTAMP

WITH TIME ZONE := :job_start;

job_scheduled_start TIMESTAMP

WITH TIME ZONE := :job_scheduled_start;

window_start TIMESTAMP

WITH TIME ZONE := :window_start;

window_end TIMESTAMP

WITH TIME ZONE := :window_end;

chain_id VARCHAR2(14) := :chainid;

credential_owner VARCHAR2(30) := :credown;

credential_name VARCHAR2(30) := :crednam;

destination_owner VARCHAR2(30) := :destown;

destination_name VARCHAR2(30) := :destnam;

job_dest_id VARCHAR2(14) := :jdestid;

log_id NUMBER := :log_id;

BEGIN         EM_TASK.WORKER(17);         :mydate := next_date;

        IF broken THEN

:b := 1;

        ELSE
:b := 0;

        END IF; END;   INSERT INTO EM_TRACE_DEBUG         (

                CONTEXT_TYPE_ID   ,

                CONTEXT_IDENTIFIER,

                MODULE            ,

                OMS_HOST          ,

                OBJ_GUID          ,

                OBJ_NUM_DATA      ,

                OBJ_STR_DATA      ,

                LOG_TIMESTAMP     ,

                LOG_LEVEL         ,

                LOG_SUB_LEVEL     ,

                LOG_VISIBILITY    ,

                LOG_MESSAGE       ,

                LOG_MESSAGE_ID    ,

                LOG_MESSAGE_BUNDLE,

                LOG_MESSAGE_PARAMS

        )

        VALUES

        (



                :B15 ,





                :B14 ,





                :B13 ,





                :B12 ,





                :B11 ,





                :B10 ,





                :B9  ,





                :B8  ,





                :B7  ,





                :B6  ,





                :B5  ,





                :B4  ,





                :B3  ,





                :B2  ,





                :B1


        )

 

Anyone know how I can stop this .  

Thanks,

Binh    

Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**

--
http://www.freelists.org/webpage/oracle-l