4.89 ALL_SERVICES
ALL_SERVICES
displays all services in the database. The view excludes rows marked for deletion.
Related View
DBA_SERVICES
displays all services in the database. The view excludes rows marked for deletion.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique ID for the service |
|
|
|
Name describing the workload |
|
|
|
Hash of the short name for the service |
|
|
|
Network name used to connect to the service |
|
|
|
Date the service was created |
|
|
|
Hash of the creation date |
|
|
|
TAF only for compatibility - |
|
|
|
For Application Continuity for Java, |
|
|
|
For Application Continuity and TAF, when reconnecting after a failure, number of attempts to re-connect per incident |
|
|
|
For Application Continuity and TAF, when reconnecting after a failure, delay between each connection retry (in seconds) |
|
|
|
Reserved for internal use |
|
|
|
Reserved for internal use |
|
|
|
Runtime Load Balancing Goal being used to create run-time load balancing and connection load balancing advice:
|
|
|
|
DTP (distributed transaction processing) enforces all sessions for a service at one instance. This is a requirement for XA before 11g, and is a requirement if resuming and suspending the same XA branch. |
|
|
|
Reserved for internal use |
|
|
|
To enable FAN for OCI connections, set AQ HA Notifications to |
|
|
|
Connection load balancing goal. When using run-time load balancing, |
|
|
|
A non-NULL value specifies the initial session edition for subsequent database connections that use the service and do not specify an edition. A NULL value has no effect. |
|
|
|
For Transaction Guard and Database Native Transaction Guard, indicates whether the database service associated with the user session has the When the value of this column is See Also: Oracle Database Development Guide for information about preserving the commit outcome |
|
|
|
For Transaction Guard and Database Native Transaction Guard, when |
|
|
|
For Application Continuity, indicates a time period (in seconds) after which the request will not be replayed. The time period starts at the first request submission. The default value is 300 seconds, which is 5 minutes. |
|
|
|
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 Data Services (GDS) and can be provided by multiple databases that contain replicated data. Possible values:
This attribute is set when using GDS. It cannot be set by a user. |
|
|
|
Name of a PDB associated with a given service. Will contain NULL for a non-CDB or if the service is not associated with a PDB (that is, connecting to a CDB using this service will cause a user to connect to the root.) When managing services for a PDB, use SRVCTL for Oracle RAC and Oracle RAC One Node databases, or connect to that PDB if it is a single instance (not RAC). The PDB attribute shows which PDB has the service. It cannot be set or modified explicitly. |
|
|
|
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 using the Global Data Services (GDS) interfaces. It is not supported to change this value at local databases. |
|
|
|
Flags specific to Global Data Services (GDS). Can only be specified for global services using the GDS interfaces. It is not supported to change these values at local databases. |
|
|
|
Name of the associated parallel query rim service |
|
|
|
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 |
|
|
|
Placement policy for the service. Possible values:
Note: Values other than |
|
|
Reset state for the service. Possible values:
|
|
|
|
Reserved for future use |
|
|
|
For Transaction Guard and Database Native Transaction Guard, when
|
|
|
|
True Cache service associated with this database service |
|
|
|
Reserved for internal use |
|
|
|
Reserved for internal use |
See Also:
-
Oracle Database PL/SQL Packages and Types Reference for more information about the
DBMS_APP_CONT.GET_LTXID_OUTCOME
procedure