(URGENT) Too many sessions
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: (URGENT) Too many sessions

  1. #1
    Join Date
    Jan 2000
    Location
    Manama, Bahrain
    Posts
    50
    I have a few queries about sessions:-

    1) what does 'ACTIVE' & 'INACTIVE' mean for sessions?

    2) our system is showing too many active/inactive sessions even though the users claim they log in only once. How is this possible?

    3) the users connect to the database thru an application. Could it be that the application is implicitly causing multiple sessions for a user?

    4) even if a session is inactive, are the memory resources etc. still kept locked for the user or are they automatically released?

    Would appreciate any help on this.

    Thanks & regards
    Lynn

  2. #2
    Join Date
    Aug 2000
    Posts
    236
    Lynn,

    Background process running will show up as active sessions.

    To restrict users from opening up too many sessions, create a profile and set SESSIONS_PER_USER for each unique user.
    Assign this profile to all your users.

    Nizar

  3. #3
    Join Date
    Jul 2000
    Posts
    23
    Hi

    Inactive sessions , whereas the PMON is runing to cleanup the
    user transactions at the server.

    yes it occupies memory , So you can kill the session use the dynamic perfromance view V$SESSION


    Arun






  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    if you are using an windows app then these appa open at least 2 session per PC

  5. #5
    Join Date
    Jun 2000
    Posts
    417
    as far as active/inactive go, i'm pretty sure an ACTIVE session is only one who is in the middle of doing work. executing a statement, procedure, etc.

    if i log onto sqlplus and let it sit there while you query sessions, mine will be INACTIVE. if i execute a query that takes 10 seconds, and you query sometime during those 10 seconds, i will be ACTIVE.

    what applications are running against your database? some applications may make persistant connections.


  6. #6
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    The best way to get over the inactive sessions is to create a profile and set the session idle time to some where around 60 min. This way if some one keeps the sessions open and goes home for the day, you could remove them without any problem. Also as one of the other guys suggested set up the session limit and this way you could put a limit on the number of sessions that a user can open.

    Good luck,
    Sam

  7. #7
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    Pando,
    You are right about windows apps taking up more than one session; I have seen it in practice. Could you elaborate on this a little though ? I mean why more than one session ?

    Thanks,

    - Rajeev

  8. #8
    Join Date
    Jan 2000
    Location
    Manama, Bahrain
    Posts
    50
    Thanks for your replies.

    The application has been created using Developer. It is an online system for registration of businesses and also creating reports.
    I do not know the details of the system.. but could you'll elaborate when u'll said that windows appliations take up more than one session?

    Thanks & regards
    Lynn

  9. #9
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well in our company´s app it works like this:

    when you run the application it will open one session just to show the "entry" of the application, the place where you select which form or report you want to use, then once you choose one option it will open another session, for example if one open a form to fill in an order, this will get 2 sessions per PC because everyone using this kind of aplication will have at least one form or report open and the main application

  10. #10
    Join Date
    Nov 2000
    Posts
    9

    Thumbs up


    Hi lynn,

    As per ur request, sessions are nothing but the physical
    connection establised to oracle database. If u execute
    a long running updates or deletes against a table, the session will be
    active, this signifies that the table is locked during that
    process, simultaneously if another user issue a DML statements
    against the same table, his sessions also will be in active mode,
    and also it will be realsed only when former job is completed.
    this is the overall information, which provided. Default
    there are some oracle background process will be running as
    soon as the database instance started , theses session information
    will active thr' out for ever,until u shutdown the database.



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