VIEW: SYS.DBA_REGISTRY

Source

View Text - Preformatted

SELECT r.cid, r.cname, r.version,
       SUBSTR(dbms_registry.status_name(r.status),1,11),
       TO_CHAR(r.modified,'DD-MON-YYYY HH24:MI:SS'),
       r.namespace, i.name, s.name, r.vproc,
       DECODE(bitand(r.flags,1),1,'REQUIRED',NULL), r.pid,
       dbms_registry.schema_list_string(r.cid)
FROM registry$ r, user$ s, user$ i
WHERE r.schema# = s.user# AND r.invoker#=i.user#

View Text - HTML Formatted

SELECT R.CID
, R.CNAME
, R.VERSION
, SUBSTR(DBMS_REGISTRY.STATUS_NAME(R.STATUS)
, 1
, 11)
, TO_CHAR(R.MODIFIED
, 'DD-MON-YYYY HH24:MI:SS')
, R.NAMESPACE
, I.NAME
, S.NAME
, R.VPROC
, DECODE(BITAND(R.FLAGS
, 1)
, 1
, 'REQUIRED'
, NULL)
, R.PID
, DBMS_REGISTRY.SCHEMA_LIST_STRING(R.CID) FROM REGISTRY$ R
, USER$ S
, USER$ I WHERE R.SCHEMA# = S.USER#
AND R.INVOKER#=I.USER#