eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.DBA_SERVICES

Object Details

Object Name:	DBA_SERVICES
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Comments
SERVICE_ID	NUMBER		The unique ID for this service
NAME	VARCHAR2	(64)	The short name for the service
NAME_HASH	NUMBER		The hash of the short name for the service
NETWORK_NAME	VARCHAR2	(512)	The network name used to connect to the service
CREATION_DATE	DATE		The date the service was created
CREATION_DATE_HASH	NUMBER		The hash of the creation date
FAILOVER_METHOD	VARCHAR2	(64)	The failover method (BASIC or NONE) for the service
FAILOVER_TYPE	VARCHAR2	(64)	The failover type (SESSION or SELECT) for the service
FAILOVER_RETRIES	NUMBER	(10)	The number of retries when failing over the service
FAILOVER_DELAY	NUMBER	(10)	The delay between retries when failing over the service
MIN_CARDINALITY	NUMBER		The minimum cardinality of this service to be maintained by director
MAX_CARDINALITY	NUMBER		The maximum cardinality of this service to be allowed by director
GOAL	VARCHAR2	(12)	The service workload management goal
DTP	VARCHAR2	(1)	DTP flag for services
ENABLED	VARCHAR2	(3)	Indicates whether or not this service will be started/maintained by director
AQ_HA_NOTIFICATIONS	VARCHAR2	(3)	Indicates whether AQ notifications are sent for HA events
CLB_GOAL	VARCHAR2	(5)	Connection load balancing goal for services
EDITION	VARCHAR2	(128)	Initial session edition for services
COMMIT_OUTCOME	VARCHAR2	(3)	Commit outcome is persisted
RETENTION_TIMEOUT	NUMBER		How long (in secs) is the commit outcome stored before it is retained
REPLAY_INITIATION_TIMEOUT	NUMBER		How long (in secs) can transaction be replayed after transaction start
SESSION_STATE_CONSISTENCY	VARCHAR2	(128)	Type of non-transactional changes during a transaction
GLOBAL_SERVICE	VARCHAR2	(3)	Service is used for global service management
PDB	VARCHAR2	(128)	Service is created in a pluggable database
SQL_TRANSLATION_PROFILE	VARCHAR2	(261)	Name of the SQL translation profile
MAX_LAG_TIME	VARCHAR2	(30)	Maximum lag time of a global service
GSM_FLAGS	NUMBER		Flags specific to a global service

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SERVICE_ID
,      NAME
,      NAME_HASH
,      NETWORK_NAME
,      CREATION_DATE
,      CREATION_DATE_HASH
,      FAILOVER_METHOD
,      FAILOVER_TYPE
,      FAILOVER_RETRIES
,      FAILOVER_DELAY
,      MIN_CARDINALITY
,      MAX_CARDINALITY
,      GOAL
,      DTP
,      ENABLED
,      AQ_HA_NOTIFICATIONS
,      CLB_GOAL
,      EDITION
,      COMMIT_OUTCOME
,      RETENTION_TIMEOUT
,      REPLAY_INITIATION_TIMEOUT
,      SESSION_STATE_CONSISTENCY
,      GLOBAL_SERVICE
,      PDB
,      SQL_TRANSLATION_PROFILE
,      MAX_LAG_TIME
,      GSM_FLAGS
FROM SYS.DBA_SERVICES;

Dependencies

[top of page]

SYS.DBA_SERVICES references the following:

SYS: SERVICE$

SYS.DBA_SERVICES is referenced by following:

GSMADMIN_INTERNAL: DBMS_GSM_DBADMIN - show dependent code
PUBLIC: DBA_SERVICES
SYS: ALL_DEQUEUE_QUEUES; ALL_QUEUES; ALL_SERVICES; DBA_QUEUES; DBMS_FEATURE_SERVICES - show dependent code; USER_QUEUES; _ALL_QUEUE_SCHEDULES