[Oracle]CON_ID ⇒ PDB名に変換するファンクション

select con_id_to_con_name(con_id),user,count(*) from gv$session group by con_id;

SQL> select con_id_to_con_name(con_id),user,count(*) from gv$session group by con_id;

CON_ID_TO_CON_NAME(CON_ID)                                       USER       COUNT(*)
---------------------------------------------------------------- ---------- --------
CDB$ROOT                                                         SYS              16
PDBHANPEN01                                                      SYS               1
                                                                 SYS             152

SQL>