Many PMON OSPID in 1 Database with 1 PROCESS ID

Rahul Kumar Shah-Oracle
Rahul Kumar Shah-Oracle Posts: 2 Green Ribbon

Each database connection (SID and SERIAL# combination) forks many, many linux processes e.g. 120 unix process per connection. This doesn't see normal behaviour to me?

For example:

SID Serial# OS pid Usrname Command STATUS osuser PROCESS machine Terminal Time program CLIENT_INFO

------ ------- ------------------------ --------------- ------------------------- -------- ---------- ------------------------ ------------------------------ ---------- ------------------- ------------------------------------------------- ----------------------------------------------------------------

1 1 25550 No command in progress ACTIVE oracle 19594 AIXISSORA01 UNKNOWN 16-05-2022 09:49:56 [email protected] (PMON)

1 1 24842 No command in progress ACTIVE oracle 19594 AIXISSORA01 UNKNOWN 16-05-2022 09:49:56 [email protected] (PMON)

1 1 24837 No command in progress ACTIVE oracle 19594 AIXISSORA01 UNKNOWN 16-05-2022 09:49:56 [email protected] (PMON)

1 1 24501 No command in progress ACTIVE oracle 19594 AIXISSORA01 UNKNOWN 16-05-2022 09:49:56 [email protected] (PMON)

1 1 24497 No command in progress ACTIVE oracle 19594 AIXISSORA01 UNKNOWN 16-05-2022 09:49:56 [email protected] (PMON)

1 1 24426 No command in progress ACTIVE oracle 19594 AIXISSORA01 UNKNOWN 16-05-2022 09:49:56 [email protected] (PMON)

1 1 24363 No command in progress ACTIVE oracle 19594 AIXISSORA01 UNKNOWN 16-05-2022 09:49:56 [email protected] (PMON)

.

. plus another 100 or so lines for PMON alone. I have seen as many as 16000 sessions connected to the database. This is not possible given the number of users we have.


So what's going on?


Kindly help on this.

Answers