SqlStatistics¶

class oci.opsi.models.SqlStatistics(**kwargs)¶

Bases: object

Performance statistics for the SQL.

Methods

__init__(**kwargs) Initializes a new SqlStatistics object with values from keyword arguments.

Attributes

`average_active_sessions`	[Required] Gets the average_active_sessions of this SqlStatistics.
`change_in_average_active_sessions_in_pct`	[Required] Gets the change_in_average_active_sessions_in_pct of this SqlStatistics.
`change_in_cpu_time_in_pct`	[Required] Gets the change_in_cpu_time_in_pct of this SqlStatistics.
`change_in_executions_per_hour_in_pct`	[Required] Gets the change_in_executions_per_hour_in_pct of this SqlStatistics.
`change_in_inefficiency_in_pct`	[Required] Gets the change_in_inefficiency_in_pct of this SqlStatistics.
`change_in_inefficient_wait_time_in_pct`	[Required] Gets the change_in_inefficient_wait_time_in_pct of this SqlStatistics.
`change_in_io_time_in_pct`	[Required] Gets the change_in_io_time_in_pct of this SqlStatistics.
`change_in_response_time_in_pct`	[Required] Gets the change_in_response_time_in_pct of this SqlStatistics.
`cpu_time_in_sec`	[Required] Gets the cpu_time_in_sec of this SqlStatistics.
`database_time_in_sec`	[Required] Gets the database_time_in_sec of this SqlStatistics.
`database_time_pct`	[Required] Gets the database_time_pct of this SqlStatistics.
`executions_count`	[Required] Gets the executions_count of this SqlStatistics.
`executions_per_hour`	[Required] Gets the executions_per_hour of this SqlStatistics.
`inefficiency_in_pct`	[Required] Gets the inefficiency_in_pct of this SqlStatistics.
`inefficient_wait_time_in_sec`	[Required] Gets the inefficient_wait_time_in_sec of this SqlStatistics.
`io_time_in_sec`	[Required] Gets the io_time_in_sec of this SqlStatistics.
`plan_count`	[Required] Gets the plan_count of this SqlStatistics.
`response_time_in_sec`	[Required] Gets the response_time_in_sec of this SqlStatistics.
`variability`	[Required] Gets the variability of this SqlStatistics.

__init__(**kwargs)¶

Initializes a new SqlStatistics object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters:

database_time_in_sec (float) – The value to assign to the database_time_in_sec property of this SqlStatistics.
executions_per_hour (float) – The value to assign to the executions_per_hour property of this SqlStatistics.
executions_count (int) – The value to assign to the executions_count property of this SqlStatistics.
cpu_time_in_sec (float) – The value to assign to the cpu_time_in_sec property of this SqlStatistics.
io_time_in_sec (float) – The value to assign to the io_time_in_sec property of this SqlStatistics.
inefficient_wait_time_in_sec (float) – The value to assign to the inefficient_wait_time_in_sec property of this SqlStatistics.
response_time_in_sec (float) – The value to assign to the response_time_in_sec property of this SqlStatistics.
plan_count (int) – The value to assign to the plan_count property of this SqlStatistics.
variability (float) – The value to assign to the variability property of this SqlStatistics.
average_active_sessions (float) – The value to assign to the average_active_sessions property of this SqlStatistics.
database_time_pct (float) – The value to assign to the database_time_pct property of this SqlStatistics.
inefficiency_in_pct (float) – The value to assign to the inefficiency_in_pct property of this SqlStatistics.
change_in_cpu_time_in_pct (float) – The value to assign to the change_in_cpu_time_in_pct property of this SqlStatistics.
change_in_io_time_in_pct (float) – The value to assign to the change_in_io_time_in_pct property of this SqlStatistics.
change_in_inefficient_wait_time_in_pct (float) – The value to assign to the change_in_inefficient_wait_time_in_pct property of this SqlStatistics.
change_in_response_time_in_pct (float) – The value to assign to the change_in_response_time_in_pct property of this SqlStatistics.
change_in_average_active_sessions_in_pct (float) – The value to assign to the change_in_average_active_sessions_in_pct property of this SqlStatistics.
change_in_executions_per_hour_in_pct (float) – The value to assign to the change_in_executions_per_hour_in_pct property of this SqlStatistics.
change_in_inefficiency_in_pct (float) – The value to assign to the change_in_inefficiency_in_pct property of this SqlStatistics.

average_active_sessions¶

[Required] Gets the average_active_sessions of this SqlStatistics. Average Active Sessions represent the average active sessions at a point in time. It is the number of sessions that are either working or waiting.

Returns:	The average_active_sessions of this SqlStatistics.
Return type:	float

change_in_average_active_sessions_in_pct¶

[Required] Gets the change_in_average_active_sessions_in_pct of this SqlStatistics. Percent change in Average Active Sessions based on linear regression

Returns:	The change_in_average_active_sessions_in_pct of this SqlStatistics.
Return type:	float

change_in_cpu_time_in_pct¶

[Required] Gets the change_in_cpu_time_in_pct of this SqlStatistics. Percent change in CPU Time based on linear regression

Returns:	The change_in_cpu_time_in_pct of this SqlStatistics.
Return type:	float

change_in_executions_per_hour_in_pct¶

[Required] Gets the change_in_executions_per_hour_in_pct of this SqlStatistics. Percent change in Executions per hour based on linear regression

Returns:	The change_in_executions_per_hour_in_pct of this SqlStatistics.
Return type:	float

change_in_inefficiency_in_pct¶

[Required] Gets the change_in_inefficiency_in_pct of this SqlStatistics. Percent change in Inefficiency based on linear regression

Returns:	The change_in_inefficiency_in_pct of this SqlStatistics.
Return type:	float

change_in_inefficient_wait_time_in_pct¶

[Required] Gets the change_in_inefficient_wait_time_in_pct of this SqlStatistics. Percent change in Inefficient Wait Time based on linear regression

Returns:	The change_in_inefficient_wait_time_in_pct of this SqlStatistics.
Return type:	float

change_in_io_time_in_pct¶

[Required] Gets the change_in_io_time_in_pct of this SqlStatistics. Percent change in IO Time based on linear regression

Returns:	The change_in_io_time_in_pct of this SqlStatistics.
Return type:	float

change_in_response_time_in_pct¶

[Required] Gets the change_in_response_time_in_pct of this SqlStatistics. Percent change in Response Time based on linear regression

Returns:	The change_in_response_time_in_pct of this SqlStatistics.
Return type:	float

cpu_time_in_sec¶

[Required] Gets the cpu_time_in_sec of this SqlStatistics. CPU Time in seconds

Returns:	The cpu_time_in_sec of this SqlStatistics.
Return type:	float

database_time_in_sec¶

[Required] Gets the database_time_in_sec of this SqlStatistics. Database Time in seconds

Returns:	The database_time_in_sec of this SqlStatistics.
Return type:	float

database_time_pct¶

[Required] Gets the database_time_pct of this SqlStatistics. Percentage of Database Time

Returns:	The database_time_pct of this SqlStatistics.
Return type:	float

executions_count¶

[Required] Gets the executions_count of this SqlStatistics. Total number of executions

Returns:	The executions_count of this SqlStatistics.
Return type:	int

executions_per_hour¶

[Required] Gets the executions_per_hour of this SqlStatistics. Number of executions per hour

Returns:	The executions_per_hour of this SqlStatistics.
Return type:	float

inefficiency_in_pct¶

[Required] Gets the inefficiency_in_pct of this SqlStatistics. Percentage of Inefficiency. It is calculated by Total Database Time divided by Total Wait Time

Returns:	The inefficiency_in_pct of this SqlStatistics.
Return type:	float

inefficient_wait_time_in_sec¶

[Required] Gets the inefficient_wait_time_in_sec of this SqlStatistics. Inefficient Wait Time in seconds

Returns:	The inefficient_wait_time_in_sec of this SqlStatistics.
Return type:	float

io_time_in_sec¶

[Required] Gets the io_time_in_sec of this SqlStatistics. I/O Time in seconds

Returns:	The io_time_in_sec of this SqlStatistics.
Return type:	float

plan_count¶

[Required] Gets the plan_count of this SqlStatistics. Number of SQL execution plans used by the SQL

Returns:	The plan_count of this SqlStatistics.
Return type:	int

response_time_in_sec¶

[Required] Gets the response_time_in_sec of this SqlStatistics. Response time is the average elaspsed time per execution. It is the ratio of Total Database Time to the number of executions

Returns:	The response_time_in_sec of this SqlStatistics.
Return type:	float

variability¶

[Required] Gets the variability of this SqlStatistics. Variability is the ratio of the standard deviation in response time to the mean of response time of the SQL

Returns:	The variability of this SqlStatistics.
Return type:	float