SqlPlanInsightAggregation¶

class oci.opsi.models.SqlPlanInsightAggregation(**kwargs)¶

Bases: object

SQL execution plan Performance statistics.

Methods

__init__(**kwargs) Initializes a new SqlPlanInsightAggregation object with values from keyword arguments.

Attributes

`cpu_time_in_sec`	[Required] Gets the cpu_time_in_sec of this SqlPlanInsightAggregation.
`executions_count`	[Required] Gets the executions_count of this SqlPlanInsightAggregation.
`inefficient_wait_time_in_sec`	[Required] Gets the inefficient_wait_time_in_sec of this SqlPlanInsightAggregation.
`io_time_in_sec`	[Required] Gets the io_time_in_sec of this SqlPlanInsightAggregation.
`plan_hash`	[Required] Gets the plan_hash of this SqlPlanInsightAggregation.

__init__(**kwargs)¶

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

Parameters:

plan_hash (int) – The value to assign to the plan_hash property of this SqlPlanInsightAggregation.
io_time_in_sec (float) – The value to assign to the io_time_in_sec property of this SqlPlanInsightAggregation.
cpu_time_in_sec (float) – The value to assign to the cpu_time_in_sec property of this SqlPlanInsightAggregation.
inefficient_wait_time_in_sec (float) – The value to assign to the inefficient_wait_time_in_sec property of this SqlPlanInsightAggregation.
executions_count (int) – The value to assign to the executions_count property of this SqlPlanInsightAggregation.

cpu_time_in_sec¶

[Required] Gets the cpu_time_in_sec of this SqlPlanInsightAggregation. CPU Time in seconds

Returns:	The cpu_time_in_sec of this SqlPlanInsightAggregation.
Return type:	float

executions_count¶

[Required] Gets the executions_count of this SqlPlanInsightAggregation. Total number of executions

Returns:	The executions_count of this SqlPlanInsightAggregation.
Return type:	int

inefficient_wait_time_in_sec¶

[Required] Gets the inefficient_wait_time_in_sec of this SqlPlanInsightAggregation. Inefficient Wait Time in seconds

Returns:	The inefficient_wait_time_in_sec of this SqlPlanInsightAggregation.
Return type:	float

io_time_in_sec¶

[Required] Gets the io_time_in_sec of this SqlPlanInsightAggregation. IO Time in seconds

Returns:	The io_time_in_sec of this SqlPlanInsightAggregation.
Return type:	float

plan_hash¶

[Required] Gets the plan_hash of this SqlPlanInsightAggregation. Plan hash value for the SQL Execution Plan

Returns:	The plan_hash of this SqlPlanInsightAggregation.
Return type:	int