SqlInSqlTuningSet¶
- class oci.database_management.models.SqlInSqlTuningSet(**kwargs)¶
Bases:
objectSql information in the Sql tuning set.
Methods:
__init__(**kwargs)Initializes a new SqlInSqlTuningSet object with values from keyword arguments.
Attributes:
Gets the container_database_id of this SqlInSqlTuningSet.
Gets the metrics of this SqlInSqlTuningSet.
Gets the module of this SqlInSqlTuningSet.
[Required] Gets the plan_hash_value of this SqlInSqlTuningSet.
Gets the schema of this SqlInSqlTuningSet.
[Required] Gets the sql_id of this SqlInSqlTuningSet.
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.
- property 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
- property 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
- property module¶
Gets the module of this SqlInSqlTuningSet. The module of the Sql.
- Returns
The module of this SqlInSqlTuningSet.
- Return type
str
- property 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
- property schema¶
Gets the schema of this SqlInSqlTuningSet. The schema name of the Sql.
- Returns
The schema of this SqlInSqlTuningSet.
- Return type
str
- property sql_id¶
[Required] Gets the sql_id of this SqlInSqlTuningSet. The unique Sql identifier.
- Returns
The sql_id of this SqlInSqlTuningSet.
- Return type
str
- property sql_text¶
Gets the sql_text of this SqlInSqlTuningSet. Sql text.
- Returns
The sql_text of this SqlInSqlTuningSet.
- Return type
str