Updated on 2023-10-23 GMT+08:00

Load Profile

The following table lists metrics in the Load Profile report.

Table 1 Metrics in the Load Profile report

Metric

Description

DB Time(us)

Total elapsed time of a job.

CPU Time(us)

Total CPU time used for job running.

Redo size(blocks)

Size of the generated WAL (blocks).

Logical read (blocks)

Number of logical reads (blocks) on a table or an index.

Physical read (blocks)

Number of physical reads (blocks) on a table or an index.

Physical write (blocks)

Number of physical writes (blocks) on a table or an index.

Read IO requests

Number of times that a table or an index is read.

Write IO requests

Number of times that a table or an index is written.

Read IO (MB)

Table or index read size (MB).

Write IO (MB)

Table or index write size (MB).

Logons

Number of logins.

Executes (SQL)

Number of times the SQL statement is executed.

Rollbacks

Number of rolled-back transactions.

Transactions

Number of transactions.

SQL response time P95(us)

Response time of 95% SQL statements.

SQL response time P80(us)

Response time of 80% SQL statements.