Oracle 视图 V$SERVICES 官方解释，作用，如何使用详细说明
本站中文解释
是Oracle定义的一个数据库视图,用于查看当前连接到数据库的服务名称和服务属性.它包含的列包括服务的名称;服务的版本;构建标识符;描述;超时时间;一系列服务参数，包括回滚对应登录名;客户端编码方式;服务允许的连接数;客户端缓冲区大小;服务状态;以及是否被过滤等.
V$SERVICES视图可以用于查看当前连接到数据库的服务的属性.你可以使用一些内置的函数,如lower()和substr()来结合它,来查看你想要的数据.例如,如果要查看一个特定服务的连接,你可以执行以下查询：
select *
from V$SERVICES
where lower(substr(name,1,5))=”;
你还可以使用V$SERVICES视图来检查你的数据库服务的超时时间是否正确.例如,你可以使用以下查询检查是否有一些某些服务正被设置为无限制的超时时间：
select *
from V$SERVICES
where timeout!=0;
如果查询结果包含服务,你需要重新调整这些服务的超时时间.
官方英文解释
V$SERVICES displays information about the services in the database.
| Column | Datatype | Description |
|---|---|---|
|
|
|
Service ID |
|
|
|
Name of the service |
|
|
|
Service name hash |
|
|
|
Network name |
|
|
|
Creation date |
|
|
|
Creation date hash |
|
|
|
Runtime Load Balancing Goal being used to create run-time load balancing and connection load balancing advice:
|
|
|
|
Indicates whether or not Distributed Transaction Processing is enabled for this service. When Distributed Transaction Processing is set to
|
|
|
|
Indicates whether FAN – Fast Application Notification for OCI connections is set ( |
|
|
|
Connection load balancing goal used with statistics that are sent to the listeners to determine how new connections are distributed:
|
|
|
|
For Transaction Guard, indicates whether the database service associated with the user session has the When
See Also: For information about preserving the commit outcome, see Oracle Database |
|
|
|
For Transaction Guard, when |
|
|
|
For Application Continuity, this option specifies the difference between the time (in seconds) of original execution of the first operation of a request and the time that the replay is ready to start after a successful reconnect. Application Continuity will not replay after the specified amount of time has passed. This option is intended to avoid the unintentional execution of a request when a system is recovered after a long period of time. The default is 5 minutes (300 seconds). |
|
|
|
Describes how non-transactional is changed during a request. This parameter is considered only if |
|
|
|
Indicates whether the service is global. A global service is managed by Global Service Manager (GSM) and can be provided by multiple databases that contain replicated data. Possible values:
|
|
|
|
Name of a pluggable database (PDB) associated with a given service. Will contain |
|
|
|
A non-NULL value specifies the initial SQL translation profile for subsequent database connections that use the service and do not specify a SQL translation profile. A NULL value has no effect. |
|
|
|
The maximum replication lag (in seconds) that is acceptable for a data replica to be used for providing the database service. Can only be specified for global services. |
|
|
|
Stop option for sessions of this service for planned maintenance |
|
|
|
Indicates whether sessions recover their commonly used session state (like NLS, schema) when they are failed over with TAF |
|
|
|
Number of seconds to wait for sessions to be drained |
|
|
|
Sharded table family ID associated with the service |
|
|
|
Reserved for future use |
|
|
|
Reserved for future use |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
