1 connect generate many sessions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: 1 connect generate many sessions

  1. #1
    Join Date
    Feb 2003
    Location
    Thailand
    Posts
    4

    Question 1 connect generate many sessions

    Hi all,
    I found that there are many sessions created on server when 1 developer use sqlplus to connect to DB. and other users could not connect because max_sessions exceeded. when this user logout , all related sessions were ended and others can use normally.
    this doesn't happen everytime but intermittently.
    any ideas to help prevent this ??
    thank you.

  2. #2
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi,
    just one litlte idea,
    what does the user in the SQL*PLUS-window?

    starts the user longer running dba_jobs?

    OR is he WORKING IN PARALLEL Query MODE, so one
    Query causes many sessions ?

    Orca

  3. #3
    Join Date
    Feb 2003
    Location
    Thailand
    Posts
    4
    he didn't run any query or any jobs.
    just first connect from client via net8.
    any ideas ?
    thanks in advance

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by Orca777
    OR is he WORKING IN PARALLEL Query MODE, so one
    Query causes many sessions ?
    Parallel queries (or parallel DDL operations) do not create any additional sessions during executions. They merely spawn additional processes, but all those processes still run under the same original session. So this can not be the reason for any "MAX_SESSIONS exceeded" errors.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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