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.
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.
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
description

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

Returns:The description of this SqlTuningSet.
Return type:str
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
id

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

Returns:The id of this SqlTuningSet.
Return type:int
name

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

Returns:The name of this SqlTuningSet.
Return type:str
owner

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

Returns:The owner of this SqlTuningSet.
Return type:str
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
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]
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
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
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
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