Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

Memory File Usage -m

The ctstat utility supports an option, -m, that when specified with the -vaf report option, causes ctstat to output the following additional memory file statistics:

  • phyrec - Last byte offset of file for non-memory file or current memory in use for memory file.
  • mhghbyt - Largest amount of memory used for memory file since file was created.
  • memcnt - Current number of memory records.
  • hghcnt - Largest number of memory records since file was created.

Example

# ctstat -vaf disk.dat mem.dat -h 1 -i 2 -m

r/s w/s entries locks l%h %m dlock recrd node t phyrec mhghbyt memcnt hghcnt filename

0 0 n/a 0 100 0 0 15 n/a V 1923110761 1923110761 19232 19232 mem.dat

0 0 3 0 0 0 0 128 n/a F 4096 0 0 0 disk.dat

TOCIndex