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:
AwrDatabaseCpuUsageCollection
AwrDatabaseParameterCollection
AwrDatabaseWaitEventBucketCollection
AwrDatabaseSnapshotRangeCollection
AwrDatabaseSnapshotCollection
AwrDatabaseSysstatCollection
AwrDatabaseMetricCollection
AwrDatabaseWaitEventCollection
AwrDatabaseCollection
AwrDatabaseTopWaitEventCollection
AwrDatabaseParameterChangeCollection
AwrDatabaseReport
AwrDatabaseSqlReport
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’.
-
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
-
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.
-
name
¶ [Required] Gets the name of this AwrQueryResult. The name of the query result.
Returns: The name of this AwrQueryResult. Return type: str
-
version
¶ Gets the version of this AwrQueryResult. The version of the query result.
Returns: The version of this AwrQueryResult. Return type: str
-