Oracle Database Operating mode: Dedicated & Shared __python

Database Run mode

Dedicated server mode shared server mode ...

Dedicated Server mode

Each session has a dedicated process for its services for only a few client-connected servers or OLTP (online transaction processing systems)

The cursors, user information, and stack space used by the dedicated server are derived from the PGA

Shared server Mode

Also called multithreaded server mode multiple user processes use the same server process to enter queue processing for multiple client connection servers

Cursors used by shared servers, user information memory from the SGA (inside the large pool) stack in the PGA

①select * from V$queue view queues

②select * from V$circuit

See which processes are in service

③select * from V#shared_server_monitor

Query monitoring shared server content

Ways to query what mode the current database uses:

①select * from V$shared_servers

SELECT * FROM V$dispatchers

The current library uses the dedicated server mode when any one result is empty

②show parameter Dispatchers

The corresponding parameter is NULL for the private server mode

③select * from V$session

The value of the server column in the result is dedicated, the private server mode

④lsnrctl--services

corresponding monitor visible dedicated for dedicated server mode

⑤dbca