VIEW: SYS.USER_STORED_SETTINGS

Source

View Text - Preformatted

SELECT object_name, object_id, object_type, param_name, param_value,
       origin_con_id
  from NO_ROOT_SW_FOR_LOCAL(int$dba_stored_settings)
 where OWNER = SYS_CONTEXT('USERENV', 'CURRENT_USER')

View Text - HTML Formatted

SELECT OBJECT_NAME
, OBJECT_ID
, OBJECT_TYPE
, PARAM_NAME
, PARAM_VALUE
, ORIGIN_CON_ID
FROM NO_ROOT_SW_FOR_LOCAL(INT$DBA_STORED_SETTINGS)
WHERE OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER')