tpt-oracle icon indicating copy to clipboard operation
tpt-oracle copied to clipboard

Published 20 hours ago • verified publisher icon tanelpoder

Error while running snapper

Open gsirvas opened this issue 6 years ago • 4 comments

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

gsirvas avatar Apr 02 '19 23:04 gsirvas

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.

tanelpoder avatar Apr 03 '19 03:04 tanelpoder

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

gsirvas avatar Apr 04 '19 23:04 gsirvas

Thanks, would be good to know the outcome.

tanelpoder avatar Apr 07 '19 04:04 tanelpoder

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

gsirvas avatar Apr 25 '19 17:04 gsirvas