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.
`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.

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

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

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

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

buffer_gets¶

Gets the buffer_gets of this SqlStats. Number of Buffer Gets

Returns:	The buffer_gets of this SqlStats.
Return type:	int

child_number¶

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

Returns:	The child_number of this SqlStats.
Return type:	int

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

command_type¶

Gets the command_type of this SqlStats. Oracle command type definition

Returns:	The command_type of this SqlStats.
Return type:	int

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

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

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

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

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

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

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

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

direct_reads¶

Gets the direct_reads of this SqlStats. Number of direct reads

Returns:	The direct_reads of this SqlStats.
Return type:	int

direct_writes¶

Gets the direct_writes of this SqlStats. Number of Direct writes

Returns:	The direct_writes of this SqlStats.
Return type:	int

disk_reads¶

Gets the disk_reads of this SqlStats. Number of disk reads

Returns:	The disk_reads of this SqlStats.
Return type:	int

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

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

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

executions¶

Gets the executions of this SqlStats. Number of executions

Returns:	The executions of this SqlStats.
Return type:	int

fetches¶

Gets the fetches of this SqlStats. Number of fetches

Returns:	The fetches of this SqlStats.
Return type:	int

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

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

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

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

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

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

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

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

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

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

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

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

module¶

Gets the module of this SqlStats. Module name

Returns:	The module of this SqlStats.
Return type:	str

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

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

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

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

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

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

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

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

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

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

rows_processed¶

Gets the rows_processed of this SqlStats. Number of row processed

Returns:	The rows_processed of this SqlStats.
Return type:	int

serializable_aborts¶

Gets the serializable_aborts of this SqlStats. Number of serializable aborts

Returns:	The serializable_aborts of this SqlStats.
Return type:	int

service¶

Gets the service of this SqlStats. Service name

Returns:	The service of this SqlStats.
Return type:	str

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

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

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

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

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

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

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

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

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

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

type_check_mem¶

Gets the type_check_mem of this SqlStats. Typecheck memory

Returns:	The type_check_mem of this SqlStats.
Return type:	int

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

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

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

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

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