hi
does anyone know how several sessions share same process in Oracle without using MTS?
I have this case, running forms from iAS, if 5 forms is opened then I get 5 sessions in v$session but a single server process in database and a single f60web process in ias. If I query v$session I see
Code:SELECT a.username, a.paddr, a.process, b.username, b.addr, spid, a.status, server FROM v$session a, v$process b
WHERE a.paddr=b.addr
ORDER BY 5 DESC
/
PEREDUR 601EAA6C 23079 oracle 601EAA6C 12378 INACTIVE DEDICATED
PEREDUR 601EAA6C 23079 oracle 601EAA6C 12378 INACTIVE DEDICATED
In this case PEREDUR has two forms opened so I see two sessions but only one process