SqlBucket¶
- class oci.opsi.models.SqlBucket(**kwargs)¶
Bases:
objectSql bucket type object.
Methods:
__init__(**kwargs)Initializes a new SqlBucket object with values from keyword arguments.
Attributes:
[Required] Gets the bucket_id of this SqlBucket.
Gets the cpu_time_in_sec of this SqlBucket.
Gets the database_type of this SqlBucket.
Gets the executions_count of this SqlBucket.
Gets the io_time_in_sec of this SqlBucket.
Gets the other_wait_time_in_sec of this SqlBucket.
[Required] Gets the plan_hash of this SqlBucket.
[Required] Gets the sql_identifier of this SqlBucket.
[Required] Gets the time_collected of this SqlBucket.
Gets the total_time_in_sec of this SqlBucket.
Gets the version of this SqlBucket.
- __init__(**kwargs)¶
Initializes a new SqlBucket object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):
- Parameters
version (float) – The value to assign to the version property of this SqlBucket.
database_type (str) – The value to assign to the database_type property of this SqlBucket.
time_collected (datetime) – The value to assign to the time_collected property of this SqlBucket.
sql_identifier (str) – The value to assign to the sql_identifier property of this SqlBucket.
plan_hash (int) – The value to assign to the plan_hash property of this SqlBucket.
bucket_id (str) – The value to assign to the bucket_id property of this SqlBucket.
executions_count (int) – The value to assign to the executions_count property of this SqlBucket.
cpu_time_in_sec (float) – The value to assign to the cpu_time_in_sec property of this SqlBucket.
io_time_in_sec (float) – The value to assign to the io_time_in_sec property of this SqlBucket.
other_wait_time_in_sec (float) – The value to assign to the other_wait_time_in_sec property of this SqlBucket.
total_time_in_sec (float) – The value to assign to the total_time_in_sec property of this SqlBucket.
- property bucket_id¶
[Required] Gets the bucket_id of this SqlBucket. SQL Bucket ID, examples <= 3 secs, 3-10 secs, 10-60 secs, 1-5 min, > 5 min Example: “<= 3 secs”
- Returns
The bucket_id of this SqlBucket.
- Return type
str
- property cpu_time_in_sec¶
Gets the cpu_time_in_sec of this SqlBucket. Total CPU time Example: 1046
- Returns
The cpu_time_in_sec of this SqlBucket.
- Return type
float
- property database_type¶
Gets the database_type of this SqlBucket. Ops Insights internal representation of the database type.
- Returns
The database_type of this SqlBucket.
- Return type
str
- property executions_count¶
Gets the executions_count of this SqlBucket. Total number of executions Example: 60
- Returns
The executions_count of this SqlBucket.
- Return type
int
- property io_time_in_sec¶
Gets the io_time_in_sec of this SqlBucket. Total IO time Example: 5810
- Returns
The io_time_in_sec of this SqlBucket.
- Return type
float
- property other_wait_time_in_sec¶
Gets the other_wait_time_in_sec of this SqlBucket. Total other wait time Example: 24061
- Returns
The other_wait_time_in_sec of this SqlBucket.
- Return type
float
- property plan_hash¶
[Required] Gets the plan_hash of this SqlBucket. Plan hash value for the SQL Execution Plan
- Returns
The plan_hash of this SqlBucket.
- Return type
int
- property sql_identifier¶
[Required] Gets the sql_identifier of this SqlBucket. Unique SQL_ID for a SQL Statement.
- Returns
The sql_identifier of this SqlBucket.
- Return type
str
- property time_collected¶
[Required] Gets the time_collected of this SqlBucket. Collection timestamp Example: “2020-03-31T00:00:00.000Z”
- Returns
The time_collected of this SqlBucket.
- Return type
datetime
- property total_time_in_sec¶
Gets the total_time_in_sec of this SqlBucket. Total time Example: 30917
- Returns
The total_time_in_sec of this SqlBucket.
- Return type
float
- property version¶
Gets the version of this SqlBucket. Version Example: 1
- Returns
The version of this SqlBucket.
- Return type
float