OptimizerStatisticsCollectionOperation¶

class oci.database_management.models.OptimizerStatisticsCollectionOperation(**kwargs)¶

Bases: object

The summary of the Optimizer Statistics Collection tasks, which includes details of the Managed Database and the execution.

Attributes

`STATUS_COMPLETED`	A constant which can be used with the status property of a OptimizerStatisticsCollectionOperation.
`STATUS_FAILED`	A constant which can be used with the status property of a OptimizerStatisticsCollectionOperation.
`STATUS_IN_PROGRESS`	A constant which can be used with the status property of a OptimizerStatisticsCollectionOperation.
`STATUS_TIMED_OUT`	A constant which can be used with the status property of a OptimizerStatisticsCollectionOperation.
`STATUS_UNKNOWN`	A constant which can be used with the status property of a OptimizerStatisticsCollectionOperation.
`completed_count`	Gets the completed_count of this OptimizerStatisticsCollectionOperation.
`database`	Gets the database of this OptimizerStatisticsCollectionOperation.
`duration_in_seconds`	[Required] Gets the duration_in_seconds of this OptimizerStatisticsCollectionOperation.
`end_time`	[Required] Gets the end_time of this OptimizerStatisticsCollectionOperation.
`failed_count`	Gets the failed_count of this OptimizerStatisticsCollectionOperation.
`id`	[Required] Gets the id of this OptimizerStatisticsCollectionOperation.
`in_progress_count`	Gets the in_progress_count of this OptimizerStatisticsCollectionOperation.
`job_name`	[Required] Gets the job_name of this OptimizerStatisticsCollectionOperation.
`operation_name`	[Required] Gets the operation_name of this OptimizerStatisticsCollectionOperation.
`start_time`	[Required] Gets the start_time of this OptimizerStatisticsCollectionOperation.
`status`	[Required] Gets the status of this OptimizerStatisticsCollectionOperation.
`target`	[Required] Gets the target of this OptimizerStatisticsCollectionOperation.
`tasks`	Gets the tasks of this OptimizerStatisticsCollectionOperation.
`timed_out_count`	Gets the timed_out_count of this OptimizerStatisticsCollectionOperation.
`total_objects_count`	Gets the total_objects_count of this OptimizerStatisticsCollectionOperation.

Methods

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

STATUS_COMPLETED = 'COMPLETED'¶: A constant which can be used with the status property of a OptimizerStatisticsCollectionOperation. This constant has a value of “COMPLETED”

STATUS_FAILED = 'FAILED'¶: A constant which can be used with the status property of a OptimizerStatisticsCollectionOperation. This constant has a value of “FAILED”

STATUS_IN_PROGRESS = 'IN_PROGRESS'¶: A constant which can be used with the status property of a OptimizerStatisticsCollectionOperation. This constant has a value of “IN_PROGRESS”

STATUS_TIMED_OUT = 'TIMED_OUT'¶: A constant which can be used with the status property of a OptimizerStatisticsCollectionOperation. This constant has a value of “TIMED_OUT”

STATUS_UNKNOWN = 'UNKNOWN'¶: A constant which can be used with the status property of a OptimizerStatisticsCollectionOperation. This constant has a value of “UNKNOWN”

__init__(**kwargs)¶

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

Parameters:

database (oci.database_management.models.OptimizerDatabase) – The value to assign to the database property of this OptimizerStatisticsCollectionOperation.
tasks (list[oci.database_management.models.OptimizerStatisticsOperationTask]) – The value to assign to the tasks property of this OptimizerStatisticsCollectionOperation.
id (int) – The value to assign to the id property of this OptimizerStatisticsCollectionOperation.
operation_name (str) – The value to assign to the operation_name property of this OptimizerStatisticsCollectionOperation.
target (str) – The value to assign to the target property of this OptimizerStatisticsCollectionOperation.
job_name (str) – The value to assign to the job_name property of this OptimizerStatisticsCollectionOperation.
status (str) – The value to assign to the status property of this OptimizerStatisticsCollectionOperation. Allowed values for this property are: “IN_PROGRESS”, “COMPLETED”, “FAILED”, “TIMED_OUT”, “UNKNOWN”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
start_time (str) – The value to assign to the start_time property of this OptimizerStatisticsCollectionOperation.
end_time (str) – The value to assign to the end_time property of this OptimizerStatisticsCollectionOperation.
duration_in_seconds (float) – The value to assign to the duration_in_seconds property of this OptimizerStatisticsCollectionOperation.
completed_count (int) – The value to assign to the completed_count property of this OptimizerStatisticsCollectionOperation.
in_progress_count (int) – The value to assign to the in_progress_count property of this OptimizerStatisticsCollectionOperation.
failed_count (int) – The value to assign to the failed_count property of this OptimizerStatisticsCollectionOperation.
timed_out_count (int) – The value to assign to the timed_out_count property of this OptimizerStatisticsCollectionOperation.
total_objects_count (int) – The value to assign to the total_objects_count property of this OptimizerStatisticsCollectionOperation.

completed_count¶

Gets the completed_count of this OptimizerStatisticsCollectionOperation. The number of objects for which statistics collection is completed.

Returns:	The completed_count of this OptimizerStatisticsCollectionOperation.
Return type:	int

database¶

Gets the database of this OptimizerStatisticsCollectionOperation.

Returns:	The database of this OptimizerStatisticsCollectionOperation.
Return type:	oci.database_management.models.OptimizerDatabase

duration_in_seconds¶

[Required] Gets the duration_in_seconds of this OptimizerStatisticsCollectionOperation. The time it takes to complete the operation (in seconds).

Returns:	The duration_in_seconds of this OptimizerStatisticsCollectionOperation.
Return type:	float

end_time¶

[Required] Gets the end_time of this OptimizerStatisticsCollectionOperation. The end time of the operation.

Returns:	The end_time of this OptimizerStatisticsCollectionOperation.
Return type:	str

failed_count¶

Gets the failed_count of this OptimizerStatisticsCollectionOperation. The number of objects for which statistics collection failed.

Returns:	The failed_count of this OptimizerStatisticsCollectionOperation.
Return type:	int

id¶

[Required] Gets the id of this OptimizerStatisticsCollectionOperation. The ID of the operation.

Returns:	The id of this OptimizerStatisticsCollectionOperation.
Return type:	int

in_progress_count¶

Gets the in_progress_count of this OptimizerStatisticsCollectionOperation. The number of objects for which statistics collection is in progress.

Returns:	The in_progress_count of this OptimizerStatisticsCollectionOperation.
Return type:	int

job_name¶

[Required] Gets the job_name of this OptimizerStatisticsCollectionOperation. The name of the job.

Returns:	The job_name of this OptimizerStatisticsCollectionOperation.
Return type:	str

operation_name¶

[Required] Gets the operation_name of this OptimizerStatisticsCollectionOperation. The name of the operation.

Returns:	The operation_name of this OptimizerStatisticsCollectionOperation.
Return type:	str

start_time¶

[Required] Gets the start_time of this OptimizerStatisticsCollectionOperation. The start time of the operation.

Returns:	The start_time of this OptimizerStatisticsCollectionOperation.
Return type:	str

status¶

[Required] Gets the status of this OptimizerStatisticsCollectionOperation. The status of the operation such as Completed, and Failed.

Allowed values for this property are: “IN_PROGRESS”, “COMPLETED”, “FAILED”, “TIMED_OUT”, “UNKNOWN”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The status of this OptimizerStatisticsCollectionOperation.
Return type:	str

target¶

[Required] Gets the target of this OptimizerStatisticsCollectionOperation. The target object type such as Table, Index, and Partition.

Returns:	The target of this OptimizerStatisticsCollectionOperation.
Return type:	str

tasks¶

Gets the tasks of this OptimizerStatisticsCollectionOperation. An array of Optimizer Statistics Collection task details.

Returns:	The tasks of this OptimizerStatisticsCollectionOperation.
Return type:	list[oci.database_management.models.OptimizerStatisticsOperationTask]

timed_out_count¶

Gets the timed_out_count of this OptimizerStatisticsCollectionOperation. The number of objects for which statistics collection timed out.

Returns:	The timed_out_count of this OptimizerStatisticsCollectionOperation.
Return type:	int

total_objects_count¶

Gets the total_objects_count of this OptimizerStatisticsCollectionOperation. The total number of objects for which statistics is collected. This number is the sum of all the objects with various statuses: completed, inProgress, failed, and timedOut.

Returns:	The total_objects_count of this OptimizerStatisticsCollectionOperation.
Return type:	int