Latchprof - ORA-65011: Pluggable database does not exist.- 12.2.0.1 PSU Jan 2019

[jacobvz-1]

[oracle@cltsadm01vm01 tpt-oracle-master]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Jun 3 13:35:47 2020

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Connected to:
Oracle Database 12c EE Extreme Perf Release 12.2.0.1.0 - 64bit Production

SQL> alter session set container=PRD605
2 /

Session altered.

SQL> @latchprof sid,name % % 1000000

-- LatchProf 2.10 by Tanel Poder ( https://blog.tanelpoder.com )
old 5: &_lhp_what
new 5: sid,name
old 8: , COUNT() / &_lhp_samples total_samples_pct
new 8: , COUNT() / 1000000 total_samples_pct
old 10: (SELECT /*+ NO_MERGE / 1 FROM DUAL CONNECT BY LEVEL <= &_lhp_samples) s,
new 10: (SELECT /+ NO_MERGE */ 1 FROM DUAL CONNECT BY LEVEL <= 1000000) s,
old 20: l.sid LIKE '&_lhp_sid'
new 20: l.sid LIKE '%'
old 21: AND (LOWER(l.name) LIKE LOWER('%&_lhp_name%') OR LOWER(RAWTOHEX(l.laddr)) LIKE LOWER('%&_lhp_name%'))
new 21: AND (LOWER(l.name) LIKE LOWER('%%%') OR LOWER(RAWTOHEX(l.laddr)) LIKE LOWER('%%%'))
old 24: &_lhp_what
new 24: sid,name
old 30: &_lhp_what
new 30: sid,name
old 34: , s.total_samples / &_lhp_samples * 100 latchprof_pct_total_samples
new 34: , s.total_samples / 1000000 * 100 latchprof_pct_total_samples
old 35: , (t2.hsecs - t1.hsecs) * 10 * s.total_samples / &_lhp_samples latchprof_total_ms
new 35: , (t2.hsecs - t1.hsecs) * 10 * s.total_samples / 1000000 latchprof_total_ms
old 37: , (t2.hsecs - t1.hsecs) * 10 * s.total_samples / dist_samples / &_lhp_samples latchprof_avg_ms
new 37: , (t2.hsecs - t1.hsecs) * 10 * s.total_samples / dist_samples / 1000000 latchprof_avg_ms
t1,
*
ERROR at line 39:
ORA-65011: Pluggable database does not exist.

SQL> exit
Disconnected from Oracle Database 12c EE Extreme Perf Release 12.2.0.1.0 - 64bit Production
[oracle@cltsadm01vm01 tpt-oracle-master]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Jun 3 13:40:18 2020

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Connected to:
Oracle Database 12c EE Extreme Perf Release 12.2.0.1.0 - 64bit Production

SQL> @latchprof sid,name % % 1000000

-- LatchProf 2.10 by Tanel Poder ( https://blog.tanelpoder.com )
old 5: &_lhp_what
new 5: sid,name
old 8: , COUNT() / &_lhp_samples total_samples_pct
new 8: , COUNT() / 1000000 total_samples_pct
old 10: (SELECT /*+ NO_MERGE / 1 FROM DUAL CONNECT BY LEVEL <= &_lhp_samples) s,
new 10: (SELECT /+ NO_MERGE */ 1 FROM DUAL CONNECT BY LEVEL <= 1000000) s,
old 20: l.sid LIKE '&_lhp_sid'
new 20: l.sid LIKE '%'
old 21: AND (LOWER(l.name) LIKE LOWER('%&_lhp_name%') OR LOWER(RAWTOHEX(l.laddr)) LIKE LOWER('%&_lhp_name%'))
new 21: AND (LOWER(l.name) LIKE LOWER('%%%') OR LOWER(RAWTOHEX(l.laddr)) LIKE LOWER('%%%'))
old 24: &_lhp_what
new 24: sid,name
old 30: &_lhp_what
new 30: sid,name
old 34: , s.total_samples / &_lhp_samples * 100 latchprof_pct_total_samples
new 34: , s.total_samples / 1000000 * 100 latchprof_pct_total_samples
old 35: , (t2.hsecs - t1.hsecs) * 10 * s.total_samples / &_lhp_samples latchprof_total_ms
new 35: , (t2.hsecs - t1.hsecs) * 10 * s.total_samples / 1000000 latchprof_total_ms
old 37: , (t2.hsecs - t1.hsecs) * 10 * s.total_samples / dist_samples / &_lhp_samples latchprof_avg_ms
new 37: , (t2.hsecs - t1.hsecs) * 10 * s.total_samples / dist_samples / 1000000 latchprof_avg_ms
t1,
*
ERROR at line 39:
ORA-65011: Pluggable database does not exist.

SQL>
SQL> show pdbs

CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---

     2 PDB$SEED                       READ ONLY  NO
     3 IBMSPDB1                       READ WRITE NO
     4 PRD605                         READ WRITE NO

SQL>