...

• CPU time per query/task/cache operations
• Disk, I/O wait/read/write per query/task/cache operations
• Query parse time
• Time for waiting blocks
• User time per transaction
• Messages process timings
• I/O per data regions

This statistics will provide:

• Top query/operations by CPU time
• Top query/operations by IO time
• What operations use most resources?

Phase 1

On the first phase will be implemented:

• Profiling public API and default implementation
• Java API, CLI, JMX process management
• Gathering overall and time statistics of queries, tasks, cache operations, checkpoints and PME's.
• Tool to create the report

Phase 2

On the second phase will be investigated and implemented:

• Gathering CPU time per operation
• Gathering I/O wait time, read/write counting
• Time for waiting blocks per operation
• Display of these statistics in the report

Public API changes

The new interface will be added: ProfilingSpi.

...