How to find MidTier url from DB tier

Hi,
Here is what I am looking for:

In my architecture, I have a mechanism to route user's request for any URL to one of the available servers. The number and direct url to each server is transparent to end user as the redirection is being done by BIGIP server. Each midtier is configured for a dedicated database and we are using mod pl/sql as backend.

My requirement is: is there any way in which, I can find out from which midtier user's request is coming. At BIGIP level, I have no way to find out to which midtier it will route user's request.

Diagramatically, the architecture can be explained as:

         |                   |         MidTier1 ---> DB1
user     |     BIGIP         |          Midtier2 ---> DB2
         |                   |          Midtier3 ---> DB3

so, at database level, I want to find from which MT, the request was generated.
I tried using owa_util.get_cgi_env('SERVER_NAME') and owa_util.get_cgi_env('SERVER_PORT') but these functions are returning the url entered by enduser. But i m interested in direct url which BIGIP uses to route to particular midtier. I need this particular MT url as I will be using this url in some other program to hit same DB where my previous request was addressed.

Any inputs will be of great help.

Thanks in advance,
-Yogesh Received on Tue Dec 13 2005 - 03:04:21 CST