The format for database server audit records has the following parts:
Table 4 shows the format of the database server audit records for Dynamic Server.
ONLN | date and time | hostname or
hostname. domain.ext |
pid | database
server name |
user
name |
errno | event
mnemonic |
Additional
Fields |
---|---|---|---|---|---|---|---|---|
ONLN | 1998-07-28 15:43:00.000 | turk | 4549 | khan | jazt | 0 | CRDB | dbsch |
ONLN | 1998-07-28 15:43:18.000 | turk | 4549 | khan | jazt | 0 | ACTB | dbsch:jazt:v1:103 |
ONLN | 1998-07-28 15:43:19.000 | turk | 4549 | khan | jazt | 0 | CLDB | dbsh |
ONLN | 1998-07-28 15:43:21.000 | turk | 4549 | khan | jazt | 0 | ALFR |
local:109:-:-:4:4: db1,db2,db3, rootdbs |
ONLN | 1998-07-28 15:43:28.000 | turk | 4549 | khan | jazt | 0 | ALFR |
local:109:aa5x:-: 32:4: db1,db2 |
ONLN | 1998-07-28 15:43:29.000 | turk | 4549 | khan | jazt | 0 | STDS | 2:- |
ONLN | 1998-07-28 15:43:29.000 | turk | 4549 | khan | jazt | 0 | STPR | 100 |
.
. . |
.
. . |
.
. . |
.
. . |
.
. . |
.
. . |
.
. . |
.
. . |
.
. . |
For operating-system-managed auditing on UNIX, the database server audit record is an additional field for the operating-system audit record. Appendix A. Audit Events lists the audit-event fields.
For Extended Parallel Server, audit records appear in the format shown in Table 5.
XPS | coserver
id |
datetime | host
name |
PID | database server name | username | errno | event
mnemonic |
additional fields |
---|---|---|---|---|---|---|---|---|---|
xps | 2 |
2000-01-29 03:23:51.000 |
smart | 1752 | dragon | sunny | 0 | ONST | - |
xps | 2 |
2000-01-29 03:23:53.000 |
smart | 1754 | dragon | sunny | 0 | STSN | |
xps | 2 |
2000-01-29 03:23:53.000 |
smart | 1754 | dragon | sunny | 0 | OPDB |
sysmaster: 0:- |
XPS | 2 |
2000-01-29 03:23:53.000 |
smart | 1754 | dragon | sunny | 0 | CLDB | sysmaster |
XPS | 2 |
2000-01-29 03:24:44.000 |
smart | 964 | dragon | sunny | 0 | ONST | - |
XPS | 2 |
2000-01-29 03:24:46.000 |
smart | 964 | dragon | sunny | 0 | ONST | -d |
.
. . |
.
. . |
.
. . |
.
. . |
.
. . |
.
. . |
.
. . |
.
. . |
.
. . |
.
. . |
The output for Extended Parallel Server includes the following fields that are different from the output for Dynamic Server: