PrintStatistics

Boolean

false

Purpose

The PrintStatistics parameter, when set to true, causes database usage statistics to be output to a file when the database is closed. Persistent database statistics are output to the pdb_statistics.log file. By default, the printing of statistics is disabled.

New statistics are always appended to an existing statistics file.

Parameter is read when …

The database server node is initialized; for example, when you restart the database server.

Hints

Set this parameter to true if you require database statistics for the purposes of tuning or performance analysis.

When using statistics output to the pdb_statistics.log file, note that a non‑zero Aborted transactions value indicates that transactions are overflowing the client cache and aborting, which impacts on performance. If this figure is too high, investigate why this is happening in your application. This value should be a low number or zero (0).