report sql worked 90 hours, is it automatic report in sql server?
hello. I see 2 sql run 90 hours and 67 hours. To stop them, I stopped oracle and started instances again because I couldn't see any v$session queries. That sql are;
BEGIN sys.dbms_auto_report_internal.i_save_report (:rep_ref, :snap_id, :pr_class, :rep_id, :suc); END; SELECT XMLTYPE(DBMS_REPORT.GET_REPORT_WITH_SUMMARY(:B1 )) FROM DUAL
What is it? Is it automatic report sql? It worked 90 hours, how can i disable it? I can't find any clue who work that sql. I use Oracle 12c RAC clusters.
Thanks
Ahmet Melih