Oracle-L: by thread

How to optimize this SQL listing TOP SQL consuming DB Time (%) similar in Top Activity in Oracle EMCC continuously? Quanwen Zhao (Mon Jul 11 2022 - 09:46:59 CEST)
DML blocking Pap (Mon Jul 11 2022 - 11:18:01 CEST)
- RE: DML blocking Noveljic Nenad (Mon Jul 11 2022 - 11:28:52 CEST)
  - Re: DML blocking Pap (Mon Jul 11 2022 - 11:45:23 CEST)
- Re: DML blocking Jonathan Lewis (Mon Jul 11 2022 - 12:03:18 CEST)
  - Re: DML blocking Pap (Mon Jul 11 2022 - 12:26:51 CEST)
    - RE: DML blocking Mark W. Farnham (Mon Jul 11 2022 - 12:51:11 CEST)
      - RE: DML blocking Mark W. Farnham (Mon Jul 11 2022 - 14:20:49 CEST)
        
        Re: DML blocking Pap (Mon Jul 11 2022 - 21:49:38 CEST)
- Re: DML blocking Mladen Gogala (Mon Jul 11 2022 - 14:28:57 CEST)