Resource directive - ACTIVE_SESS_POOL_P1 and db link
Hello,
I would like to limit number of active sessions connecting to oracle database from other oracle database through db link. I've tried to use ACTIVE_SESS_POOL_P1
parameter from resource directive. I've set this parameter to 3. But still i can have more than 3 sessions active connecting through db link from other oracle database. I would like to mention that this parameter works properly if i have active sessions directly connected to database which have resource plan active with ACTIVE_SESS_POOL_P1 set.
Such behaviour may be caused by different treat of db link session but i don't now nothing about this.
Could someone help me, please ?
Best Regards Arkadiusz Masny