sql monitor
From: Henry Poras <henry.poras_at_gmail.com>
Date: Fri, 7 May 2021 12:50:08 -0400
Message-ID: <CAK5zhL+AT9FTvFePfXgKokoHVLZYQL7Fv=ejotUG23GFdFK8Hg_at_mail.gmail.com>
I think I'm missing something silly here, but I don't know what.
Date: Fri, 7 May 2021 12:50:08 -0400
Message-ID: <CAK5zhL+AT9FTvFePfXgKokoHVLZYQL7Fv=ejotUG23GFdFK8Hg_at_mail.gmail.com>
I think I'm missing something silly here, but I don't know what.
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:...]
Thanks.
Henry
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 07 2021 - 18:50:08 CEST