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.

property 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

property 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

property 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

property 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

property 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

property 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

property 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

property 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

property 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

property 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

property 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

property executions_count

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

Returns

The executions_count of this SqlStatistics.

Return type

int

property 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

property 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

property 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

property 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

property 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

property 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

property 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