Database Administrator's Guide

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