Databases Reference
In-Depth Information
As the contents of the
alert.log
end up in a temporary table, more than one DBA
can query it at the same time, or restrict the DBA's accessibilities. There is no need to
manage the purge and maintenance of the table after the session has ended, it can be
indexed and there is little overhead by means of this procedure. More over, as this is
a temporary object, minimum redo log information is generated.
Once the external
ALERT_LOG
and the temporary
ALERT_LOG
tables have been
created, it is possible to perform, not only filters by date (provided by Enterprise
Manager) but also any query against the
alert.log
file.
SELECT TIMESTAMP, TEXT_LINE
FROM TMP_ALERT_LOG
WHERE TIMESTAMP IN (
SELECT TIMESTAMP
FROM TMP_ALERT_LOG
WHERE TEXT_LINE LIKE 'ORA-%'
)
AND TIMESTAMP BETWEEN SYSDATE-30 AND SYSDATE
ORDER BY LINE_NO;
Further treatment can be done on this concept to look for specific error messages,
analyze specific time frames and perform drill down analysis.
This procedure can be extended to read the trace files or any other text file from
the database.
Search WWH ::
Custom Search