AwrDatabaseCollection

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

Bases: AwrQueryResult

The result of AWR query.

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

name

[Required] Gets the name of this AwrQueryResult.

version

Gets the version of this AwrQueryResult.

Methods:

__init__(**kwargs)

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

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

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

  • awr_result_type (str) – The value to assign to the awr_result_type property of this AwrDatabaseCollection. 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.AwrDatabaseSummary]) – The value to assign to the items property of this AwrDatabaseCollection.

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 AwrDatabaseCollection. A list of AWR summary data.

Returns

The items of this AwrDatabaseCollection.

Return type

list[oci.opsi.models.AwrDatabaseSummary]

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