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 for a table or an index (number of blocks)

Physical read (blocks)

Number of physical reads for a table or an index (number of blocks)

Physical write (blocks)

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

Read IO requests

Number of reads for a table or an index

Write IO requests

Number of writes for a table or an index

Read IO (MB)

Size of reads for a table or an index (in MB)

Write IO (MB)

Size of writes for a table or an index (in MB)

Logons

Number of logins

Executes (SQL)

Number of times SQL statements are 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