VIEW: SYS.PDB_PLUG_IN_VIOLATIONS

Source

View Text - Preformatted

select time, name, cause,
   decode(type#, 1, 'ERROR', 2, 'WARNING', 'UNDEFINED'), error#, line#, msg$,
   decode(status, 1, 'PENDING', 2, 'RESOLVED', 3, 'IGNORED', 'UNDEFINED'),
   action from pdb_alert$ where type# = 1 or type# = 2
order by time, name, status, line#

View Text - HTML Formatted

SELECT TIME
, NAME
, CAUSE
, DECODE(TYPE#
, 1
, 'ERROR'
, 2
, 'WARNING'
, 'UNDEFINED')
, ERROR#
, LINE#
, MSG$
, DECODE(STATUS
, 1
, 'PENDING'
, 2
, 'RESOLVED'
, 3
, 'IGNORED'
, 'UNDEFINED')
, ACTION
FROM PDB_ALERT$
WHERE TYPE# = 1 OR TYPE# = 2 ORDER BY TIME
, NAME
, STATUS
, LINE#