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.

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

list[oci.database_management.models.SqlMetrics]

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