SqlStats¶
- class oci.opsi.models.SqlStats(**kwargs)¶
Bases:
objectSql Stats type object.
Methods:
__init__(**kwargs)Initializes a new SqlStats object with values from keyword arguments.
Attributes:
Gets the action of this SqlStats.
Gets the application_wait_time_in_us of this SqlStats.
Gets the avg_hard_parse_time_in_us of this SqlStats.
Gets the avoided_executions of this SqlStats.
Gets the buffer_gets of this SqlStats.
Gets the child_number of this SqlStats.
Gets the cluster_wait_time_in_us of this SqlStats.
Gets the command_type of this SqlStats.
Gets the concurrency_wait_time_in_us of this SqlStats.
Gets the cpu_time_in_us of this SqlStats.
Gets the delta_cpu_rank of this SqlStats.
Gets the delta_cpu_time of this SqlStats.
Gets the delta_execs_rank of this SqlStats.
Gets the delta_execution_count of this SqlStats.
Gets the delta_io_bytes of this SqlStats.
Gets the delta_io_rank of this SqlStats.
Gets the direct_reads of this SqlStats.
Gets the direct_writes of this SqlStats.
Gets the disk_reads of this SqlStats.
Gets the elapsed_time_in_us of this SqlStats.
Gets the end_of_fetch_count of this SqlStats.
Gets the exact_matching_signature of this SqlStats.
Gets the executions of this SqlStats.
Gets the fetches of this SqlStats.
Gets the force_matching_signature of this SqlStats.
Gets the full_plan_hash_value of this SqlStats.
Gets the harmonic_sum of this SqlStats.
[Required] Gets the instance_name of this SqlStats.
Gets the invalidations of this SqlStats.
Gets the io_cell_offload_eligible_bytes of this SqlStats.
Gets the io_cell_offload_returned_bytes of this SqlStats.
Gets the io_cell_uncompressed_bytes of this SqlStats.
Gets the io_interconnect_bytes of this SqlStats.
Gets the java_exec_time_in_us of this SqlStats.
Gets the last_active_time of this SqlStats.
Gets the loads of this SqlStats.
Gets the module of this SqlStats.
Gets the obsolete_count of this SqlStats.
Gets the optimizer_cost of this SqlStats.
Gets the parse_calls of this SqlStats. Total integer of parse calls Example: 60.
Gets the physical_read_bytes of this SqlStats.
Gets the physical_read_requests of this SqlStats.
Gets the physical_write_bytes of this SqlStats.
Gets the physical_write_requests of this SqlStats.
[Required] Gets the plan_hash_value of this SqlStats.
Gets the plsql_exec_time_in_us of this SqlStats.
Gets the px_servers_executions of this SqlStats.
Gets the rows_processed of this SqlStats.
Gets the serializable_aborts of this SqlStats.
Gets the service of this SqlStats.
Gets the sharable_mem of this SqlStats.
Gets the sharable_mem_rank of this SqlStats.
Gets the sorts of this SqlStats.
[Required] Gets the sql_identifier of this SqlStats.
Gets the sql_patch of this SqlStats.
Gets the sql_plan_baseline of this SqlStats.
Gets the sql_profile of this SqlStats.
[Required] Gets the time_collected of this SqlStats.
Gets the total_sharable_mem of this SqlStats.
Gets the total_sql_count of this SqlStats.
Gets the type_check_mem of this SqlStats.
Gets the user_io_wait_time_in_us of this SqlStats.
Gets the users_executing of this SqlStats.
Gets the users_opening of this SqlStats.
Gets the version_count of this SqlStats.
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