Below are the details:
Database Version - 11.2.0.3
4 node RAC
EBS Version - 12.1.3
OS - AIX
Below are the details of a session for which we see multiple os process ids. Can someone please explain why multiple spid for the same sid, serial# combination.
| SID SERIAL# USERNAME | INST_ID OSUSER | SPID |
------- ------- -------------------- ---------- --------------- --------
| 3651 60283 APPS | 4 | 12320914 |
| 3651 60283 APPS | 4 | 15861340 |
| 3651 60283 APPS | 4 | 4326126 |
NOTE - When I try to get the sid from the above spid (s) I get the output only for one of them.
SQL> @pid
SQL> set echo off
Enter Unix process id: 12320914
Enter instance id: 4
=====================================================================
1 sessions were found with 12320914 as their unix process id for the instance number 4
=====================================================================
SID/Serial : 3651,60283
Foreground : PID: 1234 -
Shadow : PID: 12320914 - oracle@extendp
SQL> @pid
SQL> set echo off
Enter Unix process id: 15861340
Enter instance id: 4
=====================================================================
0 sessions were found with 15861340 as their unix process id for the instance number 4
=====================================================================
0 sessions were found with 15861340 as their unix process id for the instance number 4
Please scroll up to see details of all the sessions.
=====================================================================
SQL>
SQL> @pid
SQL> set echo off
Enter Unix process id: 4326126
Enter instance id: 4
=====================================================================
0 sessions were found with 4326126 as their unix process id for the instance number 4
=====================================================================
0 sessions were found with 4326126 as their unix process id for the instance number 4
Please scroll up to see details of all the sessions.
=====================================================================
Regards,
Aditya.