Data dictionary information about the shared server
The data dictionary, which we introduced in Chapter 2, also contains information
about the operation of the MTS in the following views:
V$SHARED_SERVER_MONITOR
This view contains dynamic information about the shared servers, such as highwater
marks for connections and how many shared servers have been started
and stopped in response to load variations.
Oracle at Work | 77
V$DISPATCHER
This view contains details of the dispatcher processes used by the shared server.
It can determine how busy the dispatchers are.
V$SHARED_SERVER
This view contains details of the shared server processes used by the shared
server. It can determine how busy the servers are, to help set the floor and ceiling
values appropriately.
V$CIRCUIT
Youcan think of the route from a client to its dispatcher and from the dispatcher
to the shared server (using the queues) as a virtual circuit. This view
details these virtual circuits for user connections.
Oracle at Work
To help you truly understand how all the disparate pieces of the Oracle database
work together, this section walks through an example of the steps taken by the Oracle
database to respond to a user request.
Pages:
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187