Categories

Many PMON OSPID in 1 Database with 1 PROCESS ID

Rahul Kumar-Oracle
Rahul Kumar-Oracle Orion GCS Customer Posts: 2
in General

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 oracle@AIXISSORA01 (PMON)

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

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

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

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

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

1 1 24363 No command in progress ACTIVE oracle 19594 AIXISSORA01 UNKNOWN 16-05-2022 09:49:56 oracle@AIXISSORA01 (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