DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: concurrent sessions per user

  1. #1
    Join Date
    Oct 2000
    Posts
    211
    I have problems in limiting the no. of concurrent sessions that a user can use to connect to the database.
    Using enterprise manager, when i reduce the 'concurrent sessions' parameter, it is not effective. I then tried to create another profile having just one as concurrent sessions. But it allows to have more than one. What may be the problem?
    Should the database need to restart before the changes take effect?
    thanks
    manjunath

  2. #2
    Be sure you have RESOURCE_LIMIT set to TRUE in the init.ora
    Ramon Caballero, DBA, rcaballe@yahoo.com

  3. #3
    Join Date
    Oct 2000
    Posts
    211
    Thanks a lot ramon,
    it was set to 'false'. I will correct the mistake.
    manjunath

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