Is there a way of identifying the connections made to a pluggable Oracle database? I can use the v$sessions and v$process views, but this seems to show all sessions within the container and all pluggable databases (with no indication on those views as to which database the session is linked to).
Any ideas?
You can use the column SERVICE_NAME of v$session to identify to which service a session is connected to. Each PDB has at least one service name. You can set more than one service name for a PDB but this might still help.