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.

property database

Gets the database of this OptimizerStatisticsAdvisorExecution.

Returns

The database of this OptimizerStatisticsAdvisorExecution.

Return type

oci.database_management.models.OptimizerDatabase

property 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

property 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

property 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

property report

Gets the report of this OptimizerStatisticsAdvisorExecution.

Returns

The report of this OptimizerStatisticsAdvisorExecution.

Return type

oci.database_management.models.OptimizerStatisticsAdvisorExecutionReport

property 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

property 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

property 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

property 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

property 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