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
-