AwrDatabaseCpuUsageCollection

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

Bases: oci.opsi.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.
database_cpu_count Gets the database_cpu_count of this AwrDatabaseCpuUsageCollection.
db_query_time_in_secs Gets the db_query_time_in_secs of this AwrQueryResult.
host_cpu_count Gets the host_cpu_count of this AwrDatabaseCpuUsageCollection.
items Gets the items of this AwrDatabaseCpuUsageCollection.
name [Required] Gets the name of this AwrQueryResult.
num_cpu_cores Gets the num_cpu_cores of this AwrDatabaseCpuUsageCollection.
version Gets the version of this AwrQueryResult.

Methods

__init__(**kwargs) Initializes a new AwrDatabaseCpuUsageCollection 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 AwrDatabaseCpuUsageCollection 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 AwrDatabaseCpuUsageCollection.
  • version (str) – The value to assign to the version property of this AwrDatabaseCpuUsageCollection.
  • db_query_time_in_secs (float) – The value to assign to the db_query_time_in_secs property of this AwrDatabaseCpuUsageCollection.
  • awr_result_type (str) – The value to assign to the awr_result_type property of this AwrDatabaseCpuUsageCollection. 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 AwrDatabaseCpuUsageCollection.
  • database_cpu_count (int) – The value to assign to the database_cpu_count property of this AwrDatabaseCpuUsageCollection.
  • host_cpu_count (float) – The value to assign to the host_cpu_count property of this AwrDatabaseCpuUsageCollection.
  • items (list[oci.opsi.models.AwrDatabaseCpuUsageSummary]) – The value to assign to the items property of this AwrDatabaseCpuUsageCollection.
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
database_cpu_count

Gets the database_cpu_count of this AwrDatabaseCpuUsageCollection. The number of CPUs available for the database to use.

Returns:The database_cpu_count of this AwrDatabaseCpuUsageCollection.
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.

host_cpu_count

Gets the host_cpu_count of this AwrDatabaseCpuUsageCollection. The number of available CPUs or processors.

Returns:The host_cpu_count of this AwrDatabaseCpuUsageCollection.
Return type:float
items

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

Returns:The items of this AwrDatabaseCpuUsageCollection.
Return type:list[oci.opsi.models.AwrDatabaseCpuUsageSummary]
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 AwrDatabaseCpuUsageCollection. The number of available CPU cores, which include subcores of multicore and single-core CPUs.

Returns:The num_cpu_cores of this AwrDatabaseCpuUsageCollection.
Return type:int
version

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

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