AwrQueryResult

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

Bases: object

The AWR query result.

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.

name

[Required] Gets the name of this AwrQueryResult.

version

Gets the version of this AwrQueryResult.

Methods:

__init__(**kwargs)

Initializes a new AwrQueryResult 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 AwrQueryResult object with values from keyword arguments. This class has the following subclasses and if you are using this class as input to a service operations then you should favor using a subclass over the base class:

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

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

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

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

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