Managing the database tables

Use the p4 dbstat command to display statistics on the internal state of the Helix Server database. For example,

$ p4 dbstat -a

You can also specify the name of a database file in your server’s root directory. This command is typically used in conjunction with Perforce Technical Support to estimate disk seeks due to sequential database scans.

Options allow you to display the following:

  • statistics for all tables
  • a page count, free pages, and percent free data for the specified table
  • a histogram showing distances between leaf pages
  • a report on the file sizes of database tables
Warning

Because p4 dbstat blocks write access to the database while it scans the tables, use this command with care. You will most often use this command when working with Perforce Technical Support.