Updated on 2024-06-03 GMT+08:00

Load Profile

Table 1 lists metrics in the Load Profile report.

Table 1 Metrics in the Load Profile report

Statistical Item

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).

Logins

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.