7.6 V$ACTIVE_SERVICES
V$ACTIVE_SERVICES
displays information about the active 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 a service on the specified instance is blocked from accepting new connections altogether ( |
|
|
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 COMMIT_OUTCOME service attribute enabled ( When the attribute is enabled:
See Also: For information about preserving the commit outcome, see Oracle Database Development Guide. For information about logical transaction IDs, see Oracle Database Development Guide |
|
|
For Transaction Guard ( |
|
|
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 transaction 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:
|
|
|
Container name of the object. The value of this column is |
|
|
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 |
|
|
The ID of the container to which the data pertains. Possible values include:
|
Footnote 1 This column is available starting with Oracle Database release 19c, version 19.1.