Comparison of Oracle Database shared connections and dedicated connections

In the dedicated connection mode, the server establishes a connection with the client for every client request to connect to the database server. This connection is used to process all requests of the client, until the user actively disconnects or the network is interrupted. When the connection is idle, the background process PMON tests the user's connection status at intervals. If the connection is disconnected, PMON cleans up the site and releases related resources. A dedicated connection is equivalent to a one-to-one connection that can quickly respond to user requests. Of course, when connecting, you must first create a PGA (Program global area). The pga_aggregate_target parameter determines the total amount of memory that can be used by all server processes, the workarea_size_policy parameter determines whether to use manual or automatic management. For example: