SqlInSqlTuningSet¶

class oci.database_management.models.SqlInSqlTuningSet(**kwargs)¶

Bases: object

Sql information in the Sql tuning set.

Methods

__init__(**kwargs) Initializes a new SqlInSqlTuningSet object with values from keyword arguments.

Attributes

`container_database_id`	Gets the container_database_id of this SqlInSqlTuningSet.
`metrics`	Gets the metrics of this SqlInSqlTuningSet.
`module`	Gets the module of this SqlInSqlTuningSet.
`plan_hash_value`	[Required] Gets the plan_hash_value of this SqlInSqlTuningSet.
`schema`	Gets the schema of this SqlInSqlTuningSet.
`sql_id`	[Required] Gets the sql_id of this SqlInSqlTuningSet.
`sql_text`	Gets the sql_text of this SqlInSqlTuningSet.

__init__(**kwargs)¶

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

Parameters:

sql_id (str) – The value to assign to the sql_id property of this SqlInSqlTuningSet.
sql_text (str) – The value to assign to the sql_text property of this SqlInSqlTuningSet.
container_database_id (int) – The value to assign to the container_database_id property of this SqlInSqlTuningSet.
plan_hash_value (int) – The value to assign to the plan_hash_value property of this SqlInSqlTuningSet.
schema (str) – The value to assign to the schema property of this SqlInSqlTuningSet.
module (str) – The value to assign to the module property of this SqlInSqlTuningSet.
metrics (list[oci.database_management.models.SqlMetrics]) – The value to assign to the metrics property of this SqlInSqlTuningSet.

container_database_id¶

Gets the container_database_id of this SqlInSqlTuningSet. The unique container database identifier.

Returns:	The container_database_id of this SqlInSqlTuningSet.
Return type:	int

metrics¶

Gets the metrics of this SqlInSqlTuningSet. A list of the Sqls associated with the Sql tuning set.

Returns:	The metrics of this SqlInSqlTuningSet.
Return type:	list[oci.database_management.models.SqlMetrics]

module¶

Gets the module of this SqlInSqlTuningSet. The module of the Sql.

Returns:	The module of this SqlInSqlTuningSet.
Return type:	str

plan_hash_value¶

[Required] Gets the plan_hash_value of this SqlInSqlTuningSet. Plan hash value of the Sql statement.

Returns:	The plan_hash_value of this SqlInSqlTuningSet.
Return type:	int

schema¶

Gets the schema of this SqlInSqlTuningSet. The schema name of the Sql.

Returns:	The schema of this SqlInSqlTuningSet.
Return type:	str

sql_id¶

[Required] Gets the sql_id of this SqlInSqlTuningSet. The unique Sql identifier.

Returns:	The sql_id of this SqlInSqlTuningSet.
Return type:	str

sql_text¶

Gets the sql_text of this SqlInSqlTuningSet. Sql text.

Returns:	The sql_text of this SqlInSqlTuningSet.
Return type:	str