Skip to Main Content

Programming Languages & Frameworks

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Node-oracledb 4.1 has Oracle Database Sharding support

The 4.1 release of node-oracledb introduces support for Oracle Sharding.  It also adds support for two more end-to-end tracing attributes. There are some waited-for bug fixes too. The release announcement is at https://blogs.oracle.com/opal/node-oracledb-41-oracle-database-sharding-support

Comments

Billy Verreynne

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

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

sol-danesh

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

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.

1 - 4

Post Details

Added on Nov 25 2019
0 comments
93 views