[Oralce]GUID⇒PDB名に変換に変換する方法
CON_ID_TO_CON_NAME(CON_GUID_TO_ID(GUID)))
統合監査ログの調査時とかに手軽にPDB名をひく
oracle@rac-x1 ~]$ cat ~/pdbname.sh
echo "SELECT CON_ID_TO_CON_NAME(CON_GUID_TO_ID(HEXTORAW('$1'))) PDBNAME FROM DUAL;" | sqlplus -s / as sysdba
[oracle@rac-x1 ~]$ ~/pdbname.sh B530D2C2148A0A19E053C900A8C0B715
PDBNAME
-----------
PDBHANPEN01
[oracle@rac-x1 ~]$