number of sessions and number of processes
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: number of sessions and number of processes

  1. #1
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    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

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    As far as I know the processes are dynamically assigned in the background. We can not influence on that at all.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    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

  4. #4
    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...
    ovidius over!

  5. #5
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    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]

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    well i am using only the Forms Server so there is no connection pool like WebLogic or like

  7. #7
    If needed, I think...
    ovidius over!

  8. #8
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    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)))



  9. #9
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    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.


  10. #10
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Shestakov

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width