in Oracle

Read Oracle database 10g alert logs from sql

This is for oracle database 10g, in 11g the table is prebuilt with another name

SELECT METRIC_LABEL, T.COLUMN_LABEL, T.ALERT_STATE, T.MESSAGE, T.COLLECTION_TIMESTAMP
FROM SYSMAN.MGMT$ALERT_CURRENT T