OptimizerStatisticsAdvisorExecution¶

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

Bases: object

The summary of the Optimizer Statistics Advisor execution, which includes information about the Managed Database and a comprehensive execution report.

Attributes

`STATUS_CANCELLED`	A constant which can be used with the status property of a OptimizerStatisticsAdvisorExecution.
`STATUS_COMPLETED`	A constant which can be used with the status property of a OptimizerStatisticsAdvisorExecution.
`STATUS_EXECUTING`	A constant which can be used with the status property of a OptimizerStatisticsAdvisorExecution.
`STATUS_FATAL_ERROR`	A constant which can be used with the status property of a OptimizerStatisticsAdvisorExecution.
`STATUS_INTERRUPTED`	A constant which can be used with the status property of a OptimizerStatisticsAdvisorExecution.
`database`	Gets the database of this OptimizerStatisticsAdvisorExecution.
`error_message`	Gets the error_message of this OptimizerStatisticsAdvisorExecution.
`execution_name`	[Required] Gets the execution_name of this OptimizerStatisticsAdvisorExecution.
`findings`	Gets the findings of this OptimizerStatisticsAdvisorExecution.
`report`	Gets the report of this OptimizerStatisticsAdvisorExecution.
`status`	[Required] Gets the status of this OptimizerStatisticsAdvisorExecution.
`status_message`	Gets the status_message of this OptimizerStatisticsAdvisorExecution.
`task_name`	[Required] Gets the task_name of this OptimizerStatisticsAdvisorExecution.
`time_end`	[Required] Gets the time_end of this OptimizerStatisticsAdvisorExecution.
`time_start`	[Required] Gets the time_start of this OptimizerStatisticsAdvisorExecution.

Methods

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

STATUS_CANCELLED = 'CANCELLED'¶: A constant which can be used with the status property of a OptimizerStatisticsAdvisorExecution. This constant has a value of “CANCELLED”

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

STATUS_EXECUTING = 'EXECUTING'¶: A constant which can be used with the status property of a OptimizerStatisticsAdvisorExecution. This constant has a value of “EXECUTING”

STATUS_FATAL_ERROR = 'FATAL_ERROR'¶: A constant which can be used with the status property of a OptimizerStatisticsAdvisorExecution. This constant has a value of “FATAL_ERROR”

STATUS_INTERRUPTED = 'INTERRUPTED'¶: A constant which can be used with the status property of a OptimizerStatisticsAdvisorExecution. This constant has a value of “INTERRUPTED”

__init__(**kwargs)¶

Initializes a new OptimizerStatisticsAdvisorExecution 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 OptimizerStatisticsAdvisorExecution.
report (oci.database_management.models.OptimizerStatisticsAdvisorExecutionReport) – The value to assign to the report property of this OptimizerStatisticsAdvisorExecution.
task_name (str) – The value to assign to the task_name property of this OptimizerStatisticsAdvisorExecution.
execution_name (str) – The value to assign to the execution_name property of this OptimizerStatisticsAdvisorExecution.
time_start (datetime) – The value to assign to the time_start property of this OptimizerStatisticsAdvisorExecution.
time_end (datetime) – The value to assign to the time_end property of this OptimizerStatisticsAdvisorExecution.
status (str) – The value to assign to the status property of this OptimizerStatisticsAdvisorExecution. Allowed values for this property are: “EXECUTING”, “COMPLETED”, “INTERRUPTED”, “CANCELLED”, “FATAL_ERROR”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
status_message (str) – The value to assign to the status_message property of this OptimizerStatisticsAdvisorExecution.
error_message (str) – The value to assign to the error_message property of this OptimizerStatisticsAdvisorExecution.
findings (int) – The value to assign to the findings property of this OptimizerStatisticsAdvisorExecution.

database¶

Gets the database of this OptimizerStatisticsAdvisorExecution.

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

error_message¶

Gets the error_message of this OptimizerStatisticsAdvisorExecution. The errors in the Optimizer Statistics Advisor execution, if any.

Returns:	The error_message of this OptimizerStatisticsAdvisorExecution.
Return type:	str

execution_name¶

[Required] Gets the execution_name of this OptimizerStatisticsAdvisorExecution. The name of the Optimizer Statistics Advisor execution.

Returns:	The execution_name of this OptimizerStatisticsAdvisorExecution.
Return type:	str

findings¶

Gets the findings of this OptimizerStatisticsAdvisorExecution. The number of findings generated by the Optimizer Statistics Advisor execution.

Returns:	The findings of this OptimizerStatisticsAdvisorExecution.
Return type:	int

report¶

Gets the report of this OptimizerStatisticsAdvisorExecution.

Returns:	The report of this OptimizerStatisticsAdvisorExecution.
Return type:	oci.database_management.models.OptimizerStatisticsAdvisorExecutionReport

status¶

[Required] Gets the status of this OptimizerStatisticsAdvisorExecution. The status of the Optimizer Statistics Advisor execution.

Allowed values for this property are: “EXECUTING”, “COMPLETED”, “INTERRUPTED”, “CANCELLED”, “FATAL_ERROR”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

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

status_message¶

Gets the status_message of this OptimizerStatisticsAdvisorExecution. The Optimizer Statistics Advisor execution status message, if any.

Returns:	The status_message of this OptimizerStatisticsAdvisorExecution.
Return type:	str

task_name¶

[Required] Gets the task_name of this OptimizerStatisticsAdvisorExecution. The name of the Optimizer Statistics Advisor task.

Returns:	The task_name of this OptimizerStatisticsAdvisorExecution.
Return type:	str

time_end¶

[Required] Gets the time_end of this OptimizerStatisticsAdvisorExecution. The end time of the time range to retrieve the Optimizer Statistics Advisor execution of a Managed Database in UTC in ISO-8601 format, which is “yyyy-MM-dd’T’hh:mm:ss.sss’Z’”.

Returns:	The time_end of this OptimizerStatisticsAdvisorExecution.
Return type:	datetime

time_start¶

[Required] Gets the time_start of this OptimizerStatisticsAdvisorExecution. The start time of the time range to retrieve the Optimizer Statistics Advisor execution of a Managed Database in UTC in ISO-8601 format, which is “yyyy-MM-dd’T’hh:mm:ss.sss’Z’”.

Returns:	The time_start of this OptimizerStatisticsAdvisorExecution.
Return type:	datetime