PERFMON TIMERS
ADMIN COMMAND 'perfmon timers [ start | stop | list | clear ]'
Abbreviation: pmon timers
Produces information about execution times of database operations such as SQL execute and file operations for each user.
▪ start: Starts the timers and clears the existing counter values.
▪ stop: Stops the timers and keeps the current counter values.
▪ list: Lists the current counter values in the console window. Use
ADMIN COMMAND 'report report_name' to print the output to a file, see
REPORT.
▪ clear: Clears the current counter values.
The timer information is given in seconds. The values are cumulative since the last time one of the following commands was run:
ADMIN COMMAND 'perfmon timers start'
ADMIN COMMAND 'perfmon timers clear'
For more information and examples of the output, see
Listing execution times for database operations.
Go up to