Skip to content

Instantly share code, notes, and snippets.

@dotmaik1

dotmaik1/alertlog: Alert log messages and timestamp.sql

Created October 6, 2016 17:19
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dotmaik1/7cf665c8a218d6bfd48e696a9b6d4e91 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dotmaik1/7cf665c8a218d6bfd48e696a9b6d4e91 to your computer and use it in GitHub Desktop.
Download ZIP
Alert log messages and timestamp
Raw
alertlog: Alert log messages and timestamp.sql
SET linesize 160 pagesize 200
col RECORD_ID FOR 9999999 head ID
col ORIGINATING_TIMESTAMP FOR a20 head DATE
col MESSAGE_TEXT FOR a120 head Message
SELECT
record_id,
to_char(originating_timestamp,'DD.MM.YYYY HH24:MI:SS'),
message_text
FROM
x$dbgalertext;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment