Skip to content

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

VIEW: SYS.ALL_SERVICES

Object Details
Object Name: ALL_SERVICES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
SERVICE_ID NUMBER

NAME VARCHAR2 (64)
NAME_HASH NUMBER

NETWORK_NAME VARCHAR2 (512)
CREATION_DATE DATE

CREATION_DATE_HASH NUMBER

FAILOVER_METHOD VARCHAR2 (64)
FAILOVER_TYPE VARCHAR2 (64)
FAILOVER_RETRIES NUMBER (10)
FAILOVER_DELAY NUMBER (10)
MIN_CARDINALITY NUMBER

MAX_CARDINALITY NUMBER

GOAL VARCHAR2 (12)
DTP VARCHAR2 (1)
ENABLED VARCHAR2 (3)
AQ_HA_NOTIFICATIONS VARCHAR2 (3)
CLB_GOAL VARCHAR2 (5)
EDITION VARCHAR2 (128)
COMMIT_OUTCOME VARCHAR2 (3)
RETENTION_TIMEOUT NUMBER

REPLAY_INITIATION_TIMEOUT NUMBER

SESSION_STATE_CONSISTENCY VARCHAR2 (128)
GLOBAL_SERVICE VARCHAR2 (3)
PDB VARCHAR2 (128)
SQL_TRANSLATION_PROFILE VARCHAR2 (261)
MAX_LAG_TIME VARCHAR2 (30)
GSM_FLAGS NUMBER

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.ALL_SERVICES;

Dependencies

[top of page]

SYS.ALL_SERVICES references the following:

SchemaSYS
ViewDBA_SERVICES
SYS.ALL_SERVICES is referenced by following:

SchemaPUBLIC
SynonymALL_SERVICES