SqlTuningSetSummary

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

Bases: object

The summary information of a SQL tuning set.

Attributes:

STATUS_BLOCKED

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

STATUS_BROKEN

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

STATUS_CHAIN_STALLED

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

STATUS_COMPLETED

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

STATUS_DISABLED

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

STATUS_FAILED

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

STATUS_REMOTE

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

STATUS_RESOURCE_UNAVAILABLE

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

STATUS_RETRY_SCHEDULED

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

STATUS_RUNNING

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

STATUS_SCHEDULED

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

STATUS_SUCCEEDED

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

description

Gets the description of this SqlTuningSetSummary.

error_message

Gets the error_message of this SqlTuningSetSummary.

id

Gets the id of this SqlTuningSetSummary.

name

[Required] Gets the name of this SqlTuningSetSummary.

owner

[Required] Gets the owner of this SqlTuningSetSummary.

scheduled_job_name

Gets the scheduled_job_name of this SqlTuningSetSummary.

statement_counts

Gets the statement_counts of this SqlTuningSetSummary.

status

Gets the status of this SqlTuningSetSummary.

time_created

Gets the time_created of this SqlTuningSetSummary.

time_last_modified

Gets the time_last_modified of this SqlTuningSetSummary.

Methods:

__init__(**kwargs)

Initializes a new SqlTuningSetSummary object with values from keyword arguments.

STATUS_BLOCKED = 'BLOCKED'

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

STATUS_BROKEN = 'BROKEN'

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

STATUS_CHAIN_STALLED = 'CHAIN_STALLED'

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

STATUS_COMPLETED = 'COMPLETED'

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

STATUS_DISABLED = 'DISABLED'

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

STATUS_FAILED = 'FAILED'

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

STATUS_REMOTE = 'REMOTE'

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

STATUS_RESOURCE_UNAVAILABLE = 'RESOURCE_UNAVAILABLE'

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

STATUS_RETRY_SCHEDULED = 'RETRY_SCHEDULED'

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

STATUS_RUNNING = 'RUNNING'

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

STATUS_SCHEDULED = 'SCHEDULED'

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

STATUS_SUCCEEDED = 'SUCCEEDED'

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

__init__(**kwargs)

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

Parameters
  • name (str) – The value to assign to the name property of this SqlTuningSetSummary.

  • owner (str) – The value to assign to the owner property of this SqlTuningSetSummary.

  • description (str) – The value to assign to the description property of this SqlTuningSetSummary.

  • statement_counts (int) – The value to assign to the statement_counts property of this SqlTuningSetSummary.

  • id (int) – The value to assign to the id property of this SqlTuningSetSummary.

  • time_created (datetime) – The value to assign to the time_created property of this SqlTuningSetSummary.

  • time_last_modified (datetime) – The value to assign to the time_last_modified property of this SqlTuningSetSummary.

  • status (str) – The value to assign to the status property of this SqlTuningSetSummary. Allowed values for this property are: “DISABLED”, “RETRY_SCHEDULED”, “SCHEDULED”, “BLOCKED”, “RUNNING”, “COMPLETED”, “BROKEN”, “FAILED”, “REMOTE”, “RESOURCE_UNAVAILABLE”, “SUCCEEDED”, “CHAIN_STALLED”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

  • scheduled_job_name (str) – The value to assign to the scheduled_job_name property of this SqlTuningSetSummary.

  • error_message (str) – The value to assign to the error_message property of this SqlTuningSetSummary.

property description

Gets the description of this SqlTuningSetSummary. The description of the SQL tuning set.

Returns

The description of this SqlTuningSetSummary.

Return type

str

property error_message

Gets the error_message of this SqlTuningSetSummary. Latest execution error of the plsql that was submitted as a scheduler job.

Returns

The error_message of this SqlTuningSetSummary.

Return type

str

property id

Gets the id of this SqlTuningSetSummary. The unique Sql tuning set identifier. This is not OCID.

Returns

The id of this SqlTuningSetSummary.

Return type

int

property name

[Required] Gets the name of this SqlTuningSetSummary. The name of the SQL tuning set.

Returns

The name of this SqlTuningSetSummary.

Return type

str

property owner

[Required] Gets the owner of this SqlTuningSetSummary. The owner of the SQL tuning set.

Returns

The owner of this SqlTuningSetSummary.

Return type

str

property scheduled_job_name

Gets the scheduled_job_name of this SqlTuningSetSummary. Name of the Sql tuning set scheduler job.

Returns

The scheduled_job_name of this SqlTuningSetSummary.

Return type

str

property statement_counts

Gets the statement_counts of this SqlTuningSetSummary. The number of SQL statements in the SQL tuning set.

Returns

The statement_counts of this SqlTuningSetSummary.

Return type

int

property status

Gets the status of this SqlTuningSetSummary. Current status of the Sql tuning set.

Allowed values for this property are: “DISABLED”, “RETRY_SCHEDULED”, “SCHEDULED”, “BLOCKED”, “RUNNING”, “COMPLETED”, “BROKEN”, “FAILED”, “REMOTE”, “RESOURCE_UNAVAILABLE”, “SUCCEEDED”, “CHAIN_STALLED”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns

The status of this SqlTuningSetSummary.

Return type

str

property time_created

Gets the time_created of this SqlTuningSetSummary. The created time of the Sql tuning set.

Returns

The time_created of this SqlTuningSetSummary.

Return type

datetime

property time_last_modified

Gets the time_last_modified of this SqlTuningSetSummary. Last modified time of the Sql tuning set.

Returns

The time_last_modified of this SqlTuningSetSummary.

Return type

datetime