Database Administration (MOSC)

MOSC Banner

AIX Unix process spawns more then one Oracle session. MTS is not used.

edited Apr 8, 2009 3:15AM in Database Administration (MOSC) 4 comments
Hi,

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'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center