About Database Alert Log
The Database Alert Log makes it possible for system administrators and installation
technicians to trace different activities in the database.
Contents
The Database Alert Log uses database triggers, Oracle Audit trails and a Scheduled
Task to transfer data between Audit trail and Database Alert Log.
There are three different ways to write to the Database Alert Log:
- Direct from a PL/SQL Package, usually as an Autonomous transaction.
- From a PL/SQL Package via a database trigger that catches what to log.
- Through Oracle Audit Trail (that holds data in AUD$ table), and is transferred
to Database Alert Log through a Scheduled Task.
Note: Using database triggers and Oracle Audit trail may generate some
overhead.
Essentially, the functionality exists to make trouble shooting and logging easier
if necessary.
It is possible to turn on or off every Database Alert Log Category independent
of each other.
There exists 5 more categories that should be
added.
- Server Errors
This category logs every error that occurs in the database.
Could be used to find errors that occur infrequently.
Uses database trigger.
- SQL Injection
Logs code that has been trapped as SQL Injection.
Built in as functions in database server code.
- Sessions
Logs every logon and logoff to the database.
Uses Oracle's Audit Trail and Scheduled Task to move data.
- Intrusions
Logs every failed logon attempt to the database.
Uses Oracle's Audit Trail and Scheduled Task to move data.
- Deployment
Logs timing over installation and upgrades of IFS Applications.
Built in as functions in deployment code.
Links