Like tables and indexes, rollback segments may run out of space during processing and need to request additional extents. Dynamic extension can have a serious impact on performance, particularly on th...
Oracle is an Object-Relational Database Management System, or, ORDBMS for short. A traditional RDBMS (Oracle Version 7 and below) stores data in tables called relations. These relations are two dimens...
This section discusses the following Net8 configurations: Dedicated server Multi-threaded server (MTS) Oracle Internet Directory Oracle Names Connection Manager As you read these sections, bear...
There are several ways to look at what's happening in a multi-threaded server environment. Using operating-system commands, you may be able to see a list of the dispatcher and shared server processes ...
As their name implies, locally managed tablespaces do not manage their free and used extents by the data dictionary but are instead managed at the local tablespace level. This local management is acco...
Shared pool latch contention can occur when the shared pool is sized too large to be effectively managed. Starting with Oracle version 8.1.6, Oracle implemented improved shared pool management archite...
SGA refers to a Shared Global Area. As the term global implies, this area is accessible to all Oracle processes and users. Each instance will have its own SGA. Oracle processes and users must share la...
Oracle9i has renamed the multi-threaded server (MTS) to shared server. The shared-server architecture increases the scalability of applications and the number of clients that can be simultaneously con...
Before implementing MTS (Multi-Threaded Server), there are several questions you need to answer: What protocols do you want to support? How many dispatchers do you want to have? How many shared se...
Oracle provides statistics which relate to the capability of rollbacks to shrink back to an optimal size. To make use of these statistics it is suggested that the following two views be created to red...
When monitoring redo logs, instead of direct views for statistics, we must look at statistics based on redo log and log writer process statistics. These views are: V$STATNAME V$SESSION V$PROCESS V$SE...
Multi-threaded server is not something that should implemented just because it exists. MTS has a specific purpose and, like any other feature, it comes with a set of trade-offs that you should conside...
