AwrDatabaseParameterCollection

class oci.opsi.models.AwrDatabaseParameterCollection(**kwargs)

Bases: AwrQueryResult

The AWR database parameter data.

Attributes:

AWR_RESULT_TYPE_AWRDB_ASH_CPU_USAGE_SET

A constant which can be used with the awr_result_type property of a AwrQueryResult.

AWR_RESULT_TYPE_AWRDB_DB_PARAMETER_CHANGE

A constant which can be used with the awr_result_type property of a AwrQueryResult.

AWR_RESULT_TYPE_AWRDB_DB_PARAMETER_SET

A constant which can be used with the awr_result_type property of a AwrQueryResult.

AWR_RESULT_TYPE_AWRDB_DB_REPORT

A constant which can be used with the awr_result_type property of a AwrQueryResult.

AWR_RESULT_TYPE_AWRDB_EVENT_HISTOGRAM

A constant which can be used with the awr_result_type property of a AwrQueryResult.

AWR_RESULT_TYPE_AWRDB_EVENT_SET

A constant which can be used with the awr_result_type property of a AwrQueryResult.

AWR_RESULT_TYPE_AWRDB_METRICS_SET

A constant which can be used with the awr_result_type property of a AwrQueryResult.

AWR_RESULT_TYPE_AWRDB_SET

A constant which can be used with the awr_result_type property of a AwrQueryResult.

AWR_RESULT_TYPE_AWRDB_SNAPSHOT_RANGE_SET

A constant which can be used with the awr_result_type property of a AwrQueryResult.

AWR_RESULT_TYPE_AWRDB_SNAPSHOT_SET

A constant which can be used with the awr_result_type property of a AwrQueryResult.

AWR_RESULT_TYPE_AWRDB_SQL_REPORT

A constant which can be used with the awr_result_type property of a AwrQueryResult.

AWR_RESULT_TYPE_AWRDB_SYSSTAT_SET

A constant which can be used with the awr_result_type property of a AwrQueryResult.

AWR_RESULT_TYPE_AWRDB_TOP_EVENT_SET

A constant which can be used with the awr_result_type property of a AwrQueryResult.

awr_result_type

[Required] Gets the awr_result_type of this AwrQueryResult.

db_query_time_in_secs

Gets the db_query_time_in_secs of this AwrQueryResult.

items

Gets the items of this AwrDatabaseParameterCollection.

name

[Required] Gets the name of this AwrQueryResult.

version

Gets the version of this AwrQueryResult.

Methods:

__init__(**kwargs)

Initializes a new AwrDatabaseParameterCollection object with values from keyword arguments.

get_subtype(object_dictionary)

Given the hash representation of a subtype of this class, use the info in the hash to return the class of the subtype.

AWR_RESULT_TYPE_AWRDB_ASH_CPU_USAGE_SET = 'AWRDB_ASH_CPU_USAGE_SET'

A constant which can be used with the awr_result_type property of a AwrQueryResult. This constant has a value of “AWRDB_ASH_CPU_USAGE_SET”

AWR_RESULT_TYPE_AWRDB_DB_PARAMETER_CHANGE = 'AWRDB_DB_PARAMETER_CHANGE'

A constant which can be used with the awr_result_type property of a AwrQueryResult. This constant has a value of “AWRDB_DB_PARAMETER_CHANGE”

AWR_RESULT_TYPE_AWRDB_DB_PARAMETER_SET = 'AWRDB_DB_PARAMETER_SET'

A constant which can be used with the awr_result_type property of a AwrQueryResult. This constant has a value of “AWRDB_DB_PARAMETER_SET”

AWR_RESULT_TYPE_AWRDB_DB_REPORT = 'AWRDB_DB_REPORT'

A constant which can be used with the awr_result_type property of a AwrQueryResult. This constant has a value of “AWRDB_DB_REPORT”

AWR_RESULT_TYPE_AWRDB_EVENT_HISTOGRAM = 'AWRDB_EVENT_HISTOGRAM'

A constant which can be used with the awr_result_type property of a AwrQueryResult. This constant has a value of “AWRDB_EVENT_HISTOGRAM”

AWR_RESULT_TYPE_AWRDB_EVENT_SET = 'AWRDB_EVENT_SET'

A constant which can be used with the awr_result_type property of a AwrQueryResult. This constant has a value of “AWRDB_EVENT_SET”

AWR_RESULT_TYPE_AWRDB_METRICS_SET = 'AWRDB_METRICS_SET'

A constant which can be used with the awr_result_type property of a AwrQueryResult. This constant has a value of “AWRDB_METRICS_SET”

AWR_RESULT_TYPE_AWRDB_SET = 'AWRDB_SET'

A constant which can be used with the awr_result_type property of a AwrQueryResult. This constant has a value of “AWRDB_SET”

AWR_RESULT_TYPE_AWRDB_SNAPSHOT_RANGE_SET = 'AWRDB_SNAPSHOT_RANGE_SET'

A constant which can be used with the awr_result_type property of a AwrQueryResult. This constant has a value of “AWRDB_SNAPSHOT_RANGE_SET”

AWR_RESULT_TYPE_AWRDB_SNAPSHOT_SET = 'AWRDB_SNAPSHOT_SET'

A constant which can be used with the awr_result_type property of a AwrQueryResult. This constant has a value of “AWRDB_SNAPSHOT_SET”

AWR_RESULT_TYPE_AWRDB_SQL_REPORT = 'AWRDB_SQL_REPORT'

A constant which can be used with the awr_result_type property of a AwrQueryResult. This constant has a value of “AWRDB_SQL_REPORT”

AWR_RESULT_TYPE_AWRDB_SYSSTAT_SET = 'AWRDB_SYSSTAT_SET'

A constant which can be used with the awr_result_type property of a AwrQueryResult. This constant has a value of “AWRDB_SYSSTAT_SET”

AWR_RESULT_TYPE_AWRDB_TOP_EVENT_SET = 'AWRDB_TOP_EVENT_SET'

A constant which can be used with the awr_result_type property of a AwrQueryResult. This constant has a value of “AWRDB_TOP_EVENT_SET”

__init__(**kwargs)

Initializes a new AwrDatabaseParameterCollection object with values from keyword arguments. The default value of the awr_result_type attribute of this class is AWRDB_DB_PARAMETER_SET and it should not be changed. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters
  • name (str) – The value to assign to the name property of this AwrDatabaseParameterCollection.

  • version (str) – The value to assign to the version property of this AwrDatabaseParameterCollection.

  • db_query_time_in_secs (float) – The value to assign to the db_query_time_in_secs property of this AwrDatabaseParameterCollection.

  • awr_result_type (str) – The value to assign to the awr_result_type property of this AwrDatabaseParameterCollection. Allowed values for this property are: “AWRDB_SET”, “AWRDB_SNAPSHOT_RANGE_SET”, “AWRDB_SNAPSHOT_SET”, “AWRDB_METRICS_SET”, “AWRDB_SYSSTAT_SET”, “AWRDB_TOP_EVENT_SET”, “AWRDB_EVENT_SET”, “AWRDB_EVENT_HISTOGRAM”, “AWRDB_DB_PARAMETER_SET”, “AWRDB_DB_PARAMETER_CHANGE”, “AWRDB_ASH_CPU_USAGE_SET”, “AWRDB_DB_REPORT”, “AWRDB_SQL_REPORT”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

  • items (list[oci.opsi.models.AwrDatabaseParameterSummary]) – The value to assign to the items property of this AwrDatabaseParameterCollection.

property awr_result_type

[Required] Gets the awr_result_type of this AwrQueryResult. The result type of AWR query.

Allowed values for this property are: “AWRDB_SET”, “AWRDB_SNAPSHOT_RANGE_SET”, “AWRDB_SNAPSHOT_SET”, “AWRDB_METRICS_SET”, “AWRDB_SYSSTAT_SET”, “AWRDB_TOP_EVENT_SET”, “AWRDB_EVENT_SET”, “AWRDB_EVENT_HISTOGRAM”, “AWRDB_DB_PARAMETER_SET”, “AWRDB_DB_PARAMETER_CHANGE”, “AWRDB_ASH_CPU_USAGE_SET”, “AWRDB_DB_REPORT”, “AWRDB_SQL_REPORT”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns

The awr_result_type of this AwrQueryResult.

Return type

str

property db_query_time_in_secs

Gets the db_query_time_in_secs of this AwrQueryResult. The time taken to query the database tier (in seconds).

Returns

The db_query_time_in_secs of this AwrQueryResult.

Return type

float

static get_subtype(object_dictionary)

Given the hash representation of a subtype of this class, use the info in the hash to return the class of the subtype.

property items

Gets the items of this AwrDatabaseParameterCollection. A list of AWR database parameter summary data.

Returns

The items of this AwrDatabaseParameterCollection.

Return type

list[oci.opsi.models.AwrDatabaseParameterSummary]

property name

[Required] Gets the name of this AwrQueryResult. The name of the query result.

Returns

The name of this AwrQueryResult.

Return type

str

property version

Gets the version of this AwrQueryResult. The version of the query result.

Returns

The version of this AwrQueryResult.

Return type

str