Query database returns medium and long performance statistics for the database and application. The statistics appear as tables in the MaxL output. To gather performance statistics, you must first enable statistics gathering using alter database <dbs-name> set performance statistics enabled. You also use alter database to return to zero the statistical persistence (length) and scope (granularity).
Collecting and analyzing performance statistics can help you understand whether the databases are in good running condition or could use modifications to improve performance.
Topics related to performance statistics: