Oracle: X$DBGALERTEXT

select
   alr.con_id                     con_id,
   alr.originating_timestamp      originating_timestamp,
-- alr.normalized_timestamp       normalized_timestamp,
   alr.message_text               message_text,
   alr.message_type               message_type,
   alr.detailed_location          detailed_location,       -- Location of a trace file with more information
   alr.call_stack                 call_stack,
   alr.message_level              message_level,
   alr.message_id                 message_id,
   alr.message_group              message_group,
   alr.problem_key                problem_key,
   alr.organization_id            organization_id,
   alr.component_id               component_id,
   alr.host_id                    host_id,
   alr.host_address               host_address,
   alr.upstream_comp_id           upstream_comp_id,
   alr.downstream_comp_id         downstream_comp_id,
   alr.execution_context_id       execution_context_id,
   alr.execution_context_sequence execution_context_sequence,
   alr.error_instance_id          error_instance_id,
   alr.error_instance_sequence    error_instance_sequence,
   alr.version                    version,
   alr.message_arguments          message_arguments,
   alr.supplemental_details       supplemental_details,
   alr.supplemental_attributes    supplemental_attributes,
   alr.client_id                  client_id,
   alr.module_id                  module_id,
   alr.process_id                 process_id,
   alr.thread_id                  thread_id,
   alr.instance_id                instance_id,
   alr.user_id                    user_id,
   alr.con_uid                    con_uid,
   alr.container_name             container_name,
   alr.oracle_process_id          oracle_process_id,
   alr.database_id                database_id,
   alr.sql_id                     sql_id,
   alr.session_id                 session_id,
   alr.impact_id                  impact_id,
   alr.impact_scope               impact_scope,
   alr.attention_id               attention_id,
   alr.id_suffix                  id_suffix,
   alr.operation_id               operation_id,
   alr.cause_text                 cause_text,
   alr.action_text                action_text,
   alr.flags                      flags,
   alr.partition                  partition,
   alr.record_id                  record_id,
   alr.indx                       indx,
   alr.inst_id                    inst_id
-- alr.addr                       addr
from
   x$dbgalertext alr
-- where
--    alr.call_stack is not null
order by
   alr.indx desc
;