Resource directive - ACTIVE_SESS_POOL_P1 and db link
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Resource directive - ACTIVE_SESS_POOL_P1 and db link

  1. #1
    Join Date
    Feb 2008
    Posts
    31

    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

  2. #2
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    You can have profile with SESSIONS_PER_USER resource for the user which you are connecting through db_link.
    But you may not be able to do it if you are using same user on the server for other purposes also coz it may then limit no of sessions for that also.

    Best is dedicate a seperate user which will be only used through db_link and add profile to that.

    I hope i have put it in correct english.
    Rgds
    Parag

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width