SHOW LOG

Purpose

Show diagnostic log messages.

Syntax and Description

show log [-l log_name] [-p "predicate_string"] [-term] [ [-tail [num] [-f]] ]

Table 17-17 describes the flags for SHOW LOG.


Table 17-17 Flags for SHOW LOG command

Flag Description

-l log_name

Name of the log to show.

If no log name is specified, then this command displays all messages from all diagnostic logs under the current ADR Home.

-p "predicate_string"

Use a SQL-like predicate string to show only the log entries for which the predicate is true. The predicate string must be enclosed in double quotation marks.

Table 17-18 lists the fields that can be used in the predicate string.

-term

Direct results to the terminal.

If this option is not specified, then this command opens the results in an editor. By default, it opens the results in emacs, but you can use the SET EDITOR command to open the results in other editors.

-tail [num] [-f]

Displays the most recent entries in the log.

Use the num option to display the last num entries in the log. If num is omitted, the last 10 entries are displayed.

If the -f option is given, after displaying the requested messages, the command does not return. Instead, it remains active and continuously displays new log entries to the terminal as they arrive in the log. You can use this command to perform live monitoring of the log. To terminate the command, press CTRL+C.



Table 17-18 Log Fields for SHOW LOG

Field Type

ORIGINATING_TIMESTAMP

timestamp

NORMALIZED_TIMESTAMP

timestamp

ORGANIZATION_ID

text(65)

COMPONENT_ID

text(65)

HOST_ID

text(65)

HOST_ADDRESS

text(17)

MESSAGE_TYPE

number

MESSAGE_LEVEL

number

MESSAGE_ID

text(65)

MESSAGE_GROUP

text(65)

CLIENT_ID

text(65)

MODULE_ID

text(65)

PROCESS_ID

text(33)

THREAD_ID

text(65)

USER_ID

text(65)

INSTANCE_ID

text(65)

DETAILED_LOCATION

text(161)

UPSTREAM_COMP_ID

text(101)

DOWNSTREAM_COMP_ID

text(101)

EXECUTION_CONTEXT_ID

text(101)

EXECUTION_CONTEXT_SEQUENCE

number

ERROR_INSTANCE_ID

number

ERROR_INSTANCE_SEQUENCE

number

MESSAGE_TEXT

text(2049)

MESSAGE_ARGUMENTS

text(129)

SUPPLEMENTAL_ATTRIBUTES

text(129)

SUPPLEMENTAL_DETAILS

text(4000)

PROBLEM_KEY

text(65)