listener process

[bxr556]

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)

[rcaballe]

Check in v$session, it should show the same number of sessions/processes

[bxr556]

but after i shutdown the database, stop listener,
it is stilll there.

[rcaballe]

And you don't have any other DB on that host?
ps -fea|grep db
The shutdown is normal? or abort?

[bxr556]

no, and the shutdown is normal

[Sivakumar11]

You connect to your server through local SQL+ and once again see it . These are all OS Processes for each DB Session(user connection).

[bxr556]

but it is MUCH MUCH MORE than the user connection.