AwrDbCpuUsageCollection¶

class oci.database_management.models.AwrDbCpuUsageCollection(**kwargs)¶

Bases: oci.database_management.models.awr_query_result.AwrQueryResult

The AWR CPU usage data.

Attributes

`AWR_RESULT_TYPE_AWRDB_ASH_CPU_USAGE_SET`	str(object=’’) -> str
`AWR_RESULT_TYPE_AWRDB_DB_PARAMETER_CHANGE`	str(object=’’) -> str
`AWR_RESULT_TYPE_AWRDB_DB_PARAMETER_SET`	str(object=’’) -> str
`AWR_RESULT_TYPE_AWRDB_DB_REPORT`	str(object=’’) -> str
`AWR_RESULT_TYPE_AWRDB_EVENT_HISTOGRAM`	str(object=’’) -> str
`AWR_RESULT_TYPE_AWRDB_EVENT_SET`	str(object=’’) -> str
`AWR_RESULT_TYPE_AWRDB_METRICS_SET`	str(object=’’) -> str
`AWR_RESULT_TYPE_AWRDB_SET`	str(object=’’) -> str
`AWR_RESULT_TYPE_AWRDB_SNAPSHOT_RANGE_SET`	str(object=’’) -> str
`AWR_RESULT_TYPE_AWRDB_SNAPSHOT_SET`	str(object=’’) -> str
`AWR_RESULT_TYPE_AWRDB_SQL_REPORT`	str(object=’’) -> str
`AWR_RESULT_TYPE_AWRDB_SYSSTAT_SET`	str(object=’’) -> str
`AWR_RESULT_TYPE_AWRDB_TOP_EVENT_SET`	str(object=’’) -> str
`awr_result_type`	[Required] Gets the awr_result_type of this AwrQueryResult.
`cpu_count`	Gets the cpu_count of this AwrDbCpuUsageCollection.
`db_query_time_in_secs`	Gets the db_query_time_in_secs of this AwrQueryResult.
`items`	Gets the items of this AwrDbCpuUsageCollection.
`name`	[Required] Gets the name of this AwrQueryResult.
`num_cpu_cores`	Gets the num_cpu_cores of this AwrDbCpuUsageCollection.
`num_cpus`	Gets the num_cpus of this AwrDbCpuUsageCollection.
`query_key`	Gets the query_key of this AwrQueryResult.
`version`	Gets the version of this AwrQueryResult.

Methods

`__init__`(**kwargs)	Initializes a new AwrDbCpuUsageCollection 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'¶

AWR_RESULT_TYPE_AWRDB_DB_PARAMETER_CHANGE = 'AWRDB_DB_PARAMETER_CHANGE'¶

AWR_RESULT_TYPE_AWRDB_DB_PARAMETER_SET = 'AWRDB_DB_PARAMETER_SET'¶

AWR_RESULT_TYPE_AWRDB_DB_REPORT = 'AWRDB_DB_REPORT'¶

AWR_RESULT_TYPE_AWRDB_EVENT_HISTOGRAM = 'AWRDB_EVENT_HISTOGRAM'¶

AWR_RESULT_TYPE_AWRDB_EVENT_SET = 'AWRDB_EVENT_SET'¶

AWR_RESULT_TYPE_AWRDB_METRICS_SET = 'AWRDB_METRICS_SET'¶

AWR_RESULT_TYPE_AWRDB_SET = 'AWRDB_SET'¶

AWR_RESULT_TYPE_AWRDB_SNAPSHOT_RANGE_SET = 'AWRDB_SNAPSHOT_RANGE_SET'¶

AWR_RESULT_TYPE_AWRDB_SNAPSHOT_SET = 'AWRDB_SNAPSHOT_SET'¶

AWR_RESULT_TYPE_AWRDB_SQL_REPORT = 'AWRDB_SQL_REPORT'¶

AWR_RESULT_TYPE_AWRDB_SYSSTAT_SET = 'AWRDB_SYSSTAT_SET'¶

AWR_RESULT_TYPE_AWRDB_TOP_EVENT_SET = 'AWRDB_TOP_EVENT_SET'¶

__init__(**kwargs)¶

Initializes a new AwrDbCpuUsageCollection object with values from keyword arguments. The default value of the awr_result_type attribute of this class is AWRDB_ASH_CPU_USAGE_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 AwrDbCpuUsageCollection.
version (str) – The value to assign to the version property of this AwrDbCpuUsageCollection.
query_key (str) – The value to assign to the query_key property of this AwrDbCpuUsageCollection.
db_query_time_in_secs (float) – The value to assign to the db_query_time_in_secs property of this AwrDbCpuUsageCollection.
awr_result_type (str) – The value to assign to the awr_result_type property of this AwrDbCpuUsageCollection. 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’.
num_cpu_cores (int) – The value to assign to the num_cpu_cores property of this AwrDbCpuUsageCollection.
cpu_count (int) – The value to assign to the cpu_count property of this AwrDbCpuUsageCollection.
num_cpus (float) – The value to assign to the num_cpus property of this AwrDbCpuUsageCollection.
items (list[oci.database_management.models.AwrDbCpuUsageSummary]) – The value to assign to the items property of this AwrDbCpuUsageCollection.

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”

Returns:	The awr_result_type of this AwrQueryResult.
Return type:	str

cpu_count¶

Gets the cpu_count of this AwrDbCpuUsageCollection. The number of CPUs available for the database to use.

Returns:	The cpu_count of this AwrDbCpuUsageCollection.
Return type:	int

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.

items¶

Gets the items of this AwrDbCpuUsageCollection. A list of AWR CPU usage summary data.

Returns:	The items of this AwrDbCpuUsageCollection.
Return type:	list[oci.database_management.models.AwrDbCpuUsageSummary]

name¶

[Required] Gets the name of this AwrQueryResult. The name of the query result.

Returns:	The name of this AwrQueryResult.
Return type:	str

num_cpu_cores¶

Gets the num_cpu_cores of this AwrDbCpuUsageCollection. The number of available CPU cores, which include subcores of multicore and single-core CPUs.

Returns:	The num_cpu_cores of this AwrDbCpuUsageCollection.
Return type:	int

num_cpus¶

Gets the num_cpus of this AwrDbCpuUsageCollection. The number of available CPUs or processors.

Returns:	The num_cpus of this AwrDbCpuUsageCollection.
Return type:	float

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

version¶

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

Returns:	The version of this AwrQueryResult.
Return type:	str