SYS.DBMS_FEATURE_SERVICES dependencies on DBA_SERVICES

Line 4: -- Based off dba_services

1: PROCEDURE dbms_feature_services
2: (is_used OUT number, hwm OUT number, feature_info OUT clob)
3: AS
4: -- Based off dba_services
5: num_clb_long NUMBER := 0;
6: num_clb_short NUMBER := 0;
7: num_goal_service_time NUMBER := 0;
8: num_goal_throughput NUMBER := 0;

Line 45: FROM dba_services

41: default_service_name := default_service_name || '.' || db_domain;
42: END IF;
43:
44: SELECT count(*) INTO hwm
45: FROM dba_services
46: WHERE
47: NAME NOT LIKE 'SYS$%'
48: AND NETWORK_NAME NOT LIKE 'SYS$%'
49: AND NAME <> default_xdb_service_name

Line 62: FROM dba_services

58:
59: -- Get the counts for CLB_GOAL variations
60: FOR item IN (
61: SELECT clb_goal, count(*) cg_count
62: FROM dba_services
63: where
64: NAME NOT LIKE 'SYS$%'
65: AND NETWORK_NAME NOT LIKE 'SYS$%'
66: AND NAME <> default_xdb_service_name

Line 84: FROM dba_services

80:
81: -- Get the counts for GOAL variations
82: FOR item IN (
83: SELECT goal, count(*) g_count
84: FROM dba_services
85: where
86: NAME NOT LIKE 'SYS$%'
87: AND NETWORK_NAME NOT LIKE 'SYS$%'
88: AND NAME <> default_xdb_service_name

Line 111: FROM dba_services

107: num_goal_none := num_goal_none + num_goal_null;
108:
109: -- Get the count for aq_ha_notifications
110: SELECT count(*) into num_aq_notifications
111: FROM dba_services
112: where
113: NAME NOT LIKE 'SYS$%'
114: AND NETWORK_NAME NOT LIKE 'SYS$%'
115: AND NAME <> default_xdb_service_name