Hi there
We are using 12c release 1 in a Windows environment.
We have a couple of pluggable databases pdbA and pdbB, there is a database link in pdbB that allows pdbB to query tables in pdbA.
When viewing sessions on pdbA, I can see those that are from pdbB by the Username which is the user associated with the database link created on pdbB, what I would like to know is how do I locate the actual client session on pdbB that the session on pdbA belongs to? In v$session it just gives the following
OSUSER SYSTEM
MACHINE ORASERVER
PROGRAM ORACLE.EXE
Thanks