search

tanelpoder / tpt-oracle

Tanel Poder's Performance & Troubleshooting Tools for Oracle Databases
https://tanelpoder.com
Other
657 stars 312 forks source link

Error while running snapper #4

Open gsirvas opened 5 years ago

gsirvas commented 5 years ago

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 commented 5 years ago

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 commented 5 years ago

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

tanelpoder commented 5 years ago

Thanks, would be good to know the outcome.

gsirvas commented 5 years ago

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