SqlMetrics

class oci.database_management.models.SqlMetrics(**kwargs)

Bases: object

Metrics of the Sql in the Sql tuning set.

Methods:

__init__(**kwargs)

Initializes a new SqlMetrics object with values from keyword arguments.

Attributes:

buffer_gets

Gets the buffer_gets of this SqlMetrics.

cpu_time

Gets the cpu_time of this SqlMetrics.

direct_writes

Gets the direct_writes of this SqlMetrics.

disk_reads

Gets the disk_reads of this SqlMetrics.

elapsed_time

Gets the elapsed_time of this SqlMetrics.

executions

Gets the executions of this SqlMetrics.

__init__(**kwargs)

Initializes a new SqlMetrics object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters
  • cpu_time (int) – The value to assign to the cpu_time property of this SqlMetrics.

  • elapsed_time (int) – The value to assign to the elapsed_time property of this SqlMetrics.

  • buffer_gets (int) – The value to assign to the buffer_gets property of this SqlMetrics.

  • disk_reads (int) – The value to assign to the disk_reads property of this SqlMetrics.

  • direct_writes (int) – The value to assign to the direct_writes property of this SqlMetrics.

  • executions (int) – The value to assign to the executions property of this SqlMetrics.

property buffer_gets

Gets the buffer_gets of this SqlMetrics. Sum total number of buffer gets.

Returns

The buffer_gets of this SqlMetrics.

Return type

int

property cpu_time

Gets the cpu_time of this SqlMetrics. Total CPU time consumed by the Sql.

Returns

The cpu_time of this SqlMetrics.

Return type

int

property direct_writes

Gets the direct_writes of this SqlMetrics. Sum total number of direct path writes.

Returns

The direct_writes of this SqlMetrics.

Return type

int

property disk_reads

Gets the disk_reads of this SqlMetrics. Sum total number of disk reads.

Returns

The disk_reads of this SqlMetrics.

Return type

int

property elapsed_time

Gets the elapsed_time of this SqlMetrics. Elapsed time of the Sql.

Returns

The elapsed_time of this SqlMetrics.

Return type

int

property executions

Gets the executions of this SqlMetrics. Total executions of this SQL statement.

Returns

The executions of this SqlMetrics.

Return type

int