Concepts and differences of the Oracle server private mode and Sharing Mode
---------------------------------------------------------------
The sharing mode applies to the concept of a connection pool similar to that of the connection pool. However, the sharing mode does not work well in actual applications. I do not know whether it has been improved in 10 Gb.
---------------------------------------------------------------
The essential difference between the dedicated mode and the shared mode is that the user process is dedicated to or shared with the "server process" in the Oracle memory zone.
The specific performance is as follows:
1. In shared mode, multiple user processes share one server process. In dedicated mode, Oracle prepares a server process for each user process.
2. In actual situations, there are always many connection requests between the application system and the database, resulting in many user processes. If your memory and CPU are limited, at the same time, if the user process does not occupy much space for database operations, you can set the database connection mode to the sharing mode. In this way, the server processes in the Oracle memory zone are limited, these server processes are scheduledProgramTo handle requests from several user processes.
3. If your hardware resources are good, set it to a dedicated mode. Each user process corresponds to a server process. In this way, your user process processes data very quickly!
---------------------------------------------------------------
To put it simply, if the number of connected customers is small and it takes a long time to occupy the database, we recommend that you use the proprietary mode. If the number of connected customers is large, use the shared mode.