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.

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

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

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

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

elapsed_time¶

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

Returns:	The elapsed_time of this SqlMetrics.
Return type:	int

executions¶

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

Returns:	The executions of this SqlMetrics.
Return type:	int