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