Search notes:

Oracle: V$SERVICES

select
   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  ,
   session_state_consistency  ,
   global                     ,
   pdb                        ,
   sql_translation_profile    , -- See the SQL translation profile object
   max_lag_time               ,
   stop_option                ,
   failover_restore           ,
   drain_timeout              ,
   table_family_id            ,
   placement_template         ,
   commit_outcome_fastpath    ,
   con_id                      
from
   v$services;

See also

Database services
dynamic performance views

Index