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

Thread: listener process

  1. #1
    Join Date
    Jan 2000
    Location
    san jose
    Posts
    149
    when i use ps -ef i found a lot of lines similar as the following
    what does all those come from?
    based on my understanding, those lines corresponding to
    all request from outside, but sometimes the number of it goes
    unreasonably big, what's the probably reason?


    oracle 2970 1 0 17:33:05 ? 0:00 oracletest ( LOCAL=NO)

  2. #2
    Check in v$session, it should show the same number of sessions/processes
    Ramon Caballero, DBA, rcaballe@yahoo.com

  3. #3
    Join Date
    Jan 2000
    Location
    san jose
    Posts
    149
    but after i shutdown the database, stop listener,
    it is stilll there.

  4. #4
    And you don't have any other DB on that host?
    ps -fea|grep db
    The shutdown is normal? or abort?
    Ramon Caballero, DBA, rcaballe@yahoo.com

  5. #5
    Join Date
    Jan 2000
    Location
    san jose
    Posts
    149
    no, and the shutdown is normal

  6. #6
    Join Date
    Nov 2000
    Posts
    9
    You connect to your server through local SQL+ and once again see it . These are all OS Processes for each DB Session(user connection).


  7. #7
    Join Date
    Jan 2000
    Location
    san jose
    Posts
    149
    but it is MUCH MUCH MORE than the user connection.

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