number of sessions and number of processes

[pando]

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

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

[julian]

As far as I know the processes are dynamically assigned in the background. We can not influence on that at all.

[pando]

well I have always thought that a session is assigned to a server process but it seems that i was completely wrong.... I just wonder how this mechanism works?

I am not sure if this done by forms server or we can actually reproduce it in a client server enviroment

[ovidius]

If you are talking about connections made through IAS, then is very possible to be about a connection pool that app. server is making... So, you have 5 forms but only one single real connection. Then, you have one single server process.
I don't know, it could be possible... I did not work with Oracle iAS, but other AS make exactly how I told you...

[Shestakov]

Originally posted by ovidius
If you are talking about connections made through IAS, then is very possible to be about a connection pool that app. server is making...

Connection pool, including Oracle connection pool for Java (Thin or OCI driver) or PRO*C. This is part of CLIENT SITE OF APPLICATION:

client_site --------- server_site
N x connections ------ 1 session

Another type of connection pool is:

client_site --------- server_site
N x connections ----- M x sessions
Where N >= M always.

BUT NEWER : 1 connection in client connection pool --> N sessions in server.

----------------------------------------
To pando:
Try to check tnsnames.ora on OAS box, may be it consists something like:
tns_entry =
(DESCRIPTION=
(ADDRESS=...)
(ADDRESS=...)
(CONNECT_DATA=
(SERVER_NAME= ....)
(SERVER=shared)))







[Edited by Shestakov on 04-22-2002 at 12:29 PM]

[pando]

well i am using only the Forms Server so there is no connection pool like WebLogic or like

[ovidius]

If needed, I think...

[Shestakov]

Repeat post:
Try to check tnsnames.ora on OAS box, may be it consists something like:
tns_entry =
(DESCRIPTION=
(ADDRESS=...)
(ADDRESS=...)
(CONNECT_DATA=
(SERVER_NAME= ....)
(SERVER=shared)))

[Shestakov]

Addition procedure:

1. set listener_trace_level to ADMIN or SUPPORT
2. create new Forms connection
3. find in listener.trc file section:
nsprecv: packet dump
nsprecv: 00 ED 00 00 01 00 00 00 |........|
nsprecv: 01 36 01 2C 0C 01 08 00 |.6.,....|
nsprecv: 7F FF 7F 08 00 00 01 00 |........|
nsprecv: 00 B3 00 3A 00 00 02 00 |...:....|
nsprecv: 41 41 00 00 00 00 00 00 |AA......|
nsprecv: 00 00 00 00 1E 57 00 00 |.....W..|
nsprecv: 00 04 00 00 00 00 00 00 |........|
nsprecv: 00 00 28 44 45 53 43 52 |..(DESCR|
nsprecv: 49 50 54 49 4F 4E 3D 28 |IPTION=(|
nsprecv: 41 44 44 52 45 53 53 3D |ADDRESS=|
nsprecv: 28 50 52 4F 54 4F 43 4F |(PROTOCO|
nsprecv: 4C 3D 54 43 50 29 28 48 |L=TCP)(H|
nsprecv: 4F 53 54 3D 6C 61 62 31 |OST=lab1|
nsprecv: 2E 71 75 61 64 72 69 78 |.quadrix|
nsprecv: 2E 63 6F 6D 29 28 50 4F |.com)(PO|
nsprecv: 52 54 3D 31 35 32 31 29 |RT=1521)|
nsprecv: 29 28 43 4F 4E 4E 45 43 |)(CONNEC|
nsprecv: 54 5F 44 41 54 41 3D 28 |T_DATA=(|
nsprecv: 53 45 52 56 49 43 45 5F |SERVICE_|
nsprecv: 4E 41 4D 45 3D 6C 61 62 |NAME=lab|
nsprecv: 2E 71 75 61 64 72 69 78 |.quadrix|
nsprecv: 2E 63 6F 6D 29 28 53 49 |.com)(SI|
nsprecv: 44 3D 6C 61 62 29 28 43 |D=lab)(C|
nsprecv: 49 44 3D 28 50 52 4F 47 |ID=(PROG|
nsprecv: 52 41 4D 3D 29 28 48 4F |RAM=)(HO|
nsprecv: 53 54 3D 64 65 6C 70 68 |ST=delph|
nsprecv: 69 2E 71 75 61 64 72 69 |i.quadri|
nsprecv: 78 2E 63 6F 6D 29 28 55 |x.com)(U|
nsprecv: 53 45 52 3D 73 67 65 6E |SER=sgen|
nsprecv: 65 29 29 29 29 00 00 00 |e))))...|

and check real type of connection, that generate by OAS.

[pando]

Shestakov

check my first post, my query and the query results, you can see DEDICATED in server column