Thursday, May 14, 2009

Oracle 11g - Alert Log (X$DBGALERTEXT)

Today, i would like to share one new feature of Oracle 11g which i have come across recently.

In Oracle 11g, gives us a x$dbgalertext fixed table that maps to the alert log file, and allowing us to write SQL queries against it. It is very good news for Oracle Developers; becuase they dont have to depend on DBA's to view the alert log content.


SQL> desc x$dbgalertext

Name                       Null? Type
-------------------------- ----- ---------------------------
DDR                              RAW(4)
INDX                             NUMBER
INST_ID                          NUMBER
ORIGINATING_TIMESTAMP            TIMESTAMP(3) WITH TIME ZONE
NORMALIZED_TIMESTAMP             TIMESTAMP(3) WITH TIME ZONE
ORGANIZATION_ID                  VARCHAR2(64)
COMPONENT_ID                     VARCHAR2(64)
HOST_ID                          VARCHAR2(64)
HOST_ADDRESS                     VARCHAR2(16)
MESSAGE_TYPE                     NUMBER
MESSAGE_LEVEL                    NUMBER
MESSAGE_ID                       VARCHAR2(64)
MESSAGE_GROUP                    VARCHAR2(64)
CLIENT_ID                        VARCHAR2(64)
MODULE_ID                        VARCHAR2(64)
PROCESS_ID                       VARCHAR2(32)
THREAD_ID                        VARCHAR2(64)
USER_ID                          VARCHAR2(64)
INSTANCE_ID                      VARCHAR2(64)
DETAILED_LOCATION                VARCHAR2(160)
PROBLEM_KEY                      VARCHAR2(64)
UPSTREAM_COMP_ID                 VARCHAR2(100)
DOWNSTREAM_COMP_ID               VARCHAR2(100)
EXECUTION_CONTEXT_ID             VARCHAR2(100)
EXECUTION_CONTEXT_SEQUENCE       NUMBER
ERROR_INSTANCE_ID                NUMBER
ERROR_INSTANCE_SEQUENCE          NUMBER
VERSION                          NUMBER
MESSAGE_TEXT                     VARCHAR2(2048)
MESSAGE_ARGUMENTS                VARCHAR2(128)
SUPPLEMENTAL_ATTRIBUTES          VARCHAR2(128)
SUPPLEMENTAL_DETAILS             VARCHAR2(128)
PARTITION                        NUMBER
RECORD_ID                        NUMBER

Out of all attributes from x$dbgalertext, MESSAGE_TEXT attribute is the key here. It contains the alert log conent. Have nice time.

Please post your comments (if any).

1 comment:

Anonymous said...

And why would the developers view the alert log?