Database Administration (MOSC)

MOSC Banner

report sql worked 90 hours, is it automatic report in sql server?

edited Aug 23, 2016 5:00AM in Database Administration (MOSC) 3 commentsAnswered

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

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