Forum Stats

  • 3,875,462 Users
  • 2,266,926 Discussions
  • 7,912,223 Comments

Discussions

What is the functionality of session & processes parameters in oracle architectures?

Hi dears

I have 2 questions about the ability of parameters in various Oracle architectures

1- What is the performance of v$session in dedicated and shared server ?

2- What is the performance of v$processes in dedicated and shared server ?

Comments

  • Billy Verreynne
    Billy Verreynne Software Engineer Member Posts: 28,946 Red Diamond

    A session is the logical entity that services a specific db client connection.

    A process is the physical entity that executes a session.

    With dedicated server, each session has its own physical process for execution. 1:1 relationship. A 100 sessions mean a 100 processes.

    With shared server, sessions share a pool of processes, where any idle process can be tasked to execute any shared server session. A 100 processes in the pool can service a 1000 shared sessions. However, if all 100 processes are busy, then 900 sessions need to wait for an idle process in order to to be serviced.

  • sol-danesh
    sol-danesh Member Posts: 7 Green Ribbon

    And What is the method of setting these two parameters in Oracle architectures?

  • sol-danesh
    sol-danesh Member Posts: 7 Green Ribbon

    Thank you dear Billy Verreynne.

    As a result, it can be said that dedicated architecture is better for projects with a large number of users?

  • Billy Verreynne
    Billy Verreynne Software Engineer Member Posts: 28,946 Red Diamond

    Basic parameters for shared server are DISPATCHERS and SHARED_SERVERS.

    Shared Server is ideal for supporting a large number of OLTP type users, servicing 1000s of user requests that are of short duration to service. Note that UGA memory is stored in the SGA.

    Dedicated Server is ideal for supporting OLAP type users, servicing 100s of user requests that are of long duration to service. Note that UGA memory is stored in the PGA.

    The Oracle database can use both architectures at the same time.