Re: No more captured sql in v§sql_monitor

Hi Andy

All checked.
Upgrade done by the customer, all components are fine, no invalid objects.

Cheers
Jko

On 27 January 2020 13:23:29 Andy Sayer <andysayer_at_gmail.com> wrote:
> 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