Oracle Database Operating mode: Dedicated & Shared __python

Source: Internet
Author: User
Tags dedicated server

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.