12.1.3 Estimating the size of audit trail data
To estimate the disk space required by the audit trail facility, you first need to determine how much audit trail data the HADB server will output.
Use one of the following methods to determine the size of the audit trail data:
-
Check how much audit trail data is output in a small-scale test environment with the audit trail facility enabled
-
Estimate the amount of audit trail data based on the expected use of the HADB server and the database operations that are likely to be performed
The amount of audit trail data that is generated varies widely depending on the HADB server environment and on the SQL statements, commands, and other operations executed by users. For this reason, we recommend that you use the first of these methods. If you are unable to prepare a test environment, use the second method. When using the second method, determine the size of audit trail data according to the following table:
|
No. |
Example of audit target event |
Estimated size of audit trail data (KB) |
|---|---|---|
|
1 |
HADB server startup |
4 |
|
2 |
HADB server termination |
1 |
|
3 |
Connection to HADB server# |
1 |
|
4 |
Disconnection from HADB server# |
1 |
|
5 |
SQL statement execution |
2 + size-of-SQL-statement |
|
6 |
Command execution |
1 |
- #
-
Generated when the corresponding command is executed.
The following is an example of using the second method to determine the size of audit trail data:
- ■ Example of using method 2 to determine the size of audit trail data
-
Suppose that the HADB server is being used under the following conditions:
-
The HADB server is restarted once per day (a process that involves stopping and then starting the HADB server)
-
A 2 KB SQL statement is executed twice per connection (with one connection occurring each second)
-
Audit trails are output for mandatory audit events and optional audit events
The estimated size of audit trail data for one day (86,400 seconds) of activity under these conditions is as follows:
Formula
estimated-size-of-audit-trail-data = 4 KB + 1 KB + (1 KB + (2 KB + 2 KB) × 2 + 1 KB) × 86,400 seconds = 864,005 KB/dayThe estimated size of the audit trail data output per day under these conditions is 864,005 KB (or approximately 850 MB).
-