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,
decode(GOAL, 0, 'NONE', 1, 'SERVICE_TIME', 2, 'THROUGHPUT', NULL)
GOAL,
decode(bitand(FLAGS, 2), 2, 'Y', 'N') DTP,
decode(bitand(FLAGS, 1), 1, 'YES', 0, 'NO') ENABLED,
decode(bitand(NVL(FLAGS,0), 4), 4, 'YES',
0, 'NO', 'NO') AQ_HA_NOTIFICATIONS,
decode(bitand(NVL(FLAGS,0), 8), 8, 'LONG', 0, 'SHORT', 'SHORT') CLB_GOAL,
EDITION,
decode(bitand(NVL(FLAGS,0), 32), 32, 'YES', 0, 'NO', 'NO') COMMIT_OUTCOME,
RETENTION_TIMEOUT,
REPLAY_INITIATION_TIMEOUT,
SESSION_STATE_CONSISTENCY,
decode(bitand(NVL(FLAGS,0), 64), 64, 'YES', 0, 'NO', 'NO') GLOBAL_SERVICE,
PDB,
SQL_TRANSLATION_PROFILE,
MAX_LAG_TIME,
GSM_FLAGS
from service$
where DELETION_DATE is null
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
,
DECODE(GOAL
, 0
, 'NONE'
, 1
, 'SERVICE_TIME'
, 2
, 'THROUGHPUT'
, NULL)
GOAL
,
DECODE(BITAND(FLAGS
, 2)
, 2
, 'Y'
, 'N') DTP
,
DECODE(BITAND(FLAGS
, 1)
, 1
, 'YES'
, 0
, 'NO') ENABLED
,
DECODE(BITAND(NVL(FLAGS
, 0)
, 4)
, 4
, 'YES'
,
0
, 'NO'
, 'NO') AQ_HA_NOTIFICATIONS
,
DECODE(BITAND(NVL(FLAGS
, 0)
, 8)
, 8
, 'LONG'
, 0
, 'SHORT'
, 'SHORT') CLB_GOAL
,
EDITION
,
DECODE(BITAND(NVL(FLAGS
, 0)
, 32)
, 32
, 'YES'
, 0
, 'NO'
, 'NO') COMMIT_OUTCOME
,
RETENTION_TIMEOUT
,
REPLAY_INITIATION_TIMEOUT
,
SESSION_STATE_CONSISTENCY
,
DECODE(BITAND(NVL(FLAGS
, 0)
, 64)
, 64
, 'YES'
, 0
, 'NO'
, 'NO') GLOBAL_SERVICE
,
PDB
,
SQL_TRANSLATION_PROFILE
,
MAX_LAG_TIME
,
GSM_FLAGS
FROM SERVICE$
WHERE DELETION_DATE IS NULL
|
|
|