ORACLE DATABASE AUDIT
Sawmill is a Oracle Database Audit log analyzer (it also supports the 1021 other log formats listed to the left).
It can process log files
in Oracle Database Audit format, and generate dynamic statistics from them,
analyzing and reporting events.
Sawmill can parse Oracle Database Audit logs, import them into a MySQL, Microsoft SQL Server, or Oracle database (or its own built-in database),
aggregate them, and generate dynamically filtered reports, all through a web interface.
Sawmill can perform Oracle Database Audit log analysis on any platform, including Windows, Linux, FreeBSD, OpenBSD, Mac OS, Solaris, other UNIX, and others.
Sawmill stores the following non-numerical fields in its database for Oracle Database Audit, generates reports for each field, and allows dynamic filtering on any combination of these fields:
| Field | | Internal Name |
|---|
| | date/time | | date_time |
| | session ID | | session_id |
| | entry ID | | entry_id |
| | statement | | statement |
| | user ID | | user_id |
| | terminal | | terminal |
| | action | | action |
| | return code | | return_code |
| | comment_text | | comment_text |
| | object creator | | obj_creator |
| | object name | | obj_name |
| | session actions | | ses_actions |
| | session thread ID | | ses_tid |
| | OS user ID | | os_user_id |
| | audit file | | audit_file |
| | oracle release | | oracle_release |
| | JServer release | | jserver_release |
| | oracle home | | oracle_home |
| | system name | | system_name |
| | node name | | oracle_node_name |
| | release | | release |
| | version | | version |
| | machine | | machine |
| | instance name | | instance_name |
| | redo thread | | redo_thread |
| | oracle process ID | | oracle_pid |
| | unix process ID | | unix_pid |
| | image | | oracle_image |
| | database user ID | | database_user |
| | privilege | | privilege |
| | status | | status |
Sawmill stores the following numerical fields in its database for Oracle Database Audit, aggregating them and including them as columns in most reports:
| Numerical Field | | Internal Name |
|---|
| | events | | events |
See Sawmill Features to learn more about Sawmill's options for viewing, customizing, filtering, exporting and scheduling Oracle Database Audit reports.
Sawmill also supports 1021 other log formats.
