OptimizerStatisticsOperationTask

class oci.database_management.models.OptimizerStatisticsOperationTask(**kwargs)

Bases: object

The details of the Optimizer Statistics Collection task.

Attributes:

STATUS_COMPLETED

A constant which can be used with the status property of a OptimizerStatisticsOperationTask.

STATUS_FAILED

A constant which can be used with the status property of a OptimizerStatisticsOperationTask.

STATUS_IN_PROGRESS

A constant which can be used with the status property of a OptimizerStatisticsOperationTask.

STATUS_PENDING

A constant which can be used with the status property of a OptimizerStatisticsOperationTask.

STATUS_SKIPPED

A constant which can be used with the status property of a OptimizerStatisticsOperationTask.

STATUS_TIMED_OUT

A constant which can be used with the status property of a OptimizerStatisticsOperationTask.

TARGET_TYPE_COORDINATOR_TABLE

A constant which can be used with the target_type property of a OptimizerStatisticsOperationTask.

TARGET_TYPE_GLOBAL_TABLE

A constant which can be used with the target_type property of a OptimizerStatisticsOperationTask.

TARGET_TYPE_INDEX

A constant which can be used with the target_type property of a OptimizerStatisticsOperationTask.

TARGET_TYPE_INDEX_PARTITION

A constant which can be used with the target_type property of a OptimizerStatisticsOperationTask.

TARGET_TYPE_INDEX_SUBPARTITION

A constant which can be used with the target_type property of a OptimizerStatisticsOperationTask.

TARGET_TYPE_TABLE

A constant which can be used with the target_type property of a OptimizerStatisticsOperationTask.

TARGET_TYPE_TABLE_PARTITION

A constant which can be used with the target_type property of a OptimizerStatisticsOperationTask.

TARGET_TYPE_TABLE_SUBPARTITION

A constant which can be used with the target_type property of a OptimizerStatisticsOperationTask.

status

[Required] Gets the status of this OptimizerStatisticsOperationTask.

target

[Required] Gets the target of this OptimizerStatisticsOperationTask.

target_type

[Required] Gets the target_type of this OptimizerStatisticsOperationTask.

time_end

[Required] Gets the time_end of this OptimizerStatisticsOperationTask.

time_start

[Required] Gets the time_start of this OptimizerStatisticsOperationTask.

Methods:

__init__(**kwargs)

Initializes a new OptimizerStatisticsOperationTask object with values from keyword arguments.

STATUS_COMPLETED = 'COMPLETED'

A constant which can be used with the status property of a OptimizerStatisticsOperationTask. This constant has a value of “COMPLETED”

STATUS_FAILED = 'FAILED'

A constant which can be used with the status property of a OptimizerStatisticsOperationTask. This constant has a value of “FAILED”

STATUS_IN_PROGRESS = 'IN_PROGRESS'

A constant which can be used with the status property of a OptimizerStatisticsOperationTask. This constant has a value of “IN_PROGRESS”

STATUS_PENDING = 'PENDING'

A constant which can be used with the status property of a OptimizerStatisticsOperationTask. This constant has a value of “PENDING”

STATUS_SKIPPED = 'SKIPPED'

A constant which can be used with the status property of a OptimizerStatisticsOperationTask. This constant has a value of “SKIPPED”

STATUS_TIMED_OUT = 'TIMED_OUT'

A constant which can be used with the status property of a OptimizerStatisticsOperationTask. This constant has a value of “TIMED_OUT”

TARGET_TYPE_COORDINATOR_TABLE = 'COORDINATOR_TABLE'

A constant which can be used with the target_type property of a OptimizerStatisticsOperationTask. This constant has a value of “COORDINATOR_TABLE”

TARGET_TYPE_GLOBAL_TABLE = 'GLOBAL_TABLE'

A constant which can be used with the target_type property of a OptimizerStatisticsOperationTask. This constant has a value of “GLOBAL_TABLE”

TARGET_TYPE_INDEX = 'INDEX'

A constant which can be used with the target_type property of a OptimizerStatisticsOperationTask. This constant has a value of “INDEX”

TARGET_TYPE_INDEX_PARTITION = 'INDEX_PARTITION'

A constant which can be used with the target_type property of a OptimizerStatisticsOperationTask. This constant has a value of “INDEX_PARTITION”

TARGET_TYPE_INDEX_SUBPARTITION = 'INDEX_SUBPARTITION'

A constant which can be used with the target_type property of a OptimizerStatisticsOperationTask. This constant has a value of “INDEX_SUBPARTITION”

TARGET_TYPE_TABLE = 'TABLE'

A constant which can be used with the target_type property of a OptimizerStatisticsOperationTask. This constant has a value of “TABLE”

TARGET_TYPE_TABLE_PARTITION = 'TABLE_PARTITION'

A constant which can be used with the target_type property of a OptimizerStatisticsOperationTask. This constant has a value of “TABLE_PARTITION”

TARGET_TYPE_TABLE_SUBPARTITION = 'TABLE_SUBPARTITION'

A constant which can be used with the target_type property of a OptimizerStatisticsOperationTask. This constant has a value of “TABLE_SUBPARTITION”

__init__(**kwargs)

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

Parameters
  • target (str) – The value to assign to the target property of this OptimizerStatisticsOperationTask.

  • target_type (str) – The value to assign to the target_type property of this OptimizerStatisticsOperationTask. Allowed values for this property are: “TABLE”, “GLOBAL_TABLE”, “COORDINATOR_TABLE”, “TABLE_PARTITION”, “TABLE_SUBPARTITION”, “INDEX”, “INDEX_PARTITION”, “INDEX_SUBPARTITION”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

  • time_start (datetime) – The value to assign to the time_start property of this OptimizerStatisticsOperationTask.

  • time_end (datetime) – The value to assign to the time_end property of this OptimizerStatisticsOperationTask.

  • status (str) – The value to assign to the status property of this OptimizerStatisticsOperationTask. Allowed values for this property are: “PENDING”, “IN_PROGRESS”, “SKIPPED”, “TIMED_OUT”, “COMPLETED”, “FAILED”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

property status

[Required] Gets the status of this OptimizerStatisticsOperationTask. The status of the Optimizer Statistics Collection task.

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

Returns

The status of this OptimizerStatisticsOperationTask.

Return type

str

property target

[Required] Gets the target of this OptimizerStatisticsOperationTask. The name of the target object for which statistics are gathered.

Returns

The target of this OptimizerStatisticsOperationTask.

Return type

str

property target_type

[Required] Gets the target_type of this OptimizerStatisticsOperationTask. The type of target object.

Allowed values for this property are: “TABLE”, “GLOBAL_TABLE”, “COORDINATOR_TABLE”, “TABLE_PARTITION”, “TABLE_SUBPARTITION”, “INDEX”, “INDEX_PARTITION”, “INDEX_SUBPARTITION”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns

The target_type of this OptimizerStatisticsOperationTask.

Return type

str

property time_end

[Required] Gets the time_end of this OptimizerStatisticsOperationTask. The end time of the Optimizer Statistics Collection task.

Returns

The time_end of this OptimizerStatisticsOperationTask.

Return type

datetime

property time_start

[Required] Gets the time_start of this OptimizerStatisticsOperationTask. The start time of the Optimizer Statistics Collection task.

Returns

The time_start of this OptimizerStatisticsOperationTask.

Return type

datetime