My Oracle Support Banner

Shared Server (MTS) Diagnostics (Doc ID 1005259.6)

Last updated on JULY 27, 2022

Applies to:

Oracle Net Services - Version 8.1.5.0.0 to 12.1.0.2 [Release 8.1.5 to 12.1]
Oracle Database - Enterprise Edition - Version 8.1.5.0 to 12.1.0.2 [Release 8.1.5 to 12.1]
Information in this document applies to any platform.

Purpose

Introduction

This document contains information about the Shared Server configuration of the Oracle Database software and some of the SQL scripts necessary to gather diagnostic information with guidelines for interpreting results. Prior to Oracle 9.0, Shared Server was called Multi-Threaded Server; the name was changed to reflect the extensive enhancements made.

Scope

Skill level rating for this Article: Intermediate

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
 Introduction
Scope
Details
 Architecture of the Shared Server Database Configuration
 Dispatchers: The Number Of Dispatchers
 Dispatchers: Shutting Down Dispatchers
 Dispatchers: Monitoring Performance
 Shared Servers: Setting the Quantity of Shared Servers
 Shared Server Performance
 Virtual Circuits and Sessions

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.