Error while running snapper

[gsirvas]

Hi Tanel,
I wanted to use you scripts to troubleshoot a performance problem. I downloaded and i ran the following against an 12.2 RAC instance, and i got the errors on the attached file.

@snapper ash,stats 5 1 sid=758@

tpt_error.txt

Did I miss anything or this is expected behaviour

[tanelpoder]

This is due to an Oracle V$SESSION issue ... haven't fully figured out where exactly it happens. Is this DB a Multitenant-enabled DB? If yes, can you run a snapper test in the CDB$ROOT container (and not under a PDB). For some reason this problem shows up only under a PDB.

[gsirvas]

Thank you Tanel, I'll test it and let you know.

[tanelpoder]

Thanks, would be good to know the outcome.

[gsirvas]

I tested again and running at the CDB level as you suggested ran fine.