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

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1759612203, '216.73.216.149', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/installed/dynamic-performance-views/diag/alert_ext/index(80): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78