SqlTuningSet

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

Bases: object

Details of the Sql tuning set.

Attributes:

ALL_SQL_STATEMENTS_FETCHED_NO

A constant which can be used with the all_sql_statements_fetched property of a SqlTuningSet.

ALL_SQL_STATEMENTS_FETCHED_YES

A constant which can be used with the all_sql_statements_fetched property of a SqlTuningSet.

STATUS_BLOCKED

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

STATUS_BROKEN

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

STATUS_CHAIN_STALLED

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

STATUS_COMPLETED

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

STATUS_DISABLED

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

STATUS_FAILED

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

STATUS_REMOTE

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

STATUS_RESOURCE_UNAVAILABLE

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

STATUS_RETRY_SCHEDULED

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

STATUS_RUNNING

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

STATUS_SCHEDULED

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

STATUS_SUCCEEDED

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

all_sql_statements_fetched

Gets the all_sql_statements_fetched of this SqlTuningSet. In OCI database management, there is a limit to fetch only 2000 rows. This flag indicates whether all Sql statements of this Sql tuning set matching the filter criteria are fetched or not. Possible values are 'Yes' or 'No' - Yes - All Sql statements matching the filter criteria are fetched. - No - There are more Sql statements matching the fitler criteria. User should fine tune the filter criteria to narrow down the result set.

description

Gets the description of this SqlTuningSet.

error_message

Gets the error_message of this SqlTuningSet.

id

Gets the id of this SqlTuningSet.

name

[Required] Gets the name of this SqlTuningSet.

owner

[Required] Gets the owner of this SqlTuningSet.

scheduled_job_name

Gets the scheduled_job_name of this SqlTuningSet.

sql_list

Gets the sql_list of this SqlTuningSet.

statement_count

Gets the statement_count of this SqlTuningSet.

status

Gets the status of this SqlTuningSet.

time_created

Gets the time_created of this SqlTuningSet.

time_last_modified

Gets the time_last_modified of this SqlTuningSet.

Methods:

__init__(**kwargs)

Initializes a new SqlTuningSet object with values from keyword arguments.

ALL_SQL_STATEMENTS_FETCHED_NO = 'NO'

A constant which can be used with the all_sql_statements_fetched property of a SqlTuningSet. This constant has a value of “NO”

ALL_SQL_STATEMENTS_FETCHED_YES = 'YES'

A constant which can be used with the all_sql_statements_fetched property of a SqlTuningSet. This constant has a value of “YES”

STATUS_BLOCKED = 'BLOCKED'

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

STATUS_BROKEN = 'BROKEN'

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

STATUS_CHAIN_STALLED = 'CHAIN_STALLED'

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

STATUS_COMPLETED = 'COMPLETED'

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

STATUS_DISABLED = 'DISABLED'

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

STATUS_FAILED = 'FAILED'

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

STATUS_REMOTE = 'REMOTE'

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

STATUS_RESOURCE_UNAVAILABLE = 'RESOURCE_UNAVAILABLE'

A constant which can be used with the status property of a SqlTuningSet. 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 SqlTuningSet. This constant has a value of “RETRY_SCHEDULED”

STATUS_RUNNING = 'RUNNING'

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

STATUS_SCHEDULED = 'SCHEDULED'

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

STATUS_SUCCEEDED = 'SUCCEEDED'

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

__init__(**kwargs)

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

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

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

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

  • statement_count (int) – The value to assign to the statement_count property of this SqlTuningSet.

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

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

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

  • status (str) – The value to assign to the status property of this SqlTuningSet. 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 SqlTuningSet.

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

  • all_sql_statements_fetched (str) – The value to assign to the all_sql_statements_fetched property of this SqlTuningSet. Allowed values for this property are: “YES”, “NO”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

  • sql_list (list[oci.database_management.models.SqlInSqlTuningSet]) – The value to assign to the sql_list property of this SqlTuningSet.

property all_sql_statements_fetched

Gets the all_sql_statements_fetched of this SqlTuningSet. In OCI database management, there is a limit to fetch only 2000 rows. This flag indicates whether all Sql statements of this Sql tuning set matching the filter criteria are fetched or not. Possible values are ‘Yes’ or ‘No’

  • Yes - All Sql statements matching the filter criteria are fetched.

  • No - There are more Sql statements matching the fitler criteria.

    User should fine tune the filter criteria to narrow down the result set.

Allowed values for this property are: “YES”, “NO”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns

The all_sql_statements_fetched of this SqlTuningSet.

Return type

str

property description

Gets the description of this SqlTuningSet. The description of the Sql tuning set.

Returns

The description of this SqlTuningSet.

Return type

str

property error_message

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

Returns

The error_message of this SqlTuningSet.

Return type

str

property id

Gets the id of this SqlTuningSet. The unique Sql tuning set identifier.

Returns

The id of this SqlTuningSet.

Return type

int

property name

[Required] Gets the name of this SqlTuningSet. The name of the Sql tuning set.

Returns

The name of this SqlTuningSet.

Return type

str

property owner

[Required] Gets the owner of this SqlTuningSet. The owner of the Sql tuning set.

Returns

The owner of this SqlTuningSet.

Return type

str

property scheduled_job_name

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

Returns

The scheduled_job_name of this SqlTuningSet.

Return type

str

property sql_list

Gets the sql_list of this SqlTuningSet. A list of the Sqls associated with the Sql tuning set.

Returns

The sql_list of this SqlTuningSet.

Return type

list[oci.database_management.models.SqlInSqlTuningSet]

property statement_count

Gets the statement_count of this SqlTuningSet. Number of statements in the Sql tuning set

Returns

The statement_count of this SqlTuningSet.

Return type

int

property status

Gets the status of this SqlTuningSet. 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 SqlTuningSet.

Return type

str

property time_created

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

Returns

The time_created of this SqlTuningSet.

Return type

datetime

property time_last_modified

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

Returns

The time_last_modified of this SqlTuningSet.

Return type

datetime