AIX Unix process spawns more then one Oracle session. MTS is not used.
I've found something that I can't explain. In AIX one Oracle process (spid in v$process)
has several sessions in v$sessions. I'm running AIX 5.3 and Oracle database 10.2.0.4.
In earlier releases of Oracle the relationship between Unix process and database sessions, was
one-to-one. I'm not using MTS.
Anyone who knows why ?
Update:
Here's an example.
ps -ef|grep oracleAM
oracle 2801694 1 0 08:36:42 - 0:00 oracleAMPRD1 (LOCAL=NO)
SQL*Plus
set pages 70
set lines 120
col machine for a30
select v$session.sid, v$session.process, v$session.osuser, v$session.machine
from v$session, v$process
where v$session.paddr = v$process.addr and spid = '2801694'