6. Preparing Resources

This chapter explains how to prepare disks and estimate various resources.

Organization of this chapter

• 6.1 Preparing disks

• 6.2 Estimating the kernel parameters

• 6.3 Estimating the HADB server's memory requirement

• 6.4 Files that increase continuously over time when using the HADB server

• 6.5 Estimating the size of the server message log file

• 6.6 Estimating the size of error information (core file)

• 6.7 Estimating the size of HADB dump files

• 6.8 Estimating the size of a statistics log file

• 6.9 Estimating the size of an SQL trace file

• 6.10 Estimating the size of files required for the updated-row columnizing facility

• 6.11 Estimating the size of access path search information log files

• 6.12 Estimating the size of the system log files

• 6.13 Estimating the size of the archive directory

• 6.14 Estimating the size of the synonym dictionary file directory

• 6.15 Estimating the size of the audit trail directory

• 6.16 Estimating the size of the output-directory for common format audit trails

• 6.17 Estimating the size of the multi-node synonym dictionary storage directory

• 6.18 Estimating the size of a file output by the adbexport command

• 6.19 Estimating the size of files required to reorganize a base table

• 6.20 Estimating the size of an unload file

• 6.21 Estimating the size of the temporary work file for executing a command

• 6.22 Estimating the increase in the amount of data that occurs during command execution

• 6.23 Points to consider when executing commands concurrently

• 6.24 Points to consider when using the client-group facility

• 6.25 Estimates related to work tables

To Page Top