Re: No more captured sql in v§sql_monitor

I’m afraid it works on my machine just fine. Make sure you’ve got the control_management_pack_access parameter set to diagnostic+tuning.

Have you tested a query with /*+monitor*/ hint to force capture (as opposed to finding a query that takes >5 seconds or uses parallelism).

How did you do the upgrade?

Thanks,
Andrew

On Mon, 27 Jan 2020 at 10:55, Google <jacques.kostic_at_gmail.com> wrote:

> Hi there
>
> How comes after an upgrade from 12.1 to 12.2, there is no more queries
> captured?
>
> Have check many options including monitor hints
>
> Thanks for your inputs
> Cheers
> Jko
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l