DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2000
    hello everybody

    can anybody tell me the max no. of connection possible in dedicated server mode if one has got 15 user license .
    its workgroup server version of oracle 8.1.5 and nt 4.0

    my db was running in mts mode ,i saw ora-04031 frequently.
    i have 512 mb ram with sga -170mb .i had 5 shared server processes and 2 dispatchers.to get rid of that problem

    I changed the db to dedicated server mode.now it run well for 5 days then problem started more users cannot connect simultaneously.can anybody figure out ??

  2. #2
    Join Date
    Jun 2000
    Madrid, Spain
    if you get ora 4031 in MTS you have to increase large pool size, large_pool in initSID.ora, increasing shared pool size would help but try increase large pool first to 15MB

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.