DBA Data[Home] [Help]

VIEW: SYS.GV_$SERVICES

Source

View Text - Preformatted

select "INST_ID","SERVICE_ID","NAME","NAME_HASH","NETWORK_NAME","CREATION_DATE","CREATION_DATE_HASH","GOAL","DTP","AQ_HA_NOTIFICATION","CLB_GOAL","COMMIT_OUTCOME","RETENTION_TIME","REPLAY_INITIATION_TIMEOUT","GLOBAL","SESSION_STATE_CONSISTENCY","PDB","SQL_TRANSLATION_PROFILE","MAX_LAG_TIME","CON_ID" from gv$services
View Text - HTML Formatted

SELECT "INST_ID"
, "SERVICE_ID"
, "NAME"
, "NAME_HASH"
, "NETWORK_NAME"
, "CREATION_DATE"
, "CREATION_DATE_HASH"
, "GOAL"
, "DTP"
, "AQ_HA_NOTIFICATION"
, "CLB_GOAL"
, "COMMIT_OUTCOME"
, "RETENTION_TIME"
, "REPLAY_INITIATION_TIMEOUT"
, "GLOBAL"
, "SESSION_STATE_CONSISTENCY"
, "PDB"
, "SQL_TRANSLATION_PROFILE"
, "MAX_LAG_TIME"
, "CON_ID"
FROM GV$SERVICES