Search notes:

Oracle: V$DIAG_ALERT_EXT

select
   dae.record_id,
   dae.process_id,  
   to_char(dae.originating_timestamp, 'yyyy-mm-dd hh24:mi:ss') ts,
-- dae.normalized_timestamp,  
   dae.message_text,
   dae.detailed_location,
   dae.message_group,
   dae.message_id,
   dae.message_level,
   dae.message_type,
   dae.module_id,  
   dae.client_id,
   dae.con_id,
   dae.con_uid,
   dae.container_id,
   dae.container_name,
   dae.downstream_comp_id,
   dae.error_instance_id,
   dae.error_instance_sequence,
   dae.execution_context_id,
   dae.execution_context_sequence,
   dae.filename,
   dae.host_address,
   dae.host_id,
   dae.instance_id,
   dae.log_name,
   dae.message_arguments,
   dae.partition,
   dae.problem_key,
   dae.supplemental_attributes,
   dae.supplemental_details,
   dae.thread_id,
   dae.upstream_comp_id,
   dae.user_id,
   dae.version,
   dae.organization_id,  
   dae.component_id  
from
   sys.v_$diag_alert_ext dae
where
   dae.message_text != 'Maximum of 148 enabled roles exceeded for user SYS. Not loading all the roles.' || chr(10) and
   dae.message_text not like 'Resize operation completed for file# %'
order by
   dae.originating_timestamp desc
;

See also

Oracle Dynamic Performance Views

Index