Re: sql monitor
Date: Mon, 10 May 2021 21:36:18 +0100
Message-ID: <CAGtsp8kLp9gBP1+M=x2LLni=Zpo0c7AS5mFgyAOQBs57jNdoHw_at_mail.gmail.com>
Two possibilities, though neither seems likely.
Regards
On Fri, 7 May 2021 at 17:50, Henry Poras <henry.poras_at_gmail.com> wrote:
> I think I'm missing something silly here, but I don't know what.
Jonathan Lewis
>
> I'm having an issue with getting a sql_monitor report and I'm running
> (well, ran) out of ideas on what to try next. I have a long running query
> (~2 hours on 12.1.0.2) for which I am trying to get a report using
> dbms_sqltune.report_sql_monitor. The result returned is always empty. So I
> tried:
> - setting _sqlmon_max_planlines to 1000 (execution plan is ~600 lines
> using display_cursor('adaptive'))
> - checked statistics_level which is correct. It is TYPICAL
> - control_management_pack_access is DIAGNOSTIC+TUNING (also correct)
> I thought it might be aging out of memory since it ran long, but running
> the report and looking in gv$sql_monitor after 2, and 10-15 minutes still
> showed nothing. Adding a MONITOR hint to the CTE and body of the sql didn't
> help. Neither did running an ALTER SYSTEM SET EVENTS 'sql_monitor [sql:...]
> force=true'.
> I can't figure out why I am getting nothing. Anybody have any ideas?
>
> Thanks.
> Henry
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon May 10 2021 - 22:36:18 CEST