It doesn't really work that way, because the *same* database can support both.
You can see how *sessions* are connected via V$SESSION
SQL> select sid, server from v$session;
SID SERVER
---------- ---------
1 DEDICATED
2 DEDICATED
3 DEDICATED
4 DEDICATED
5 DEDICATED
6 DEDICATED
8 DEDICATED
10 DEDICATED
11 DEDICATED
13 DEDICATED
16 DEDICATED
...