AwrDbWaitEventBucketCollection

class oci.database_management.models.AwrDbWaitEventBucketCollection(**kwargs)

Bases: AwrQueryResult

The percentage distribution of waits in the AWR wait event buckets.

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 AwrDbWaitEventBucketCollection.

name

[Required] Gets the name of this AwrQueryResult.

query_key

Gets the query_key of this AwrQueryResult.

total_waits

Gets the total_waits of this AwrDbWaitEventBucketCollection.

version

Gets the version of this AwrQueryResult.

Methods:

__init__(**kwargs)

Initializes a new AwrDbWaitEventBucketCollection 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 AwrDbWaitEventBucketCollection object with values from keyword arguments. The default value of the awr_result_type attribute of this class is AWRDB_EVENT_HISTOGRAM_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 AwrDbWaitEventBucketCollection.

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

  • query_key (str) – The value to assign to the query_key property of this AwrDbWaitEventBucketCollection.

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

  • awr_result_type (str) – The value to assign to the awr_result_type property of this AwrDbWaitEventBucketCollection. 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’.

  • total_waits (int) – The value to assign to the total_waits property of this AwrDbWaitEventBucketCollection.

  • items (list[oci.database_management.models.AwrDbWaitEventBucketSummary]) – The value to assign to the items property of this AwrDbWaitEventBucketCollection.

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 AwrDbWaitEventBucketCollection. A list of AWR wait event buckets.

Returns

The items of this AwrDbWaitEventBucketCollection.

Return type

list[oci.database_management.models.AwrDbWaitEventBucketSummary]

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 query_key

Gets the query_key of this AwrQueryResult. The ID assigned to the query instance.

Returns

The query_key of this AwrQueryResult.

Return type

str

property total_waits

Gets the total_waits of this AwrDbWaitEventBucketCollection. The total waits of the database.

Returns

The total_waits of this AwrDbWaitEventBucketCollection.

Return type

int

property version

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

Returns

The version of this AwrQueryResult.

Return type

str