Output file format

By default, the text files contain lines of output, where each column is delimited by a space (ASCII character 0x20). Character values are quoted (“”) and numeric values represent the number of bytes and are raw numbers. You can modify the separator by specifying an alternative with the -fieldsep parameter, as shown:

proutil db-name -C dbanalys -csoutput -fieldsep sep-value

Acceptable values for sep-value are:

  • Any ASCII character between 0x21 and 0x7E
  • sp — to denote a space (the default)
  • tab — to denote a the TAB character (<\t> or ASCII character 0x09)

By default, the text files contain only data. If you want to add column headings, you can add the parameter -verbose to the command line, as shown:

proutil db-name -C dbanalys -csoutput -verbose

The resulting output file contains column headings in the first line.

The contents of the files are described in the following table.

Table 1. Text file contents for -csoutput
File type Column header Data type
Chain (dbname.ch.txt) Time Stamp Datetime-tz
DBUID Character
DB name Character
Area Character
Area # Integer
Partition Type Character
Tenancy Character
Tenancy # Integer
Partition Policy Character
Partition Character
Partition # Integer
Object type Character
Owner Character
Object Character
Object # Integer
Chain Type Character
Num Blocks Integer
Index (dbname.ix.txt) Time Stamp Datetime-tz
DBUID Character
DB name Character
Area Character
Area # Integer
Partition Type Character
Tenancy Character
Tenancy # Integer
Partition Policy Character
Partition Character
Partition # Integer
Owner Character
Table Character
Table # Integer
Index Character
Index # Integer
State Logical (1 or 0)
Fields Integer
Levels Integer
Blocks Int64
Size Integer
Utilization Decimal
Factor Decimal
Table (dbname.tab.txt) Time Stamp Datetime-tz
DBUID Character
DB name Character
Area Character
Area # Integer
Partition Type Character
Tenancy Character
Tenancy # Integer
Partition Policy Character
Partition Character
Partition # Integer
Owner Character
Table Character
Table # Integer
Records Integer
Size Integer
Min Integer
Max Integer
Mean Integer
Frag Count Integer
Frag Factor Decimal
Scatter Factor Decimal
LOB (dbname.lob.txt) Time Stamp Datetime-tz
DBUID Character
DB name Character
Area Character
Area # Integer
Partition Type Character
Tenancy Character
Tenancy # Integer
Partition Policy Character
Partition Character
Partition # Integer
Owner Character
Table Character
Table # Integer
Field Character
LOB Obj # Integer
LOBs Integer
Size Int64
Min Decimal
Max Decimal
Mean Decimal
Block (dbname.block.txt) Time Stamp Datetime-tz
DBUID Character
DB name Character
Area Character
Area # Integer
Block Type Character
Num Blocks Int64

Additional information to note about the contents of the text files:

  • Totals are not reported
  • The time stamp of each row is identical, indicating that each row came from a single run of the analysis
  • The DBUID is provided to identify rows if the output from multiple sources is loaded into a trending database
  • The CHANALYS output does NOT contain the dbkey information, it only include the chain analysis summary information as in the dbanalys report.