When using Oracle load balancing and ADO.NET, how do you know which host the command executed on?

Question

It's possible to use Microsoft's OracleClient assembly to connect to an Oracle database, and using Oracle's connection string format, set it up to use load balancing, provided your Oracle environment supports it.

The question I have is how do you know after the fact, which db host the command actually executed against? Is there a way to retrieve the machine name from the load balanced set of machines?

Answer 1

Either of these queries will return the instance name:

select instance from v$thread;

-or-

select instance_name from v$instance;