Friday, September 10, 2010

How to get the client's machine name and their IP Address in Oracle 10g?


I was recently asked to spool out the client’s machine, their IP addresses and the service_name they are using to connect to RAC DB into a text file. I came up with the following queryand it worked like a charm. Although I tested it on a non-RAC db server, I have no doubt it will work on any RAC cluster.


No comments:

Post a Comment