AwrDbReport

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

Bases: AwrQueryResult

The result of the AWR report.

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.

FORMAT_HTML

A constant which can be used with the format property of a AwrDbReport.

FORMAT_TEXT

A constant which can be used with the format property of a AwrDbReport.

FORMAT_XML

A constant which can be used with the format property of a AwrDbReport.

awr_result_type

[Required] Gets the awr_result_type of this AwrQueryResult.

content

Gets the content of this AwrDbReport.

db_query_time_in_secs

Gets the db_query_time_in_secs of this AwrQueryResult.

format

Gets the format of this AwrDbReport.

name

[Required] Gets the name of this AwrQueryResult.

query_key

Gets the query_key of this AwrQueryResult.

version

Gets the version of this AwrQueryResult.

Methods:

__init__(**kwargs)

Initializes a new AwrDbReport 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”

FORMAT_HTML = 'HTML'

A constant which can be used with the format property of a AwrDbReport. This constant has a value of “HTML”

FORMAT_TEXT = 'TEXT'

A constant which can be used with the format property of a AwrDbReport. This constant has a value of “TEXT”

FORMAT_XML = 'XML'

A constant which can be used with the format property of a AwrDbReport. This constant has a value of “XML”

__init__(**kwargs)

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

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

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

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

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

  • content (str) – The value to assign to the content property of this AwrDbReport.

  • format (str) – The value to assign to the format property of this AwrDbReport. Allowed values for this property are: “HTML”, “TEXT”, “XML”, ‘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 content

Gets the content of this AwrDbReport. The content of the report.

Returns

The content of this AwrDbReport.

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

property format

Gets the format of this AwrDbReport. The format of the report.

Allowed values for this property are: “HTML”, “TEXT”, “XML”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns

The format of this AwrDbReport.

Return type

str

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

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

Returns

The version of this AwrQueryResult.

Return type

str