How to find AIX threads?
We have a siebel installation, 4 siebel servers and 1 oracle db server, all in AIX.AIX is multithreaded and according to note 863771.1 sessions coming from multithreaded OS should have in v$session PROCESS column entries, like "<process id>:<thread id>".
But all sessions opened by processes running in the application servers do not have the thread id in this column. SQL> select process from v$session
2 where machine like 'sblappl%';
PROCESS
------------------------
11337858
16973942
8192000
8782056
7012526
On the other hand, all sessions created by clients running in Windows, which is also multithreaded, have the thread id in PROCESS.
SQL> select process from v$session
But all sessions opened by processes running in the application servers do not have the thread id in this column. SQL> select process from v$session
2 where machine like 'sblappl%';
PROCESS
------------------------
11337858
16973942
8192000
8782056
7012526
On the other hand, all sessions created by clients running in Windows, which is also multithreaded, have the thread id in PROCESS.
SQL> select process from v$session
0