How to increase number of connections in Oracle - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: How to increase number of connections in Oracle

  1. #11
    Join Date
    Oct 2008
    Posts
    5
    So how will I change the max. no. of connections ?

    How can I check the current max. no. of connections ?

  2. #12
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    There is nothing called connection parameter.

    You increased the process. Now increase the session and transaction using the similar command which you used previously.

    To check number of sessions.

    select * from v$parameter where lower(name) = 'sessions'
    http://www.perf-engg.com
    A performance engineering forum

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