Hi,

I have 3 Oracle servers, the first is Windows with 9i, the two others are AIX with 8i.

There are some users who use a VB application, wich connects to the windows server. On this server they select a view that select data from the second server thru a dblink.

On the second server, that view selects data from the third server thru another dblink.

Now, all these connections use the same username, and the same dblink.

I want to limit the number of concurrent sessions on the third server, because I have a limited number of licences.

I have created a profile on this server (the third one) with some limits (SESSIONS_PER_USER=5, IDLE_TIME=30, CONNECT_TIME=480). The user used by the dblink is assigned to this profile.

But even with theses limits, I still have a lot of connections (almost 20) and they remain INACTIVE for hours and even days.

It seems that the limits given by the profile don't apply to a user connected thru a dblink? Is it true?

Thanks!