SqlStats

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

Bases: object

Sql Stats type object.

Methods:

__init__(**kwargs)

Initializes a new SqlStats object with values from keyword arguments.

Attributes:

action

Gets the action of this SqlStats.

application_wait_time_in_us

Gets the application_wait_time_in_us of this SqlStats.

avg_hard_parse_time_in_us

Gets the avg_hard_parse_time_in_us of this SqlStats.

avoided_executions

Gets the avoided_executions of this SqlStats.

buffer_gets

Gets the buffer_gets of this SqlStats.

child_number

Gets the child_number of this SqlStats.

cluster_wait_time_in_us

Gets the cluster_wait_time_in_us of this SqlStats.

command_type

Gets the command_type of this SqlStats.

concurrency_wait_time_in_us

Gets the concurrency_wait_time_in_us of this SqlStats.

cpu_time_in_us

Gets the cpu_time_in_us of this SqlStats.

delta_cpu_rank

Gets the delta_cpu_rank of this SqlStats.

delta_cpu_time

Gets the delta_cpu_time of this SqlStats.

delta_execs_rank

Gets the delta_execs_rank of this SqlStats.

delta_execution_count

Gets the delta_execution_count of this SqlStats.

delta_io_bytes

Gets the delta_io_bytes of this SqlStats.

delta_io_rank

Gets the delta_io_rank of this SqlStats.

direct_reads

Gets the direct_reads of this SqlStats.

direct_writes

Gets the direct_writes of this SqlStats.

disk_reads

Gets the disk_reads of this SqlStats.

elapsed_time_in_us

Gets the elapsed_time_in_us of this SqlStats.

end_of_fetch_count

Gets the end_of_fetch_count of this SqlStats.

exact_matching_signature

Gets the exact_matching_signature of this SqlStats.

executions

Gets the executions of this SqlStats.

fetches

Gets the fetches of this SqlStats.

force_matching_signature

Gets the force_matching_signature of this SqlStats.

full_plan_hash_value

Gets the full_plan_hash_value of this SqlStats.

harmonic_sum

Gets the harmonic_sum of this SqlStats.

instance_name

[Required] Gets the instance_name of this SqlStats.

invalidations

Gets the invalidations of this SqlStats.

io_cell_offload_eligible_bytes

Gets the io_cell_offload_eligible_bytes of this SqlStats.

io_cell_offload_returned_bytes

Gets the io_cell_offload_returned_bytes of this SqlStats.

io_cell_uncompressed_bytes

Gets the io_cell_uncompressed_bytes of this SqlStats.

io_interconnect_bytes

Gets the io_interconnect_bytes of this SqlStats.

java_exec_time_in_us

Gets the java_exec_time_in_us of this SqlStats.

last_active_time

Gets the last_active_time of this SqlStats.

loads

Gets the loads of this SqlStats.

module

Gets the module of this SqlStats.

obsolete_count

Gets the obsolete_count of this SqlStats.

optimizer_cost

Gets the optimizer_cost of this SqlStats.

parse_calls

Gets the parse_calls of this SqlStats. Total integer of parse calls Example: 60.

physical_read_bytes

Gets the physical_read_bytes of this SqlStats.

physical_read_requests

Gets the physical_read_requests of this SqlStats.

physical_write_bytes

Gets the physical_write_bytes of this SqlStats.

physical_write_requests

Gets the physical_write_requests of this SqlStats.

plan_hash_value

[Required] Gets the plan_hash_value of this SqlStats.

plsql_exec_time_in_us

Gets the plsql_exec_time_in_us of this SqlStats.

px_servers_executions

Gets the px_servers_executions of this SqlStats.

rows_processed

Gets the rows_processed of this SqlStats.

serializable_aborts

Gets the serializable_aborts of this SqlStats.

service

Gets the service of this SqlStats.

sharable_mem

Gets the sharable_mem of this SqlStats.

sharable_mem_rank

Gets the sharable_mem_rank of this SqlStats.

sorts

Gets the sorts of this SqlStats.

sql_identifier

[Required] Gets the sql_identifier of this SqlStats.

sql_patch

Gets the sql_patch of this SqlStats.

sql_plan_baseline

Gets the sql_plan_baseline of this SqlStats.

sql_profile

Gets the sql_profile of this SqlStats.

time_collected

[Required] Gets the time_collected of this SqlStats.

total_sharable_mem

Gets the total_sharable_mem of this SqlStats.

total_sql_count

Gets the total_sql_count of this SqlStats.

type_check_mem

Gets the type_check_mem of this SqlStats.

user_io_wait_time_in_us

Gets the user_io_wait_time_in_us of this SqlStats.

users_executing

Gets the users_executing of this SqlStats.

users_opening

Gets the users_opening of this SqlStats.

version_count

Gets the version_count of this SqlStats.

wt_harmonic_sum

Gets the wt_harmonic_sum of this SqlStats.

__init__(**kwargs)

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

Parameters
  • sql_identifier (str) – The value to assign to the sql_identifier property of this SqlStats.

  • plan_hash_value (int) – The value to assign to the plan_hash_value property of this SqlStats.

  • time_collected (datetime) – The value to assign to the time_collected property of this SqlStats.

  • instance_name (str) – The value to assign to the instance_name property of this SqlStats.

  • last_active_time (str) – The value to assign to the last_active_time property of this SqlStats.

  • parse_calls (int) – The value to assign to the parse_calls property of this SqlStats.

  • disk_reads (int) – The value to assign to the disk_reads property of this SqlStats.

  • direct_reads (int) – The value to assign to the direct_reads property of this SqlStats.

  • direct_writes (int) – The value to assign to the direct_writes property of this SqlStats.

  • buffer_gets (int) – The value to assign to the buffer_gets property of this SqlStats.

  • rows_processed (int) – The value to assign to the rows_processed property of this SqlStats.

  • serializable_aborts (int) – The value to assign to the serializable_aborts property of this SqlStats.

  • fetches (int) – The value to assign to the fetches property of this SqlStats.

  • executions (int) – The value to assign to the executions property of this SqlStats.

  • avoided_executions (int) – The value to assign to the avoided_executions property of this SqlStats.

  • end_of_fetch_count (int) – The value to assign to the end_of_fetch_count property of this SqlStats.

  • loads (int) – The value to assign to the loads property of this SqlStats.

  • version_count (int) – The value to assign to the version_count property of this SqlStats.

  • invalidations (int) – The value to assign to the invalidations property of this SqlStats.

  • obsolete_count (int) – The value to assign to the obsolete_count property of this SqlStats.

  • px_servers_executions (int) – The value to assign to the px_servers_executions property of this SqlStats.

  • cpu_time_in_us (int) – The value to assign to the cpu_time_in_us property of this SqlStats.

  • elapsed_time_in_us (int) – The value to assign to the elapsed_time_in_us property of this SqlStats.

  • avg_hard_parse_time_in_us (int) – The value to assign to the avg_hard_parse_time_in_us property of this SqlStats.

  • concurrency_wait_time_in_us (int) – The value to assign to the concurrency_wait_time_in_us property of this SqlStats.

  • application_wait_time_in_us (int) – The value to assign to the application_wait_time_in_us property of this SqlStats.

  • cluster_wait_time_in_us (int) – The value to assign to the cluster_wait_time_in_us property of this SqlStats.

  • user_io_wait_time_in_us (int) – The value to assign to the user_io_wait_time_in_us property of this SqlStats.

  • plsql_exec_time_in_us (int) – The value to assign to the plsql_exec_time_in_us property of this SqlStats.

  • java_exec_time_in_us (int) – The value to assign to the java_exec_time_in_us property of this SqlStats.

  • sorts (int) – The value to assign to the sorts property of this SqlStats.

  • sharable_mem (int) – The value to assign to the sharable_mem property of this SqlStats.

  • total_sharable_mem (int) – The value to assign to the total_sharable_mem property of this SqlStats.

  • type_check_mem (int) – The value to assign to the type_check_mem property of this SqlStats.

  • io_cell_offload_eligible_bytes (int) – The value to assign to the io_cell_offload_eligible_bytes property of this SqlStats.

  • io_interconnect_bytes (int) – The value to assign to the io_interconnect_bytes property of this SqlStats.

  • physical_read_requests (int) – The value to assign to the physical_read_requests property of this SqlStats.

  • physical_read_bytes (int) – The value to assign to the physical_read_bytes property of this SqlStats.

  • physical_write_requests (int) – The value to assign to the physical_write_requests property of this SqlStats.

  • physical_write_bytes (int) – The value to assign to the physical_write_bytes property of this SqlStats.

  • exact_matching_signature (str) – The value to assign to the exact_matching_signature property of this SqlStats.

  • force_matching_signature (str) – The value to assign to the force_matching_signature property of this SqlStats.

  • io_cell_uncompressed_bytes (int) – The value to assign to the io_cell_uncompressed_bytes property of this SqlStats.

  • io_cell_offload_returned_bytes (int) – The value to assign to the io_cell_offload_returned_bytes property of this SqlStats.

  • child_number (int) – The value to assign to the child_number property of this SqlStats.

  • command_type (int) – The value to assign to the command_type property of this SqlStats.

  • users_opening (int) – The value to assign to the users_opening property of this SqlStats.

  • users_executing (int) – The value to assign to the users_executing property of this SqlStats.

  • optimizer_cost (int) – The value to assign to the optimizer_cost property of this SqlStats.

  • full_plan_hash_value (str) – The value to assign to the full_plan_hash_value property of this SqlStats.

  • module (str) – The value to assign to the module property of this SqlStats.

  • service (str) – The value to assign to the service property of this SqlStats.

  • action (str) – The value to assign to the action property of this SqlStats.

  • sql_profile (str) – The value to assign to the sql_profile property of this SqlStats.

  • sql_patch (str) – The value to assign to the sql_patch property of this SqlStats.

  • sql_plan_baseline (str) – The value to assign to the sql_plan_baseline property of this SqlStats.

  • delta_execution_count (int) – The value to assign to the delta_execution_count property of this SqlStats.

  • delta_cpu_time (int) – The value to assign to the delta_cpu_time property of this SqlStats.

  • delta_io_bytes (int) – The value to assign to the delta_io_bytes property of this SqlStats.

  • delta_cpu_rank (int) – The value to assign to the delta_cpu_rank property of this SqlStats.

  • delta_execs_rank (int) – The value to assign to the delta_execs_rank property of this SqlStats.

  • sharable_mem_rank (int) – The value to assign to the sharable_mem_rank property of this SqlStats.

  • delta_io_rank (int) – The value to assign to the delta_io_rank property of this SqlStats.

  • harmonic_sum (int) – The value to assign to the harmonic_sum property of this SqlStats.

  • wt_harmonic_sum (int) – The value to assign to the wt_harmonic_sum property of this SqlStats.

  • total_sql_count (int) – The value to assign to the total_sql_count property of this SqlStats.

property action

Gets the action of this SqlStats. Contains the name of the action that was executing when the SQL statement was first parsed, which is set by calling DBMS_APPLICATION_INFO.SET_ACTION

Returns

The action of this SqlStats.

Return type

str

property application_wait_time_in_us

Gets the application_wait_time_in_us of this SqlStats. Application wait time (in microseconds)

Returns

The application_wait_time_in_us of this SqlStats.

Return type

int

property avg_hard_parse_time_in_us

Gets the avg_hard_parse_time_in_us of this SqlStats. Average hard parse time (in microseconds) used by this cursor

Returns

The avg_hard_parse_time_in_us of this SqlStats.

Return type

int

property avoided_executions

Gets the avoided_executions of this SqlStats. Number of executions attempted on this object, but prevented due to the SQL statement being in quarantine

Returns

The avoided_executions of this SqlStats.

Return type

int

property buffer_gets

Gets the buffer_gets of this SqlStats. Number of Buffer Gets

Returns

The buffer_gets of this SqlStats.

Return type

int

property child_number

Gets the child_number of this SqlStats. Number of this child cursor

Returns

The child_number of this SqlStats.

Return type

int

property cluster_wait_time_in_us

Gets the cluster_wait_time_in_us of this SqlStats. Cluster wait time (in microseconds). This value is specific to Oracle RAC

Returns

The cluster_wait_time_in_us of this SqlStats.

Return type

int

property command_type

Gets the command_type of this SqlStats. Oracle command type definition

Returns

The command_type of this SqlStats.

Return type

int

property concurrency_wait_time_in_us

Gets the concurrency_wait_time_in_us of this SqlStats. Concurrency wait time (in microseconds)

Returns

The concurrency_wait_time_in_us of this SqlStats.

Return type

int

property cpu_time_in_us

Gets the cpu_time_in_us of this SqlStats. CPU time (in microseconds) used by this cursor for parsing, executing, and fetching

Returns

The cpu_time_in_us of this SqlStats.

Return type

int

property delta_cpu_rank

Gets the delta_cpu_rank of this SqlStats. Rank based on CPU Consumption

Returns

The delta_cpu_rank of this SqlStats.

Return type

int

property delta_cpu_time

Gets the delta_cpu_time of this SqlStats. CPU time (in microseconds) for the cursor since the last AWR snapshot

Returns

The delta_cpu_time of this SqlStats.

Return type

int

property delta_execs_rank

Gets the delta_execs_rank of this SqlStats. Rank based on number of execution

Returns

The delta_execs_rank of this SqlStats.

Return type

int

property delta_execution_count

Gets the delta_execution_count of this SqlStats. Number of executions for the cursor since the last AWR snapshot

Returns

The delta_execution_count of this SqlStats.

Return type

int

property delta_io_bytes

Gets the delta_io_bytes of this SqlStats. Number of I/O bytes exchanged between the Oracle database and the storage system for the cursor since the last AWR snapshot

Returns

The delta_io_bytes of this SqlStats.

Return type

int

property delta_io_rank

Gets the delta_io_rank of this SqlStats. Rank based on I/O Consumption

Returns

The delta_io_rank of this SqlStats.

Return type

int

property direct_reads

Gets the direct_reads of this SqlStats. Number of direct reads

Returns

The direct_reads of this SqlStats.

Return type

int

property direct_writes

Gets the direct_writes of this SqlStats. Number of Direct writes

Returns

The direct_writes of this SqlStats.

Return type

int

property disk_reads

Gets the disk_reads of this SqlStats. Number of disk reads

Returns

The disk_reads of this SqlStats.

Return type

int

property elapsed_time_in_us

Gets the elapsed_time_in_us of this SqlStats. Elapsed time (in microseconds) used by this cursor for parsing, executing, and fetching.

Returns

The elapsed_time_in_us of this SqlStats.

Return type

int

property end_of_fetch_count

Gets the end_of_fetch_count of this SqlStats. Number of times this cursor was fully executed since the cursor was brought into the library cache

Returns

The end_of_fetch_count of this SqlStats.

Return type

int

property exact_matching_signature

Gets the exact_matching_signature of this SqlStats. exact_matching_signature Example: “18067345456756876713”

Returns

The exact_matching_signature of this SqlStats.

Return type

str

property executions

Gets the executions of this SqlStats. Number of executions

Returns

The executions of this SqlStats.

Return type

int

property fetches

Gets the fetches of this SqlStats. Number of fetches

Returns

The fetches of this SqlStats.

Return type

int

property force_matching_signature

Gets the force_matching_signature of this SqlStats. force_matching_signature Example: “18067345456756876713”

Returns

The force_matching_signature of this SqlStats.

Return type

str

property full_plan_hash_value

Gets the full_plan_hash_value of this SqlStats. Total Number of rows in SQLStats table

Returns

The full_plan_hash_value of this SqlStats.

Return type

str

property harmonic_sum

Gets the harmonic_sum of this SqlStats. Harmonic sum based on ranking parameters

Returns

The harmonic_sum of this SqlStats.

Return type

int

property instance_name

[Required] Gets the instance_name of this SqlStats. Name of Database Instance Example: “DB10902_1”

Returns

The instance_name of this SqlStats.

Return type

str

property invalidations

Gets the invalidations of this SqlStats. Number of times this child cursor has been invalidated

Returns

The invalidations of this SqlStats.

Return type

int

property io_cell_offload_eligible_bytes

Gets the io_cell_offload_eligible_bytes of this SqlStats. Number of I/O bytes which can be filtered by the Exadata storage system

Returns

The io_cell_offload_eligible_bytes of this SqlStats.

Return type

int

property io_cell_offload_returned_bytes

Gets the io_cell_offload_returned_bytes of this SqlStats. Number of bytes that are returned by Exadata cell through the regular I/O path

Returns

The io_cell_offload_returned_bytes of this SqlStats.

Return type

int

property io_cell_uncompressed_bytes

Gets the io_cell_uncompressed_bytes of this SqlStats. Number of uncompressed bytes (that is, size after decompression) that are offloaded to the Exadata cells

Returns

The io_cell_uncompressed_bytes of this SqlStats.

Return type

int

property io_interconnect_bytes

Gets the io_interconnect_bytes of this SqlStats. Number of I/O bytes exchanged between Oracle Database and the storage system. Typically used for Cache Fusion or parallel queries

Returns

The io_interconnect_bytes of this SqlStats.

Return type

int

property java_exec_time_in_us

Gets the java_exec_time_in_us of this SqlStats. Java execution time (in microseconds)

Returns

The java_exec_time_in_us of this SqlStats.

Return type

int

property last_active_time

Gets the last_active_time of this SqlStats. last_active_time Example: “0000000099CCE300”

Returns

The last_active_time of this SqlStats.

Return type

str

property loads

Gets the loads of this SqlStats. Number of times the object was either loaded or reloaded

Returns

The loads of this SqlStats.

Return type

int

property module

Gets the module of this SqlStats. Module name

Returns

The module of this SqlStats.

Return type

str

property obsolete_count

Gets the obsolete_count of this SqlStats. Number of times that a parent cursor became obsolete

Returns

The obsolete_count of this SqlStats.

Return type

int

property optimizer_cost

Gets the optimizer_cost of this SqlStats. Cost of this query given by the optimizer

Returns

The optimizer_cost of this SqlStats.

Return type

int

property parse_calls

Gets the parse_calls of this SqlStats. Total integer of parse calls

Example: 60

Returns

The parse_calls of this SqlStats.

Return type

int

property physical_read_bytes

Gets the physical_read_bytes of this SqlStats. Number of bytes read from disks by the monitored SQL

Returns

The physical_read_bytes of this SqlStats.

Return type

int

property physical_read_requests

Gets the physical_read_requests of this SqlStats. Number of physical read I/O requests issued by the monitored SQL. The requests may not be disk reads

Returns

The physical_read_requests of this SqlStats.

Return type

int

property physical_write_bytes

Gets the physical_write_bytes of this SqlStats. Number of bytes written to disks by the monitored SQL

Returns

The physical_write_bytes of this SqlStats.

Return type

int

property physical_write_requests

Gets the physical_write_requests of this SqlStats. Number of physical write I/O requests issued by the monitored SQL

Returns

The physical_write_requests of this SqlStats.

Return type

int

property plan_hash_value

[Required] Gets the plan_hash_value of this SqlStats. Plan hash value for the SQL Execution Plan

Returns

The plan_hash_value of this SqlStats.

Return type

int

property plsql_exec_time_in_us

Gets the plsql_exec_time_in_us of this SqlStats. PL/SQL execution time (in microseconds)

Returns

The plsql_exec_time_in_us of this SqlStats.

Return type

int

property px_servers_executions

Gets the px_servers_executions of this SqlStats. Total number of executions performed by parallel execution servers (0 when the statement has never been executed in parallel)

Returns

The px_servers_executions of this SqlStats.

Return type

int

property rows_processed

Gets the rows_processed of this SqlStats. Number of row processed

Returns

The rows_processed of this SqlStats.

Return type

int

property serializable_aborts

Gets the serializable_aborts of this SqlStats. Number of serializable aborts

Returns

The serializable_aborts of this SqlStats.

Return type

int

property service

Gets the service of this SqlStats. Service name

Returns

The service of this SqlStats.

Return type

str

property sharable_mem

Gets the sharable_mem of this SqlStats. Total shared memory (in bytes) currently occupied by all cursors with this SQL text and plan

Returns

The sharable_mem of this SqlStats.

Return type

int

property sharable_mem_rank

Gets the sharable_mem_rank of this SqlStats. Rank based on sharable memory

Returns

The sharable_mem_rank of this SqlStats.

Return type

int

property sorts

Gets the sorts of this SqlStats. Number of sorts that were done for the child cursor

Returns

The sorts of this SqlStats.

Return type

int

property sql_identifier

[Required] Gets the sql_identifier of this SqlStats. Unique SQL_ID for a SQL Statement.

Returns

The sql_identifier of this SqlStats.

Return type

str

property sql_patch

Gets the sql_patch of this SqlStats. SQL patch used for this statement, if any

Returns

The sql_patch of this SqlStats.

Return type

str

property sql_plan_baseline

Gets the sql_plan_baseline of this SqlStats. SQL plan baseline used for this statement, if any

Returns

The sql_plan_baseline of this SqlStats.

Return type

str

property sql_profile

Gets the sql_profile of this SqlStats. SQL profile used for this statement, if any

Returns

The sql_profile of this SqlStats.

Return type

str

property time_collected

[Required] Gets the time_collected of this SqlStats. Collection timestamp Example: “2020-03-31T00:00:00.000Z”

Returns

The time_collected of this SqlStats.

Return type

datetime

property total_sharable_mem

Gets the total_sharable_mem of this SqlStats. Total shared memory (in bytes) occupied by all cursors with this SQL text and plan if they were to be fully loaded in the shared pool (that is, cursor size)

Returns

The total_sharable_mem of this SqlStats.

Return type

int

property total_sql_count

Gets the total_sql_count of this SqlStats. Total number of rows in SQLStats table

Returns

The total_sql_count of this SqlStats.

Return type

int

property type_check_mem

Gets the type_check_mem of this SqlStats. Typecheck memory

Returns

The type_check_mem of this SqlStats.

Return type

int

property user_io_wait_time_in_us

Gets the user_io_wait_time_in_us of this SqlStats. User I/O wait time (in microseconds)

Returns

The user_io_wait_time_in_us of this SqlStats.

Return type

int

property users_executing

Gets the users_executing of this SqlStats. Number of users executing the statement

Returns

The users_executing of this SqlStats.

Return type

int

property users_opening

Gets the users_opening of this SqlStats. Number of users that have any of the child cursors open

Returns

The users_opening of this SqlStats.

Return type

int

property version_count

Gets the version_count of this SqlStats. Number of cursors present in the cache with this SQL text and plan

Returns

The version_count of this SqlStats.

Return type

int

property wt_harmonic_sum

Gets the wt_harmonic_sum of this SqlStats. Weight based harmonic sum of ranking parameters

Returns

The wt_harmonic_sum of this SqlStats.

Return type

int