-
How to limit number of sessions thru a dblink?
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!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|