I know that Oracle Forms (4.5 and higher) can create multiple sessions in
one process.
So the Form that is started creates the first session and server. All next
started forms (screens) from the menu create a new session within the same
process.
Don't know what technique is used, but it appears to be possible. There
could be other products in the market that use that technique too. Good, in
my opinion, because the less processes the better.
Maybe column v$session.program can give some info. Check module, action and
client_info too. They must be set by the client program by using the package
DBMS_APPLICATION_INFO.
srivenu <srivenu_at_hotmail.com> schreef in berichtnieuws
1a68177.0304110349.3489d3d2_at_posting.google.com...
| We are running Oracle 9i RAC on SUN E15K (OS solaris 5.8)
| We are running in Dedicated server mode.
| I see that multiple sessions are being bound to a single background server
process.
|
| select a.sid,b.pid,a.process,b.program sprogram,b.spid
| from v$session a,v$process b
| where a.paddr(+)=b.addr
| order by 5
|
| Client Oracle
| Process Server Backgroun
| SID PID ID Program ProcessID
| ---- ---- ---------- ------------------------------ ---------
|
| 29 253 11037 oracle_at_xxxxxxxxxxxxx (TNS V1-V 27997
| 44 253 11037 oracle_at_xxxxxxxxxxxxx (TNS V1-V 27997
| 139 162 11903 oracle_at_xxxxxxxxxxxxx (TNS V1-V 28461
| 299 162 11903 oracle_at_xxxxxxxxxxxxx (TNS V1-V 28461
| 478 157 13201 oracle_at_xxxxxxxxxxxxx (TNS V1-V 29180
| 493 157 13201 oracle_at_xxxxxxxxxxxxx (TNS V1-V 29180
| 214 167 13375 oracle_at_xxxxxxxxxxxxx (TNS V1-V 29306
| 287 167 13375 oracle_at_xxxxxxxxxxxxx (TNS V1-V 29306
| 289 260 13813 oracle_at_xxxxxxxxxxxxx (TNS V1-V 29676
| 182 263 13874 oracle_at_xxxxxxxxxxxxx (TNS V1-V 29710
| 539 263 13874 oracle_at_xxxxxxxxxxxxx (TNS V1-V 29710
|
|
| My question is why are multiple sessions being bound to a single server
process ?
|
| Thanks in advance for any responce.
| regards
| Srivenu
Received on Fri Apr 11 2003 - 11:20:25 CDT
