Oracle8i Reference
Release 2 (8.1.6)

Part Number A76961-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

Dynamic Performance (V$) Views, 93 of 179


V$MTS

This view contains information for tuning the multi-threaded server.

Column  Datatype  Description 

MAXIMUM__CONNECTIONS 

NUMBER  

The highest number of virtual circuits in use at one time since the instance started. If this value reaches the value set for the MTS_CIRCUITS initialization parameter, consider raising the value of MTS_CIRCUITS.

See Also: "MTS_CIRCUITS"

MAXIMUM_SESSIONS 

NUMBER 

The highest number of multi-threaded server sessions in use at one time since the instance started. If this reaches the value set for the MTS_SESSIONS initialization parameter, consider raising the value of MTS_SESSIONS.

See Also: "MTS_SESSIONS"

SERVERS _STARTED 

NUMBER  

The total number of multi-threaded servers started since the instance started (but not including those started during startup) 

SERVERS _TERMINATED 

NUMBER 

The total number of multi-threaded servers stopped by Oracle since the instance started 

SERVERS _HIGHWATER  

NUMBER 

The highest number of servers running at one time since the instance started. If this value reaches the value set for the MTS_MAX_SERVERS initialization parameter, consider raising the value of  MTS_SERVERS.

See Also: "MTS_SERVERS"


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index